<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138872#c8">Comment # 8</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - FORMATTING: Currency format should display $0.00 instead of -$0.00 or $(0.00)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138872">bug 138872</a> from <a class="email" href="mailto:ralacroix@hydro.mb.ca" title="Robert Lacroix <ralacroix@hydro.mb.ca>"> Robert Lacroix</a> <pre>(In reply to Jean-Baptiste Faure from <a href="show_bug.cgi?id=138872#c7">comment #7</a>) > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>