[Libreoffice-bugs] [Bug 107993] New: FORMATTING: Free space filling broken with thousands separator

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 107993
           Summary: FORMATTING: Free space filling broken with thousands
                    separator
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: benoit.thebaudeau.dev at gmail.com

Description:
Custom format codes using both the free space filling (*) feature and a
thousands separator fail to fill the free space in the spreadsheet for numbers
with an absolute value greater than or equal to 1000. However, the preview in
the format dialog is correct.

Steps to Reproduce:
1. Create a new spreadsheet.
2. Enter 1000 in a cell.
3. Open the cell format dialog for this cell.
4. Apply the following format code to the cell, which should left-align the
sign in the cell and use a blank as a thousands separator (Calc set up for
French):
+* # ##0;-* # ##0

Actual Results:  
The preview displays [+        1 000] as expected, but [        +1 000] is
actually displayed in the cell. The square brackets represent the left and
right borders of the cell.

With 999, [+          999] is displayed in both the preview and the cell as
expected.

Expected Results:
The sign should always be left-aligned:
[+        1 000]


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:53.0) Gecko/20100101
Firefox/53.0

-- 
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/20170521/9ab2afcd/attachment.html>