IBM® Lotus® Symphony™ Spreadsheets provides
a Universal Network Objects (UNO) interface to manage automatic calculation.
You can use the interface to enable or disable the automatic calculation
function.
The UNO interface for managing automatic calculation is
XCalculatable.
- You can use XCalculatable::enableAutomaticCalculation(boolean
bEnabled) to set the status of automatic calculation. Set
the value of bEnabled parameter to True to
enable automatic calculation, and False to disable
automatic calculation.
- You can use XCalculatable::isAutomaticCalculationEnabled() to
get the current status of automatic calculation. If automatic calculation
is enabled currently, the returned value is True.
Otherwise, the returned value is False.
The following code is an example. If automatic calculation
is enabled currently, running the macro will disable automatic calculation.
Otherwise, running the macro will enable automatic calculation.
Sub Main
Dim oDoc as Object
Dim enabled as Boolean
Set oDoc = StarDesktop.CurrentComponent
enabled = Not oDoc.isAutomaticCalculationEnabled
oDoc.enableAutomaticCalculation(enabled)
End Sub