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

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 Strobbe


> On 10 February 2021 at 20:42 earthballoon <earthballoon@protonmail.com> wrote:
>
>
> Hey there,
> i just spent an hour trying to fix a broken calculation result and almost
> went crazy.
> The issue turned out to be a number with a --> ' <--- in front of it. That
> is not visible, but only in the edit field of the cell.
> In my case it led to a different result than in my accounting software, I
> was summing up a bunch of cells.
>
> Before I had switched from English to German "Locale" settings, so that
> numbers would be displayed with a comma instead of point. I don't know how
> this sign got before the number, but in any case it led to wrong calculating
> result.
>
> I consider this very dangerous, since I rely on the results for pretty
> important stuff....
> And hope that the community picks this up in some way! ;)
> thanks, peace
>
>
>
> --
> Sent from: 
> http://document-foundation-mail-archive.969070.n3.nabble.com/Accessibility-f2006038.html
>
> -- 
> 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

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