[Libreoffice-bugs] [Bug 128273] FORMATTING Calc changes a number format

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #6 from Eike Rathke <erack at redhat.com> ---
(In reply to Julien Nabet from comment #3)
> Either the format is correct and reopening the file should display the same
> or it's incorrect and there should so error message when trying to save the
> formula, shouldn't it?
The number formatter is file format agnostic and should be.
I'm not sure the original format code with its intention could even be
described in ODF syntax.

However, the minimal reproducer could be 0# which when reloaded is just 0 and
stored as

    <number:number-style style:name="N121">
      <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1"/>
    </number:number-style>

The intention of the format is to prepend a 0 if the number is one digit
(except for the 0 case, but I'm not even sure if that is on purpose), but
that's basically the same for the format code 00 except for the 0 case where it
also displays 00.

Which is stored as

    <number:number-style style:name="N121">
      <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="2"/>
    </number:number-style>

-- 
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/20191022/94820747/attachment-0001.html>