On 11.02.2021 16:35, Christophe Strobbe wrote:
Hi,
As far as I know, using the single quote to force a spreadsheet to
treat numbers as strings is a feature, not a bug. Perhaps it would be
helpful to make such strings easier to find, but removing this feature
will probably cause problems for peop
Hi,
As far as I know, using the single quote to force a spreadsheet to treat
numbers as strings is a feature, not a bug. Perhaps it would be helpful to make
such strings easier to find, but removing this feature will probably cause
problems for people who rely on it.
Best regards,
Christophe
Made a similar but opposite request in
https://bugs.documentfoundation.org/show_bug.cgi?id=140050. Numbers are treated
as text with a trailing apostrophe (and converted to negative when bracketed).
All spreadsheet tools have this well-known behavior for sake of accessibility.
By default, you se