Application crashes trying to save after deleting cells or rows. Why?

KirkWard · April 12, 2021, 4:14pm

I have a workbook with multiple spreadsheets and am trying to clean up one of the sheets by deleting some cells (and moving other cells up) or rows.

The deleting works properly, but the application crashes each time I try to save my work.

What could be the cause of this instability and how can I fix it?

Thanks

anon73440385 · April 12, 2021, 4:22pm

Are you sure that the crash is related to your edits at all or does it crash on all saves, reagrdless what you did before? If that’s the case please tell us any technical details.

Operating system
LibreOffice version
Storage device (local disk, USB drive, NAS system, network drived, cloud serivce like Google Drive, One Drive etc.
Did you already try to perform your action while running in LibreOffice’s Safe Mode (Help -> Restart in Safe Mode)?
Did you already reset you LibreOffice user profile

Please do **not** use *Add Answer* but **[edit](https://ask.libreoffice.org/t/application-crashes-trying-to-save-after-deleting-cells-or-rows-why/63527)** your original question to enhance the details of your question and/or to upload sample file(s) (answers are reserved for solutions to a problem on this Q&A site). Thanks in advance …

KirkWard · April 12, 2021, 4:34pm

Win 10 Personal Lenovo Laptop
Version 7.1.22 (x64)
Build 8a45595d069ef5570103caea1b71cc9d82b2aae4
Save to local disk C:
Have not run in Safe Mode. will ASAP
Have not reset user profile. How do I do dat?
Thanks

KirkWard · April 12, 2021, 4:40pm

Crashes in safe mode also. Does not crash with any changes (other than this particular deleting of cells or rows).

anon73440385 · April 12, 2021, 5:00pm

Crashes in safe mode also

Then it is pointless to reset your user profile, since running in Safe Mode is a test, whether a corrupt user profile could cause the issue. If a problem occurs in Safe Mode (which is running in a temporary user profile) as well, then most likely it is not caused by your original user profile.

Which file format are you using (.ods or some other format like .xlsx or some such)?
Does this problem happen with a specific file only or with all files (even newly created ones)?

KirkWard · April 12, 2021, 5:03pm

I saw an link to the side here about a similar problem in LO with Win XP, that did not happen in OpenOffice, so I decided to test it in OO. I was able to delete some rows and save. So I reopened in LO and discovered what appeared to be some very large blank image squares or text boxes on the page. I deleted the by selecting them and then deleting them using the keyboard Del key. Once they were gone, I deleted rows and saved. I have no idea how they got there, or what they were supposed to contain but for now deleting them seems to have corrected the problem. Thank you for looking at this.