[Solved] Turn off Save AutoRecovery information from a macro

Creating a macro - Writing a Script - Using the API

[Solved] Turn off Save AutoRecovery information from a macro

Postby Tarkovsky » Mon Apr 23, 2018 8:03 am

Hi guys, I'm working on an interactive spreadsheet, with a lot of macros, data and buttons... to be short, It's a spreadsheet to act like a program, so the people who will be using it do not need to be familiar with spreadsheet formulas. But I have faced a problem: Due to the size of the spreadsheet, It takes a long time(usually more than a minute) to save the AutoRecovery information and during this process, it locks everything, so the user can not use it. I can not turn off the Save AutoRecovery informatin on all machines, since they usually do Windows fresh installs.
So, is it possible to just write a macro to turn off the AutoRecovery information? That would solve the problem, since I could call the macro from a open document event.
Last edited by Hagar Delest on Fri Apr 27, 2018 7:58 am, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.3 on Arch Linux
Tarkovsky
 
Posts: 28
Joined: Fri Jun 30, 2017 9:17 am

Re: Can I turn off Save AutoRecovery information from a macr

Postby Zizi64 » Mon Apr 23, 2018 9:30 am

It takes a long time(usually more than a minute) to save the AutoRecovery information and during this process, it locks everything, so the user can not use it. I can not turn off the Save AutoRecovery informatin on all machines, since they usually do Windows fresh installs.

If I know it exactly, the Autosave feature is a Application-level parameter, but it is not a Document-level parameter. (It is not stored in the document.)
Therefore you have not "rights" to change the settings of an another User (without her/his authority), because this setting influence the behavior and security of the other documents of the User.
Tibor Kovacs, Hungary; LO4.4.7, LO6.1.1 on Win7x64Prof.
PortableApps, winPenPack: LO3.3.0-LO6.1.2 and AOO4.1.5
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 7303
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Can I turn off Save AutoRecovery information from a macr

Postby Tarkovsky » Mon Apr 23, 2018 7:54 pm

If I know it exactly, the Autosave feature is a Application-level parameter, but it is not a Document-level parameter. (It is not stored in the document.)

Aren't the scrollbars, menu bar and status bar all part of the Application-level? All of them can be turned off when the document is open.
OpenOffice 4.1.3 on Arch Linux
Tarkovsky
 
Posts: 28
Joined: Fri Jun 30, 2017 9:17 am

Re: Can I turn off Save AutoRecovery information from a macr

Postby Villeroy » Mon Apr 23, 2018 8:34 pm

When you change the setting in the options dialog, and diff registrymodifications.xcu in your profile folder, you see that the following node changes:
Code: Select all   Expand viewCollapse view
<item oor:path="/org.openoffice.Office.Common/Save/Document"><prop oor:name="CreateBackup" oor:op="fuse"><value>true</value></prop></item>

That is property "CreateBackup" in node "/org.openoffice.Office.Common/Save/Document"

https://forum.openoffice.org/en/forum/v ... 00#p341300 includes a pair of functions getOOoSetupValue and setOOoSetupValue.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25761
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Can I turn off Save AutoRecovery information from a macr

Postby Tarkovsky » Fri Apr 27, 2018 7:13 am

Thanks man.
OpenOffice 4.1.3 on Arch Linux
Tarkovsky
 
Posts: 28
Joined: Fri Jun 30, 2017 9:17 am


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 8 guests