[Libreoffice-bugs] [Bug 118324] New: Certain Number Formats not saved correctly in ODF spreadsheets (works in .xlsx)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118324

            Bug ID: 118324
           Summary: Certain Number Formats not saved correctly in ODF
                    spreadsheets (works in .xlsx)
           Product: LibreOffice
           Version: 6.2.0.0.alpha0+ Master
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jim.avera at gmail.com

Description:
Many number formats are corrupted when a spreadsheet is saved in ODF (.ods
file).  

These problems do not exist when saving in .xslx format.


Steps to Reproduce:
1. Open the attached  formatMS.xlsx  file
2. File-SaveAs
       Select ODF Spreadsheet (.ods) format
       Change name to formatODF.ods or similar
       Save
3. File->Reload

Actual Results:
Formats are corrupted.   Select a cell and Rightclick->Format Cells
to view the saved/reloaded format.  Here is what I got:

  ###,###,##0.00 changed to #,##0.00
  ########0.00 change to 0.00
  ########.##### changed to #.#####
  ???????0.00??? changed to #,###.00
  ???,???,??0.00??? changed to #,###.00???

Expected Results:
Formats saved correctly.  Or, if all formats used in a document can not be
saved, the warn the user when saving (or better, when initially setting them).


Reproducible: Always


User Profile Reset: No



Additional Info:
See also: https://bugs.documentfoundation.org/show_bug.cgi?id=117575

The present bug was observed using Version: 6.2.0.0.alpha0+
2018-06-22_05:00:33 Locale: en-US (en_US.UTF-8); Calc: group threaded
(which has the fixes for the above-referenced bug 117575)

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180622/1b140da8/attachment-0001.html>