I have a calc spreadsheet that I'm trying to automate. When open, it collects data, calculates, saves itself and exits.
So I created a script to call this.
soffice --calc --norestore Updater.ods
If I run the script
./updater.sh calc opens and does what its supposed to do :)
However, when I put it in
00 15 * * * export DISPLAY=:0 && /path/updater.sh
I can see the process is running, but it doesn't complete any of the actions that it would if the GUI opened. And running the script from terminal opens the gui, but with cron the gui is not opened. So I'm wondering if it is possible to open an app (and it's gui) with cron or another scheduler?
Any help would be appreciated.