[Libreoffice-bugs] [Bug 90826] number format with text gives sign at wrong position

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #20 from Laurent BP <jumbo4444 at yahoo.fr> ---
(In reply to Robert Pollak from comment #19)
> For me and four other commenters here this violates the principle of least
> surprise.
> 
> What about the definition:
> If you do not define a format for negative values, then Calc uses the format
> for positive value as default, with "-" inserted in front (or wherever the
> locale demands) of the _actual_number_.
> 
> Why should the sign be anywhere else in this case?

I just described how spreadsheets work from decades.
There exists many conventions to represent negative number (colored in red,
between brackets). The default one was defined as "add a minus sign on the most
left position". If you prefer a different one, you can define it through format
codes given above. Changing default behavior is quite risky.

-- 
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/20200618/7e682d05/attachment.htm>