Bug 141906 - Calc crashes after editing by deleting rows or by cutting and pasting rows. Additionally having to force recalculation of values in columns?
Summary: Calc crashes after editing by deleting rows or by cutting and pasting rows. A...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: IA64 (Itanium) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-04-26 09:18 UTC by Tony Riley
Modified: 2022-01-21 14:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Tony Riley 2021-04-26 09:18:21 UTC
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
Comment 1 Xisco Faulí 2021-04-26 09:45:05 UTC
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.)
Comment 2 Tony Riley 2021-06-01 10:10:44 UTC
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.
Comment 3 QA Administrators 2021-06-02 03:48:20 UTC Comment hidden (obsolete)
Comment 4 Roman Kuznetsov 2021-07-24 18:01:22 UTC
Tony, please write here info from LibreOffice-About LibreOffice dialog and attach your problem file
Comment 5 QA Administrators 2022-01-21 03:37:54 UTC Comment hidden (obsolete)
Comment 6 Tony Riley 2022-01-21 13:09:24 UTC
I understood that his issue had been resolved by an upgrade.