Bug 107993 - FORMATTING: Free space filling broken with thousands separator
Summary: FORMATTING: Free space filling broken with thousands separator
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 118338 (view as bug list)
Depends on:
Blocks: Number-Format
  Show dependency treegraph
 
Reported: 2017-05-21 16:52 UTC by Benoît Thébaudeau
Modified: 2023-08-24 11:54 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Benoît Thébaudeau 2017-05-21 16:52:28 UTC
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
Comment 1 m_a_riosv 2017-05-22 08:23:33 UTC
Seems the issue is with the space as thousand separator, changing to do works fine.
Works fine on other languages like English US, Spanish or Galician.
Comment 2 QA Administrators 2018-05-23 02:35:55 UTC Comment hidden (obsolete)
Comment 3 Aron Budea 2018-06-25 01:12:25 UTC
*** Bug 118338 has been marked as a duplicate of this bug. ***
Comment 4 Aron Budea 2018-06-25 01:13:49 UTC
Still in 6.1 beta2, see attachment 143062 [details].
Comment 5 Laurent Balland 2018-06-30 22:14:53 UTC
In https://opengrok.libreoffice.org/xref/core/svl/source/numbers/zformat.cxx#ImpNumberFillWithThousands
bStarFlag is false whereas it should be true
I wonder where (and why) bStarFlag has been changed...
Comment 6 Xisco Faulí 2018-10-04 16:56:53 UTC
Dear Laurent BP,
This bug has been in ASSIGNED status for more than 3 months without any
activity. Resetting it to NEW.
Please assigned it back to yourself if you're still working on this.
Comment 7 Laurent Balland 2019-08-16 17:31:52 UTC
Reproduced with Version: 6.3.0.4
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
Threads CPU : 8; OS : Linux 4.15; UI Render : par défaut; VCL: gtk3; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

Same bug with format
+*\# ##0
Comment 8 QA Administrators 2021-08-16 03:48:41 UTC Comment hidden (obsolete)
Comment 9 Laurent Balland 2021-08-17 10:03:18 UTC
Reproduce with both format codes:
+*\# ##0
+* # ##0;-* # ##0
Version: 7.1.5.2 (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded
Comment 10 QA Administrators 2023-08-18 03:05:35 UTC Comment hidden (obsolete)
Comment 11 Laurent Balland 2023-08-24 11:54:20 UTC
Confirmed with Version: 7.5.4.2 (X86_64) / LibreOffice Community
Build ID: 36ccfdc35048b057fd9854c757a8b67ec53977b6
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); UI: fr-FR
Calc: threaded