[Solved] [Calc] Macro check if autocalculate is enabled

Creating a macro - Writing a Script - Using the API

[Solved] [Calc] Macro check if autocalculate is enabled

Postby khanlon » Mon Feb 22, 2021 9:10 pm

Is there a way within a Basic macro to check if autocalculate is enabled? In the macro I need to enable and would like to set it back to the way it was upon macro entry prior to macro exit. Thanks.
Last edited by khanlon on Tue Feb 23, 2021 12:15 am, edited 1 time in total.
OpenOffice 4.1.4 / Windows 10
khanlon
 
Posts: 13
Joined: Tue Oct 24, 2017 7:36 pm

Re: [Calc] Macro check if autocalculate is enabled

Postby JeJe » Tue Feb 23, 2021 12:01 am

Code: Select all   Expand viewCollapse view
msgbox thiscomponent.isAutomaticCalculationEnabled
Openoffice 4.1.6
Windows 8
JeJe
Volunteer
 
Posts: 1532
Joined: Wed Mar 09, 2016 2:40 pm

Re: [Calc] Macro check if autocalculate is enabled

Postby khanlon » Tue Feb 23, 2021 12:15 am

Thank you. I had done some searches but had not found that.
OpenOffice 4.1.4 / Windows 10
khanlon
 
Posts: 13
Joined: Tue Oct 24, 2017 7:36 pm


Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 10 guests