Download it now!
Bug 103173 - FILESAVE: XLSX - Calc doesn't save/load cell's Number Format language/locale
Summary: FILESAVE: XLSX - Calc doesn't save/load cell's Number Format language/locale
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: interoperability
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Limitations Number-Format XLSX
  Show dependency treegraph
 
Reported: 2016-10-13 05:39 UTC by Mike Kaganski
Modified: 2018-07-04 03:37 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2016-10-13 05:39:39 UTC
If a cell's number format language has been set, saving the sheet as XLSX and reopening it resets this manual setting to Locale seting in Options - Language Settings - Languages

To reproduce:
1. Create a new spreadsheet, add a number to a cell
2. Format->Cells... (Ctrl+1) -> on Numbers tab, set Language to something other than Default
3. Save the file as XLSX and reopen

Expected Results:
The language set in step 2 should stay

Actual Results:
The language of the cell's number format is now reset to default

Tested with Version: 5.2.1.2 (x64)
Build ID: 31dd62db80d4e60af04904455ec9c9219178d620
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
Locale: ru-RU (ru_RU); Calc: group
Comment 1 m.a.riosv 2016-10-13 07:17:01 UTC
Reproducible.
Win10x64
Version: 5.2.2.2 (x64)
Build ID: 8f96e87c890bf8fa77463cd4b640a2312823f3ad
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; 
Locale: es-ES (es_ES); Calc: CL
Version: 5.3.0.0.alpha0+
Build ID: ed5ca17dce1d088ce3fbbb3a30f748ba92cd07d9
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; 
TinderBox: Win-x86@42, Branch:master, Time: 2016-10-09_05:40:51
Locale: es-ES (es_ES); Calc: CL
Comment 2 Yousuf Philips (jay) (retired) 2017-07-03 00:09:46 UTC
This is likely a OOXML limitation as Excel only allows you to set the number format locale for date, time and special number formats.

@Eike: Your thoughts?
Comment 3 Eike Rathke 2017-07-03 10:39:54 UTC
I believe Excel does not support different locales in all number formats. Also ECMA-376-1:2016 Office Open XML does not indicate such thing at page 1783 ff. "18.8.31 numFmts (Number Formats)". The locale / language ID modifier is mentioned only with dates and currencies.

I don't have Excel at hand for the next weeks, someone could try if it accepts something like
[$-409]0.00
for en-US, or
[$-407]0,00
for de-DE, or maybe  [$-407]0.00  (in an otherwise English environment to accept the decimal separator)
and if so whether such survives save/reload.
Comment 4 QA Administrators 2018-07-04 02:49:04 UTC Comment hidden (obsolete)
Comment 5 Mike Kaganski 2018-07-04 03:37:57 UTC
No support in the format indeed; NOTABUG.