Description: I have one file that I am not able to "save as" or "save".The file has three sheets, one of the sheets gives problems while editing, saving. Librecalc just hangs and I have to FORCE QUIT the application. One I deleted that problematic sheet, I was able to save the file. Editing issues - Even deleting rows or columns causes Calc to freeze and then I have to Force Quit. Steps to Reproduce: 1.Open the file 2.Click on SAVE AS 3.Give filename in the dialogue box and click to save. 4. For editing column choose Column 'H' of teh problematic Sheet or choose more than 1000 rows to delete. Actual Results: Librecalc freezes Expected Results: A new file should be created when save as is done. Edits such as delete multiple(>1000) rows should get carried out. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.115 Safari/537.36
I would like to send the file so that the person anlyzing the problem can recreate the same.
Thank you for reporting the bug. it seems you're using an old version of LibreOffice. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Have upgraded to 5.3.3.2 through the repository (ppa) for Libreoffice 5.3. The Save AS problem has been solved. However, the problem related to deleting column or deleting more than 1000 rows in a single action still persists for this particular file. I would like to reiterate that the problem is in this one particular sheet only. I have used few formula for Match and INDIRECT referencing of cells and suspect that deletion results in some infinite loop or an extremely slow loop getting executed. Few years back I used to use MS EXCEL where I used much more complex formulii but never faced performance issues.
Please attach a sample document, as this makes it easier for us to verify the bug. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided. (Please note that the attachment will be public, remove any sensitive information before attaching it. See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Created attachment 134656 [details] File that is causing the problem
I have attached the sample file. It causes Librecalc to hang while carrying out different operations. One of the operation is trying to delete Column H. The other operations are adding/ deleting multiple rows or scrolling up/ down at a very high speed. Please note that now I have version 5.3.3.2 installed. The SAVE As problem seems to have been resolved.
delete column H, insert column, deleteéadd rows - cannot confirm crash with Version: 6.0.0.0.alpha0+ (x64) Build ID: 7b4f4f15971047664fa278fff96b959d53b272b3 CPU threads: 1; OS: Windows 6.1; UI render: default; TinderBox: Win-x86_64@42, Branch:master, Time: 2017-07-08_01:39:24 operations takes some time and cpu is at 100% for LO process, but after some time LO delete/insert column/rows and operates normally.
"Purged" Libreoffice* and then reinstalled from repository. Version 5.3.4.2 installed now. Performance has improved. Will test for couple of days and if no severe problem is encountered we can close the bug.
Setting to NEEDINFO meanwhile...
No problem observed since installation of 5.3.4.2. Closed as Resolved.