Bug 153019 - LibreOffice calc recovery does not recover hours of unsaved work
Summary: LibreOffice calc recovery does not recover hours of unsaved work
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-01-14 05:51 UTC by documentationfoundation
Modified: 2024-02-20 14:53 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 documentationfoundation 2023-01-14 05:51:58 UTC
Description:
My desktop (Fedora 37) running LibreOffice 7.4.3.2 was asleep after I closed the lid. Upon opening the lid, the unlock screen was unresponsive to keyboard or mouse presses; attempting to switch to the console (F1) was also unsuccessful. I had to press and hold the power button to force the system to turn off.

Upon reboot, I launched LibreOffice Calc and recovered the .xlsx file I had been editing. Unfortunately, there was very little if any recovery data, and I had lost hours of work. This is unexpected behavior; earlier versions of LibreOffice Calc (on Fedora 36) would recover most if not all of the cached changes.



Steps to Reproduce:
1.Open an .xlsx file
2.Type in cells, create a sheet.
3.Wait 20 minutes.
4.Power off and reboot the system.
5.Launch LibreOffice Calc and recover the file.

Actual Results:
No (or very little) recovery occurs.

Expected Results:
Almost--if not all--recovery occurs.


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Linux (All)
OS is 64bit: yes

Version: 7.4.3.2
Build ID: 40(Build:2)
CPU threads: 16; OS: Linux 6.0; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 1 m_a_riosv 2023-01-16 10:10:41 UTC
Do you have set up Menu/Tools/Options/Load & Save/General - Save AutoRecovery information every?
Comment 2 documentationfoundation 2023-01-18 16:51:57 UTC
> Do you have set up Menu/Tools/Options/Load & Save/General - 
> Save AutoRecovery information every?

This setting is not enabled! I am surprised as I would have expected it to be on by default; I know that I have never touched this setting. Is it possible that new installations have this off? (I recently installed Fedora 37 on a new laptop from scratch.)

I have enabled this setting and restarted LibreOffice Calc. Now the setting is enabled and it appears to be global; in the two spreadsheets I spot checked (one .ods, one .xlsx) the attribute was set in both.
Comment 3 m_a_riosv 2023-01-18 22:11:10 UTC
Just tested and it is enabled by default, at least on the last Windows versions. Don't know about distro Linux versions.