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@lists.freedesktop.org
Reporter: benoit.thebaudeau....@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs