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

[bugzilla-daemon at bugs.documentfoundation.org]

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

Mike Kaganski <mikekaganski at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |WONTFIX

--- Comment #6 from Mike Kaganski <mikekaganski at hotmail.com> ---
Heiko:

It's absolutely correct that Calc tries to convert entered string to a number
when a cell is not pre-formatted as text.
It's absolutely OK that it tries everything it can to convert it, including
treating numeric literal in parentheses as a negative number.
It is not OK to introduce multiple configurations. Your proposal just tries to
disable one of possible matches; so let's continue with another switch "do not
convert strings starting with minus"; "do not convert if it's ISO date"; "do
not convert if it has $ (but do if it has €)", etc.

The proper way to work with Calc is to rely on its automatic conversion
wherever possible, and where you want your entry to be treated as text
unconditionally, use Text cell format prior to entry. Telling "I use all cells
formatted to auto-detect, but want it to understand what I want it not to be
number" is a user error.

-- 
You are receiving this mail because:
You are on the CC list for the bug.