Re: [libreoffice-accessibility] Spreadsheet editor: the sign ' makes numbers be ignored

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 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



--
Marina Latini
IRC: deneb_alpha on Freenode

--
To unsubscribe e-mail to: accessibility+unsubscribe@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