https://bugs.documentfoundation.org/show_bug.cgi?id=94945
Bug ID: 94945
Summary: FORMATTING : Certain personalized number formats are
lost when reload spreadsheet
Product: LibreOffice
Version: 4.4.2.2 release
Hardware: x86 (IA32)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
If the personalized numeric format #,99# is saved and applied in a spreadsheet,
and the document is saved and reloaded, the format is no longer defined, and
all the cells so formatted are now formatted as "standard".
Thus displaying 0 and ,8 and ,88 and ,888
. . . . . as 0 and 0,8 and 0,88 and 0,888 respectively,
instead of ,00 and ,80 and ,88 and ,888 as expected.
If custom format #,999 did not exist before save, after restarting Libo it has
been created.
If such a custom format already exists, after restarting Libo it is not used by
the cells formatted as #,99#
Previously libreoffice consistently displayed this format correctly.
Not sure when it stopped working as I haven't used this format much for a
while, until I started using it intensively recently. The last version of
Libreoffice used before the current version was 3.*
This has been tested numerous times and the error ALWAYS occurs.
The computer used has been rebooted many times between tests.
This format is used to display numbers which may be percentages, or per
thousand, in a more readable format.
There is no easy workaround. Redoing the format on a large spreadsheet is very
time consuming.
--
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
