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+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
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 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+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 > -- 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
Re: [libreoffice-accessibility] Spreadsheet editor: the sign ' makes numbers be ignored
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
