https://bugs.documentfoundation.org/show_bug.cgi?id=95677
Bug ID: 95677
Summary: Exponent must have sign when export to Excel
Product: LibreOffice
Version: 5.0.0.0.beta1
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 120387
--> https://bugs.documentfoundation.org/attachment.cgi?id=120387&action=edit
ODF file without sign in exponent for a scientific number
Description: Scientific format may skip sign in exponent (for positive
exponent) with format such as "0.00E00". This format can be save in ODF from
LibO 5.0. See bug 90133. However, Excel is not able to manage such format. So
export to Excel should forced format to show sign in exponent even for positive
exponent with "0.00E+00".
Steps to reproduce:
1. enter a value (>= 1.0) in a cell, for instance 5
2. Format > Cells > Numbers. Change format code to 0.00E00 (without sign in
exponent)
3. OK => display correctly 5.00E00 instead of 5.00E+00 with default scientific
format
4. File > Save in ODF format (see attached document)
5. File > Reload => display is correctly 5.00E00 (from LibO 5.0)
6. File > Save in XLS format
7. open file with Excel 2003
Actual behavior
A warning message appears: "File Error. Some number format may be lost." and
cell is formated as Standard.
Expected behavior
No warning message, cell should be formated to the nearest supported format:
0.00E+00
It is worth if you export to XLSX:
- Excel 2003 (with compatibility module) refuses to open the file
- Excel 2010 can open file with a warning about number format repaired
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
