Created attachment 124913 [details] LOcalc sum function treats apparent numbers as 0 if storage is not numeric c7 = number c8 displays as a number but is not c7+c7 gives the anticipated answer sum(c7:c8) treats c8 as 0 and gives a wrong answer without warning. Sometimes but not always, I see a single quote (') preceding the "number". In the attached, I could not see how to fix this problem.
I tested this with LO 5.1.2.2, 5.0.4.2, and 4.4.0.2
Calc is very strict in accept text as number in formulas, and only try to convert text to values in direct references, but none in a SUM() function. Resolved as notabug, please if you are not agree reopen it.
Thanks for the review. My real problem is that when I paste a number like $1,234.56 into a cell, sometimes it is converted to numeric and sometimes it stays as character, which looks like a number and computes as a number with "+" but not "sum". Worse, I could not find an easy way to convert the text into a number. Sometimes the number starts with a single quote, like ('1234). If I see that, I can remove the single quote. Otherwise, I can't just type the number over, because the cell is now committed to text. I tried typing the number in manually without "$" and "," and found that the cell was committed to text and converted the number to text. I have to insert a new cell, carefully enter the number manually, then manually delete the cell committed to text. You are correct, that it's not a problem with "sum" -- nor with "+": If either were changed, it would break lots of spreadsheets people have used for years. Thanks, Spencer Graves
In Ask you can find help about how to deal with numbers as text, searching 'numbers text calc', e.g. https://ask.libreoffice.org/en/question/1843/changing-text-to-numbers/ What is the bug? Please detail step by step, from where you got the data, and how do you enter them in the spreadsheet?, so someone can try to reproduce the issue.
(In reply to m.a.riosv from comment #4) > Please detail step by step, from where you got the data, and how do you > enter them in the spreadsheet?, so someone can try to reproduce the issue. Spencer: Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the information.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170502
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-20170531