[Libreoffice-bugs] [Bug 138872] FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Robert Lacroix <ralacroix at hydro.mb.ca> ---
(In reply to Jean-Baptiste Faure from comment #7)
> I reproduce, but I prefer, in your steps to reproduce, the behavior for
> currency to the behavior for general numbers. -0,00€ shows that the value is
> not strictly equal to zero, where 0,00 does not. The minus sign make easier
> to understand why, if you multiply this zero value by 10000, you get a non
> zero value.
> 
> Best regards. JBF

A sign debugging tool would be a good undertaking, but to be useful and
consistent, positive numbers displaying as 0 should also show their sign as
well, i.e. display as +0,00. If I want a debugging tool in my spreadsheet, I
prefer that this be a controllable option.

Furthermore, do not confound the debugging tool with a display convention for
signed numbers. I suggest appending the sign debugging indicator on the right
side of 0, so 0- or 0+.

If the sign debugging tool is off, just display 0 without a sign as the title
suggests, as this might be a report published for public consumption.

-- 
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/20210812/7be4b9de/attachment.htm>