Bug 81939 - FORMATTING: Opening xlsx alters number format code 00\.00\.00\.000\.0 to 00.00.00.000.0
Summary: FORMATTING: Opening xlsx alters number format code 00\.00\.00\.000\.0 to 00.0...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: 4.2.4.2 release
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-07-31 04:48 UTC by w.a.rummler
Modified: 2014-08-01 05:56 UTC (History)
0 users

See Also:
i915 platform:
i915 features:

Attachments
Small example where cell format string is not preserved on LO re-open. (4.10 KB, text/plain)
2014-07-31 04:48 UTC, w.a.rummler 		Details
View All

Description w.a.rummler 2014-07-31 04:48:59 UTC 
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.
Comment 1 Owen Genat 2014-08-01 05:56:44 UTC 
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.