[Libreoffice-bugs] [Bug 107993] New: FORMATTING: Free space filling broken with thousands separator
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Sun May 21 16:52:28 UTC 2017
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>
More information about the Libreoffice-bugs
mailing list