Created attachment 93060 [details] Input is done on the first sheet. The "print" sheet shows the result of a series of calculations that we need to print for our AARP volunteer tax work.. Calculations in the attached document are incorrect in LibreOffice (but correct in OpenOffice) on the "print" sheet on row 26 in the third column. The correct amount ($335) shows in OpenOffice -- but not in Libre. Also, sometimes the exclusion amount calculated on row 16 (in green) is also incorrect. When we open the attached file in Libre, the exclusion amount on the "print" sheet shows to be $18.94. When we retype the input on the "inputs" sheet, this amount changes to $27.95. When we open the attached file in OpenOffice, everything is correct.
It would had been easier to analyze if the sheets weren't password protected so such things as the hidden columns BD:BN could be revealed without fiddling with the document.. however, a simple hard recalculation (Shift+Ctrl+F9) already displayed $335 in print.F26 (what I guess you meant with "row 26 in the third column"). print.F26 : =BF4 => 0; after recalc 335 print.BF4 : =$calculations.T52 => 0; after recalc 335 calculations.T52 : =ROUND(R52*R54,0) => 227; after recalc 335 Note that I loaded the document with macros disabled and didn't investigate yet what they are doing and if that might be related. I presume that the document was stored in an uncalculated state. OpenOffice always recalculates everything upon load hence gets the same results as LibreOffice after recalc. LibreOffice does not recalculate after load if the document was generated with the same version as the version it is loaded in. It would be good to know why the document was saved in such uncalculated state. Was automatic recalculation disabled when saving?
Created attachment 93079 [details] Same file as before -- unprotected I have tracked one Libre error to the following: On the "print" sheet, F26 = BF4 which is supposed to equal =$calculations.T52 (T52 on the "calculations" sheet) -- but it does not. Again, it calculates correctly in OpenOffice, but not Libre. Macros are not needed or used in any calculations. I don't understand "uncalculated state". I am used to the calculations being done immediately as input is made. If I open a new clean document with no input and enter the input, the error in F23 is still there. I can upload a clean document if that would be of any help. Is it ever possible to talk through the questions by phone? We really, really appreciate the help. We have volunteers across the country who are depending on this working Monday. THANKS!
As said in my previous comment, after having the document loaded please hit the key combination Shift+Ctrl+F9 to recalculate the entire document and the results will be correct. For the uncalculated state note that automatic recalculation can be turned off with menu Tools -> Cell Contents -> AutoCalculate. Attaching a clean document with a description what to enter where to reproduce the failure may help.
Created attachment 93148 [details] workbook for Libre or Open Office
THANK YOU, Eike! Yes, the Ctrl-Shift-F9 works great. But I really need it to work automatically. This SimplifiedMethodCalculator is used by thousands of AARP volunteers across the country. It calculates tax exclusions for the seniors and low-income people we serve. Unfortunately, many of our volunteers need things to be automatic. It is automatic with OpenOffice. It is not automatic with the default installation of Libre. Attached is a clean calculator they would start with. Below is sample data you can enter. starting date = 01012012 cost = 5870 joint? = n birth date = 07281941 Your help is GREATLY APPRECIATED! Don't know why you are helping, but know that you are helping thousands of volunteers. THANKS! Kenny
You can Ctrl-Shift-F9 to recalculate, then save the document *just once*. The next time you open it the correct numbers will be displayed.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.2 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-05-02
Created attachment 121720 [details] Autocalculate doesn't happens sheet at this spreadsheet I use LibO version (copy/paste here) Version: 5.0.4.2 Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78 Locale: nb-NO (nb_NO) OS: XP sp3, english version. At sheet "Diverse", the contents of coloumn N doesn't recalculate. Not at file opens nor at manual recalculate (F9). The strange thing is that if I delete sheet "Summary", all the cells in sheet "Diverse" coloumn N seems to recalculate without further action. Somehow that sheet named "Summary" seems to prevent autocalculate from working properly - how can that be? This document was originally created 5 years ago (at least) and is modified many times after that. I cannot recall the original version of LibO was used for creation of the document. Workaround: The Ctrl+Shift+F9 seems to work for me too. No big deal that is, but I didn't know about that this trick before I found this post.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.2.5 or 5.3.0 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170306
same in win10-64 with LOO 5.4.7.2-64 and LOO 6.0.5.1 only ctrl-shift-F9 works like the versions before.
same in win10-64 with LO 6.1.0.3
If I open attachment 93079 [details] in LO 5.2.7, 6.0.6 and 6.2+ I see correct amount ($335) in print.F26 and $27.95 in print.X16. I don't need recalculation. I removed Grobe's comment 8 because it's another file. And it's unclear anyway, doesn't say what is seen and expected. paulystefan's comment is not clear, what it refers to. For the sake of efficiency, I'll close as WFM. If you still reproduce with attachment 93079 [details], please explain.
Note: attachment 121720 [details] is still wrong in 6.2+ but it's either a new bug or I'd rather say Bug 107929. "Recalculation on file load" solves the issue.