https://bugs.documentfoundation.org/show_bug.cgi?id=89961
Bug ID: 89961
Summary: Spanned cells not handled when saving to CSV with
"Fixed Column Width" setting
Product: LibreOffice
Version: 4.3.3.2 release
Hardware: Other
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jim.av...@gmail.com
Created attachment 114051
--> https://bugs.documentfoundation.org/attachment.cgi?id=114051&action=edit
Simple spreadsheet with spanned columns
If a spreadsheet is saved in Text (CSV) format and the "Fixed Column Width"
option is selected, the contents of the columns as they are shown on the screen
are written to the file without delimiters, i.e. suitable for posting as plain
ASCII to a blog, etc.
However spanned columns are truncated at the first column in the set. The
content is not allowed to flow into succeeding columns.
For example, if the spreadsheet contains this:
A1 B1 C1 D1
Foo bar this spans C2 D2
A3 B3 Foo bar this spans
You get this when saving as fixed-column-width CSV:
A1 B1 C1 D1
Foo bar thi C2 D2
A3 B3 Foo bar thi
STEPS TO REPRODUCE:
1. Load the attached test.ods
2. File->SaveAs...
3. Select Text CSV (.csv) from the format drop-down
4. Check the "Edit filter settings" checkbox
5. Click Save
6. Check "Fixed Column Widt" in the Field options dialog, and finish
RESULTS: Spanned columns are truncated at the end of the first column in each
span group
EXPECTED RESULTS: Spanned data can flow over all the cells in the span group
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
