Description: It seems like a good start but lots of calculation errors in the knock off Excel package. It can't auto sum. I entered my data clicked the sum button, everything highlighted right, but it failed to calculate. No, I did not have words in my formula it was all numbers, been using Excel and Open Office for years. If you click sum all it does is =sum (#:#) where # is your data. It will post either the formula or #### in the cell. I even did it the old fashioned way by entering =#+#+# and still it would not compute. I double checked it by doing a small sum in another column with 5 numbers and same error. I even read the manual to make sure I did it right and it still failed to compute a simple 1+1. I have to forward my data to another computer with Excel for correct calculation which worked in seconds. Actual Results: It seems like a good start but lots of calculation errors in the knock off Excel package. It can't auto sum. I entered my data clicked the sum button, everything highlighted right, but it failed to calculate. No, I did not have words in my formula it was all numbers, been using Excel and Open Office for years. If you click sum all it does is =sum (#:#) where # is your data. It will post either the formula or #### in the cell. I even did it the old fashioned way by entering =#+#+# and still it would not compute. I double checked it by doing a small sum in another column with 5 numbers and same error. I even read the manual to make sure I did it right and it still failed to compute a simple 1+1. I have to forward my data to another computer with Excel for correct calculation which worked in seconds. Hopefully you can fix it. Expected Results: Nada it only entered ###in the cell no matter the size of the cell or it repeated the formula. Reproducible: Always User Profile Reset: No Additional Info: Summation in seconds like Excel. User-Agent: Mozilla/5.0 (Linux; Android 7.0; SM-T813 Build/NRD90M) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.137 Safari/537.36
Please attach a sample spreadsheet, and give the LibreOffice version you tried with.
deactivate menu View -> Show Formula
Created attachment 140637 [details] currency calcualtions
I have attached a sample spreadsheet. See columns E and F...the totals are both incorrect.
Anne, are you the original reporter? What's the expected value, and what are you actually getting? Additionally, which LibreOffice version are you using?
I am not the original reporter. I found this as I was getting ready to report. Both columns are off by $.02 when I add by hand or using Excel. I have made sure that Auto Calc is turned on, and attempted a recalculation, although nothing happens. I upgraded to 5.4.5.1, but still does not sum properly.
(In reply to Anne from comment #6) > I am not the original reporter. I found this as I was getting ready to > report. Both columns are off by $.02 when I add by hand or using Excel. I > have made sure that Auto Calc is turned on, and attempted a recalculation, > although nothing happens. I upgraded to 5.4.5.1, but still does not sum > properly. I checked this both in Excel and LibreOffice, and the results correspond to each other within at least 5 decimals (surely more). I don't know what you did, if you copied values from one program to another, make sure the columns are calculated in both software, and the number of displayed decimals in the final sum is set to the same in both Excel and Calc.
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-20181009
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-20181105