Created attachment 138626 [details] many "DIV/0 !" are false Hello and merry christmas to all My problem is that LibreOffice Calc no longer calculates the results. Nevertheless during the creation of the file it worked well, and after having backup a lot during its creation. But when I reopens the results are no longer calculated. Why ? Or is it a bug?
Hi, thanks for the report. Unfortunately, it's impossible to do anything useful based on the PNG you've attached. Please provide a sample spreadsheet, where the problem is reproducible. Please reset the status back to UNCONFIRMED after attaching the required data.
The file size is too big for the posted how do you communicate it?
How do you communicate the file.xls of more than 30 000ko, it is 52.7 MB
Well, could you provide just a small part of it, with most data removed, only some rows that take part in calculations of one failing value? Otherwise, you could try using some public sharing service, like Dropbox.
Round trip to .xls binary? Any better if you save to native ODF .ods format? Also, 5.1.6.2 is rather dated/unsupported, perhaps move to 5.3.7.2, 5.4.4.2 or even the 6.0.0 rc1.
Created attachment 138627 [details] Reduced file here is the reduced file
for V stuart Foote This is exactly the same problem in file.ods version
Ok; so which cell contains the wrong #DIV/0? or all of those cells with #DIV/0 are wrong? Specifically: I4 is equal to T4; their difference is zero; so #DIV/0 in row 4 (starting with W4 and X4, where the divisor is (I4-T4)) are correct.
Created attachment 138628 [details] line 10 For line 4 # DIV / 0 is correct. But not for the other lines. See example line 10
Well, actually I can see that it takes several (3?) full recalcs (Ctrl+Shift+F9) to refresh all the values... Eike, could you please tell it this normal?
If I copy a line to a new file, LibreOffice Calc works fine. I wonder if there is a button to recalculate everything in the original file (87000 lines).
I'm sorry I have to leave. I will return tomorrow.
So, is this a bug or is there a solution?
Merry Christmas to all row10 is ok column AB => AG all #div/0 can reproduce with Version: 5.3.1.2 Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2 CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: kde4; Layout Engine: new; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 5.4.5.0.0+ Build ID: a61f45499856aad9910d82af1312a163504c15c2 CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group but not with Version: 6.0.0.1.0+ Build ID: 4ca94f24995c8d7b854e2d98fd7ff8fa7b9e2157 CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; Locale: nl-BE (en_US.UTF-8); Calc: group Version: 6.1.0.0.alpha0+ Build ID: 86a939d5fd93173949447337738fa0625803ec92 CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-12-25_09:06:24 Locale: nl-BE (en_US.UTF-8); Calc: group threaded
(In reply to chiappini from comment #13) This is indeed a bug. As Xavier Van Wijmeersch have mentioned in comment 14, this problem is not present in latest development versions (I confirm this with Version: 6.1.0.0.alpha0+ (x64) Build ID: ab0b2b44f53652590eb290f6f4adf2ddde5a700d CPU threads: 4; OS: Windows 10.0; UI render: GL; Locale: ru-RU (ru_RU); Calc: CL). So - closing this as WORKSFORME (which means that it has been fixed, but specific commit is unknown). Wrt your question from comment 11 ("I wonder if there is a button to recalculate everything in the original file"): the answer was given in comment 10 - please use Ctrl+Shift+F9 several times.
Created attachment 138645 [details] capture d'ecran Hello, Please excuse my bad English, I'm using Google Translator. I installed version 6 and unfortunately it's the same thing see attached image and attached file. I add that on my machine the function (Ctrl-Alt-F9) does not work. To do the tests, open the file and save it under another name, then close it. After open this new file and see if LibreOffice calculates? I think not.
Created attachment 138646 [details] LibreOffice Version 6 File for test
Unconfirmed
Please don't change the status unless you can confirm that it doesn't work in the versions that we tested. I was talking about master towards 6.1, and Xavier mentioned both master and 6.0.0.1.0+ - it means, the one *after* RC1 available for download. So yes, the 6.0.0.1 does show the problem; but the problem is fixed in a *later* builds.
Thank you gentlemen for your help, this time I understood. cordially Jean Pierre