I’m a relatively new LO user. What is the SOP for detecting errant keystrokes that modify a single cell?
.
For example a check box analogous to Show Formulas, for Show Modification Date-Time, and the facility to highlight cells with a timestamp more recent than X time ago.
Standard Operating Procedures.
I think that will work, plus many more features ! Wow ! Thanks @fpy
.
It is difficult for me to pick out the changed cells based on their default ‘highlighting’. So I’m coupling the Record Changes feature with two appearance changes:
.
Following @EarnestAl suggestion in another thread from 2025:
I chose Light Blue 4
.
additionally, the markup to Dark Orange 1 following this sub-page of your link:
.
https://help.libreoffice.org/latest/en-US/text/shared/01/02230200.html
.
which says
You can change the display properties of the markup elements by choosing in the Options dialog box.
Relatedly, @Wanderer suggested ideas to limit the chance of errant changes:
.
There always seem to multiple official pages on a given topic. Anyway, for the @Wanderer suggestions here are 2 of them:
.
https://help.libreoffice.org/latest/en-US/text/scalc/guide/validity.html
.
and
.
https://help.libreoffice.org/latest/ug/text/scalc/guide/cell_protect.html
1 Like