[Libreoffice-bugs] [Bug 140052] New: FORMATTING, FILEOPEN, FILESAVE: Custom number cell format changed after save/open file

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Feb 1 08:42:23 UTC 2021


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

            Bug ID: 140052
           Summary: FORMATTING, FILEOPEN, FILESAVE: Custom number cell
                    format changed after save/open file
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: libre at fjkaiser.de

Some (special) cell format is not stored correctly when saving and re-opening
an ODF file.

How to reproduce:
- New calc file
- Insert value "100000.000001" in any cell
- Set number format for the cell to "#.##0,000_.000" (without quotes)
- (Value will be shown like "100.000,000 001", as expected)
- Save file (default format ODF)
- Close file
- Open saved file
- Value is now shown as "100.000,000001 " (note the blank has moved to the end)
- Open cell format dialog, format is now '#.##0,000000" "' (the _. has been
removed, a blank has been inserted at the end)



Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 8; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

-- 
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/20210201/64966cd5/attachment.htm>


More information about the Libreoffice-bugs mailing list