[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 #5 from Eike Rathke <erack at redhat.com> ---
Meanwhile the bug submitter found out that what he actually needed instead is
" 0 " #" "##" "##" "##" "##

The problem with the reported format is that it is ambiguous regarding the use
of 0 and #. While it works in the number formatter when entered, it can't be
stored as format description to ODF which results in

    <number:number-style style:name="N121">
      <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="1">
        <number:embedded-text number:position="8"> </number:embedded-text>
        <number:embedded-text number:position="6"> </number:embedded-text>
        <number:embedded-text number:position="4"> </number:embedded-text>
        <number:embedded-text number:position="2"> </number:embedded-text>
      </number:number>
    </number:number-style>


Whereas
" 0 " #" "##" "##" "##" "##
is stored as

    <number:number-style style:name="N121">
      <number:text> 0  </number:text>
      <number:number number:decimal-places="0" loext:min-decimal-places="0"
number:min-integer-digits="0">
        <number:embedded-text number:position="8"> </number:embedded-text>
        <number:embedded-text number:position="6"> </number:embedded-text>
        <number:embedded-text number:position="4"> </number:embedded-text>
        <number:embedded-text number:position="2"> </number:embedded-text>
      </number:number>
    </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/446837e7/attachment-0001.html>