https://bugs.documentfoundation.org/show_bug.cgi?id=172696
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |WORKSFORME --- Comment #11 from ady <[email protected]> --- (In reply to carl from comment #10) > I guess that leaves two questions in my mind: > > 1. What's with the adding a single quote when trying to format as a numeric > value? The initial hidden single quotation mark (aka apostrophe) is a way for spreadsheet tools to differentiate between a real numeric value vs a value that looks as a number but it is actually Text (and so it should be treated as such). Other tools use the same method. > > 2. Why is the behavior different when summing a range vs individually adding > the same elements? The simple addition assumes that a value that can be treated as a number, should, even when it is a Text cell. The SUM() function has different assumptions, constraints, and use cases. I am assuming that, not only that you solved your problem, but that there is no bug to report here. Please next time use a forum such as <https://ask.libreoffice.org>, leaving Bugzilla for actual bug reports. -- You are receiving this mail because: You are the assignee for the bug.
