IBM Lotus Symphony


Managing automatic calculation through macros

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

Product Feedback | Additional Documentation | Trademarks