On 11.02.2021 16:35, Christophe Strobbe wrote:
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.
as a side note, strings are usually aligned on the left side while
numbers are aligned on the right per default.
There's a tool from "View -> Value Highlighting" that can highlight
numbers, strings, dates with different colours.
In any case this doesn't completely solve the problem when there's one
cell content mismatching the format in a much bigger formula.
MS Excel provides a visual warning on the cell with a different data
type than the rest included in the formula.
An approach like this is more visible and user friendly.
My 2 cents,
IRC: deneb_alpha on Freenode
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/accessibility/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy