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