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 see numbers right-aligned while text is left.
Some kind of data type highlighter could be handy, OTOH. What I have in mind is
a command that toggles all formatting off and shows text with a certain
background color, numbers, formulas etc.
On 10.02.21 20:42, earthballoon 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
--
Dr. Heiko Tietze, UX-Designer and UX-Mentor
Tel: +49 30 5557992-63 | Mail: heiko.tie...@documentfoundation.org
The Document Foundation, Kurfürstendamm 188, 10707 Berlin, DE
Gemeinnützige rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: https://www.documentfoundation.org/imprint
--
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
