Bug ID: 102370
           Summary: Exponent without sign can be exported to Excel
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc

User-Agent:       Mozilla/5.0 (X11; Linux x86_64; rv:48.0) Gecko/20100101
Build Identifier: 5.0.4

Resolution of bug 95677 was not correct: actually Excel does support exponent
without sign (for positive exponent) with minus sign instead of plus sign.
For instance, format
represents PI() as 3.14E00

Reproducible: Always

Steps to Reproduce:
1. Format > Cells > Number > Scientific
2. Remove sign in exponent, for instance 0.00E00
3. Export to Excel format
4. File > Reload
Actual Results:  
Format is changed to 0.00E+00

Expected Results:  
Format should remain without sign in exponent

Format 0.00E-00 is correctly interpreted during import of Excel file, but fails
during export to ODF: it is modified in 0.00E+00

Reset User Profile?No

You are receiving this mail because:
You are the assignee for the bug.
Libreoffice-bugs mailing list

Reply via email to