Bug 156430 - FILESAVE: Scientific format export to Excel do not preserve lowercase for exponent
Summary: FILESAVE: Scientific format export to Excel do not preserve lowercase for exp...
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:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-07-23 10:20 UTC by Laurent Balland
Modified: 2023-07-23 10:37 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Laurent Balland 2023-07-23 10:20:13 UTC 
Description:
Scientific notation may use 'e' instead of 'E' for exponent. It is not preserve in ODF (see bug 153993), but it is neither preserved on export to OOXML (Excel). However it is correctly import from XLSX files.

Steps to Reproduce:
1. In Calc, create a scientific number format with 'e' as exponent like 0.00e+0
2. Save to XLSX
3. Reload

Actual Results:
Number format as changed lowercase to uppercase:
0.00E+0

Expected Results:
Number format remains unchanged
0.00e+0


Reproducible: Always


User Profile Reset: No

Additional Info:
Opening file in Excel shows the incorrect format. If you correct it, save and open file in LibO, format is correctly set
Comment 1 Laurent Balland 2023-07-23 10:37:11 UTC 
I was wrong. Excel is unable to use scientific format with lowercase for exponent.
Sorry for the noise.