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

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
khanlon
Posts: 13
Joined: Tue Oct 24, 2017 7:36 pm

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

Post by khanlon »

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
JeJe
Volunteer
Posts: 2777
Joined: Wed Mar 09, 2016 2:40 pm

Re: [Calc] Macro check if autocalculate is enabled

Post by JeJe »

Code: Select all

msgbox thiscomponent.isAutomaticCalculationEnabled
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
khanlon
Posts: 13
Joined: Tue Oct 24, 2017 7:36 pm

Re: [Calc] Macro check if autocalculate is enabled

Post by khanlon »

Thank you. I had done some searches but had not found that.
OpenOffice 4.1.4 / Windows 10
Post Reply