Bug 67129 - When turning OFF Record Changes in Calc, LibrOffice loses all previously recorded changes
Summary: When turning OFF Record Changes in Calc, LibrOffice loses all previously reco...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Keywords: needsUXEval
Depends on:
Blocks: Calc-Track-Changes
  Show dependency treegraph
Reported: 2013-07-21 06:42 UTC by Peter Lairo
Modified: 2021-01-08 19:59 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Peter Lairo 2013-07-21 06:42:02 UTC
When turning OFF Record Changes in Calc, LibrOffice loses all previously recorded changes!

Steps to reproduce:
- open a Calc Spreadsheet
- Turn on Record Changes
- Make some changes / edit the document
- Turn OFF Record Changes
- Dialog appears:   This action will exit the change recording mode. 
                    Any information about changes will be lost. 
                    Exit change recording mode?
- Click YES
- All previously recorded changes are lost.

Desired behavior:
The previously recorded changes should be remembered. Only changes made WHILE Record Changes is OFF should not be recorded.

Sometimes users will want to make edits that do not need to be recorded. e.g., Grammar corrections. But they still want the important change to be recorded. It should be possible to record changes, then turn off record changes for minor edits, and then turn record changes back on again - all without losing the changes made before.
Comment 1 m_a_riosv 2013-07-21 10:13:32 UTC
Hi Peter, thanks for reporting,

I hope you are agree, that more a request for enhancement than a bug.

Change the status to new and the importance to enhancement.
Comment 2 Peter Lairo 2013-07-21 12:28:46 UTC
Actually, I consider this a DATA LOSS bug. But that is for the developers to decide.
Comment 3 Thomas Lendo 2019-06-10 17:16:26 UTC
Adding needsUXEval. Heiko: Ist this a privacy issue if we save the records?

Other questions: Should there be a separate setting to delete old saved records? How could this be implemented?
Comment 4 Eike Rathke 2021-01-08 19:59:08 UTC
I just came across this old one. Turning off tracking *has* to discard all previous tracking because while tracking is not active all position dependencies can be invalidated without the tracking ever knowing it. For example inserting/deleting columns or rows would invalidate all tracked changes that would be affected by that action without being able to add a track record, switching on tracking again later would let the old tracked actions point to wrong or invalid cell positions in the sheet or wrong cell content if content was changed. So, either you track changes or you don't, there's no half way between. This is also not a data loss bug because the confirmation dialog clearly indicates that "any information about changes will be lost".

Closing as wontfix.