Hello.
Thanks, I could see the same behavior in the document you provided. It happened everywhere, not only in the cell 428 onwards. I don’t believe this is some visual problem. My gut feeling is, your document is somehow wrongly formatted.
Since this morning, I am on the new release version 8.2.1.1
What I did is, I created a new empty document and I simply marked and copied all the cells from your file to the new file. It took a couple of seconds, but after that, the new document showed no issues with the formula anymore. See also the difference in the size. The new file is about double the size of yours. All I did is to copy it via copy and paste.
When I copied the whole sheet into a newly created sheet in the same document (yours) the copy showed the same behavior. It seems to be connected to the document itself.
The file works with no issues in MS Office Excel 2019. After saving (no changes applied) it gets about 5kB bigger but has the same issues in openoffice as before.
I suppose with your example, onlyoffice-developers will be able to check and see what is causing this behavior. Examples are the best approach to find bugs or general problems of this nature.
Here the document I created:
test formulas2.xlsx (63.3 KB)
1 Like
I did reopen the document I created “test formulas2.xlsx” via c&p and it is showing the same behavior now too.
I will do some more testing. Also on my own documents, which use the SUM function too.
Hello everyone,
We are checking the described situation. Thank you for detailed scenarios, videos and test files.
Special thanks to @bermuda for active participation and testing of possible options.
I will update this thread as soon as possible.
Hello.
I have copied the contents to a new file and the problem seems to only appear after i reach row below 410. Everything pasted before 410 takes a lot of time, which is already suspicious, but it still works. After 410 things begin to disappear when refreshed.
[UPDATE]
Things seem to break after copying row 413 to a working document containing rows 1 up to 412.
When copying only values, omitting formulas and extending the formulas from row 412, this does not produce the issue. It seems there is something happening in the formulas in row 413 that produces this behavior.
[UPDATE]
Now it seems totally randomly. I rechecked the documents again and some are working, while other (working before) now do fail.
@tonytony123
I recreated your document from the scratch. I opened it with LibreOffice an copied all the values into a simple text editor and from there to a brand new xlsx file running on my onlyoffice version 8.2.1.1. After that I copied your formulas (not the cell, but the formula from the cell inside) and put it into the file too. After that I expanded the cells containing the formulas all the way down to row number 430. I closed the document and opened it again. The cells started disappearing once I refreshed the cells with formulas.
I can now confirm, that this is most likely a BUG in onlyoffice and is not affected from the environment like you desktop.
This is a case for the developers. Luckily they have a working example now and should be able to pinpoint the culprit.
It all sounds very unlikely, but it is really what people in here have described.
Thanks guys, glad I could contribute somehow to this great project. Thanks for looking into it!
Hello,
We confirm that described situation in this thread is a bug. We have started working to fix the issue. Thank you everyone for valuable information! We will update this thread once we release a fix.
2 Likes