Description: After modifying entries eg find and replace dates, saving causes the .ods files to crash and try to recover. The recovery file goes right back to the original file opened. Similarly after deleting rows the spreadsheet does not recalculate the values in the columns and the sheet crashes after forcing recalculation and saving. Routine saving after each minor edit and then saving still crashes but recovery is to the last but one edit. Saving to a new name temporarily works but trying to edit and then overwrite saved file causes it to crash. Steps to Reproduce: 1.Open existing file and save by a new name 2.Edit by deleting rows or by cutting and pasting rows 3.Force recalculation of values in columns because it doesn't do it itself 4.Try to save as file under its new name and it crashes. 5. Even step by step edit then save edit then save eventually crashes and goes to recover file Actual Results: Save file by a new name and initiate editing to update entries in the file. Delete rows and force recalculation (it doesn't do it for itself) , try to save or save as file - crashes. Find and replace dates to update entries to next month, save as - crashes. Any combination of cutting and pasting rows followed by save as and crashes?? Expected Results: Tries to recover file - restores to file originally opened before editing began. Try minor edit followed by save, sometimes works but eventually after several edits and save it crashes. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Mac OS X (All) OS is 64bit: no
Thank you for reporting the bug. 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.)
Started a new file and copied lines from previous calc session. All seems OK until after a number of line edits, particularly moving lines up and down the spreadsheet or copying lines up and down the spreadsheet and then trying to Save As, it crashes and has to be recovered. Editing line by line and Saving As after each line edit works until you delete a line (including a blank line) and it crashes with a Save As. The file is a simple home account file of approximately 30 lines using the most basic of formula to calculate the balance from credits and debits from the account. Recalculation has to be forced after any line movement or deletion.
[Automated Action] NeedInfo-To-Unconfirmed
Tony, please write here info from LibreOffice-About LibreOffice dialog and attach your problem file
Dear Tony Riley, 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
I understood that his issue had been resolved by an upgrade.