https://bugs.documentfoundation.org/show_bug.cgi?id=169583
Bug ID: 169583
Summary: Issue with user-defined number format when the number
is negative
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I intented to create a user-defined number format consisting of a symbol and a
number with two decimals, so I typed this:
"▼ "0,00
It seemed to work, until, when the number became negative, it displayed this:
-▼ 18,67
As you can see, the minus sign appears not attached to the number, but at the
beginning of the string.
I wasn't sure if I was missing something and whether, somehow, this could be
expected behaviour, so I tried to Google the question and I found this
solution:
"▼ "+0,00;"▼ "-0,00;"▼ "0,00
Which I turned into this, as the plus sign was unnecesary to me:
"▼ "0,00;"▼ "-0,00;"▼ "0,00
I was going to leave there, as it worked for me, but the more I saw it, the
more I found this solution far from intuitive for a regular user and certainly
for me.
Therefore, I still believe the minus sign should be attached to the number, as
it's part of the number.
Steps to Reproduce:
1. You create a user-defined number format such as:
"▼ "0,00
2. You make sure the number it takes is negative.
Actual Results:
When the number is negative, the minus sign appears at the beginning of the
string:
-▼ 18,67
Expected Results:
When the number is negative, the minus sign should be attached to the number,
as it's part of the number:
▼ -18,67
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 25.8.3.2 (X86_64)
Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e
CPU threads: 16; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
