Saving a LibreOffice Document in the Background

[JMichaelTX]

@Timkendal

I need to ensure that the spreadsheet is saved from time to time, so that work is not lost e.g. if we get a power cut - doesn't happen often but when it does it could be serious if the file is not saved!

There is an autosave function in the spreadsheet but I don't want to rely on it.

I have created a KM macro that saves the spreadsheet every x minutes, when it is active, and that works ok. All it does is to type Cmd-S to save at the appropriate time.

But it does not work if I go to the spreadsheet, make an entry and then leave the spreadsheet, all while the KM timer is still runnin

Here is an untested idea:

Create a KM Macro with a Periodic Trigger (looks like that is what you have)
Macro Actions:

1. IF/THEN LibreOffice is frontmost, THEN:
   • Pause Until IDLE function is > a short period like 1-2 seconds.
   • Select Menu "Save"
2. ELSE:
   • Type Keystroke "⌘S" to LibreOffice in the background
     (an option in the Gear popup menu)

• 

Again, I have NOT tested this, but it looks good to me.
Test using a LibreOffice test file that can be lost.

Let us know if this works for you.