https://bugs.documentfoundation.org/show_bug.cgi?id=140050
Mike Kaganski <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |WONTFIX
--- Comment #6 from Mike Kaganski <[email protected]> ---
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 the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
