https://bugs.documentfoundation.org/show_bug.cgi?id=149428
Bug ID: 149428
Summary: Formatting of number AFTER the decimal point not saved
in .ods
Product: LibreOffice
Version: 7.1.6.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: r435g391b823-comp176...@yahoo.com.au
Description:
Cell Number Format is lost when sheet is saved and closed/reopened, or
reloaded.
The formatting that is lost are any user defined formats for the numbers AFTER
the decimal point. when the format is changed it works, then when the sheet is
reloaded it is munged.
Eg format #,##0.0000_i0000_i00 correctly formats a number to 0.0001 5299 00
But after closing/reloading becomes #,##0.0000000000" " and the number
formatting is lost.
Doesn't affect .xlsx and .xlsm format sheets, but I lose all my buttons and
macros in those save file format versions.
Updated libreOffice to latest 7.3.3.2 release and still occurs as described
above.
Steps to Reproduce:
1.Place a number in a cell with 2 or more digits After the decimal point, eg
0.0000158932. I use mainly 8, 10 and 12 digits after the dot.
2. Change formatting of that cell to user defined format which formats the
numbers AFTER the decimal point, eg #,##0.0000_i000_i000. Any formatting such
as _i or _M or " " or \- or \ , anything that makes the numbers more
readable.
Eg #,##0.0000_i0000_i00, which correctly formats a number to 0.0001 5299 00
3. Save the sheet, and either close/reopen or FileMenu->Reload it.
4. The cell becomes a long string of unformatted digits again, and the user
defined format string has changed, eg #,##0.0000_i0000_i00 becomes
#,##0.0000000000" " and the number formatting is lost. The number of spaces
now appearing in double-quote marks at the end of the format string bears some
relationship to the formatting/spaces in the working format before
saving/closing.
Actual Results:
Cell format changes and numbers are no longer formatted as they were.
Expected Results:
Formatting of numbers after the decimal point should be retained.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.3.3.2 (x64) / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
