[Libreoffice-bugs] [Bug 140050] Do not autoformat numbers in brackets

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from V Stuart Foote <vstuart.foote at utsa.edu> ---
(In reply to Heiko Tietze from comment #4)
> (In reply to V Stuart Foote from comment #3)
> > Parenthesis brackets are accepted norm for the *value* input of negative
> > numbers.
> 
> And that's the question here. Why? And where? Again: I understand
> parentheses as better or rather alternative indicator but this functions
> turns it around. What is the use case (beyond confusing Benjamin users) to
> convert (1) into -1?

It is a standard spreadsheet number entry format, when you enter (1) you are
entering a negative 1.0

You can format Calc's display of negative numbers so entry can continue to be
represented as (1).  But it is still a negative 1.0; that is what is entered.

Treating it as NAN requires use of the prepended apostrophe.

-- 
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/20210201/8d478d46/attachment.htm>