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.

yep, agree.
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,

Marina Latini
IRC: deneb_alpha on Freenode

To unsubscribe e-mail to: accessibility+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/accessibility/
Privacy Policy: https://www.documentfoundation.org/privacy

Reply via email to