| Summary: | FORMATTING: Opening xlsx alters number format code 00\.00\.00\.000\.0 to 00.00.00.000.0 | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | w.a.rummler |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | ||
| Version: | 4.2.4.2 release | ||
| Hardware: | All | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: | Small example where cell format string is not preserved on LO re-open. | ||
Confirmed under GNU/Linux x86_64 using v4.2.5.2. Status set to NEW. Platform to All. Minor amendment to summary. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 103715 [details] 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.