https://bugs.documentfoundation.org/show_bug.cgi?id=98908
Bug ID: 98908
Summary: Formatting information gets corrupted when saving to
XLSX
Product: LibreOffice
Version: 5.0.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 123870
--> https://bugs.documentfoundation.org/attachment.cgi?id=123870&action=edit
Column width error
There are three formatting related issues that occur if a file gets saved in
new Excel format (XLSX):
- if exact value for column width is set, respective value erroneously gets
slightly decremented
- if indent is set for a cell, this value erroneously gets incremented
- if two or more font sizes are used within a cell, those different font sizes
are not stored correctly
All those problems occur regardless whether the content gets input directly
into a blank (new) LibreOffice Calc document or any existing (e.g. XLS or ODS)
document is converted into XLSX via File ==> Save as.
None of the problems occur if the data are saved to to "old" (binary) Excel
format (XLS).
Hence, I attached three simple XLS files for demonstration. Simply open them
and save them as XLSX, but keep the application open.
Now open the XLSX files and compare the column widths, text indentations and
font-sizes of the cells for each document.
You can easily see the undesired differences mentioned above.
Thanks in advance for examining these issues which I guess might cause several
people some trouble when working with modern MS Excel documents.
Andreas Hüller
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
