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