https://bugs.freedesktop.org/show_bug.cgi?id=81939
Priority: medium
Bug ID: 81939
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FORMATTING: Opening xlsx alters cell format string
00\.00\.00\.000\.0 to 00.00.00.000.0
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: w.a.rumm...@gmail.com
Hardware: x86 (IA32)
Status: UNCONFIRMED
Version: 4.2.4.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 103715
--> https://bugs.freedesktop.org/attachment.cgi?id=103715&action=edit
Small example where cell format string is not preserved on LO re-open.
Lubuntu 14.04 with up-to-date repo LO.
The attached file was created by entering 202100083 in A1 and setting the cell
format string to "00\.00\.00\.000\.0" (without quotes) then saving as xlsx.
When it's reopened in LO, the format string is changed to "00.00.00.000.0"
(without quotes).
I'm pretty sure that whatever's happening is happening during the LO open
operation, since the format string looks fine in the XML and e.g. is imported
fine by EPPlus.
Also tested on a separate Windows 7 Excel 2013 installation, and the format was
preserved there on reopening.
Does not occur with ods.
--
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
