[Solved] Start stop Auto-Calc of a table by my macro?

[goooly]

Hi,

is ist possible to stop AutoCalc (in german: Extras => Zellinhalte => Automatisch berechnen
which is somewhat equivalent to: Tools => Cell contents => Auto calc ??)
when a macro is started and switched on again after all cell are 'filled'
and switched off again so that all the copying of the cell content to keep the values
does not start a neeedles and sensless recalc of the table??

Could find anything neither in the help nor by google,
inly Excel code:

Code: Select all   Expand viewCollapse view

Sub Refresh
   ThisWorkbook.Sheets("Summary").EnableCalculation = True
   ThisWorkbook.Sheets("Summary").EnableCalculation = False
End Sub


that I changed to

Code: Select all   Expand viewCollapse view

...
mDOC = ThisComponent
...
Sub Refresh
   MsgBox "AutoCalc - on :",0
   mDOC.EnableCalculation = True
   MsgBox "AutoCalc - off:",0
   mDOC.EnableCalculation = False
End Sub


Does OO-Basic provides this Option?
Anybody with an idea - workaround?
Thanks and a nice weekend,
Gooly

[FJCC]

The method in Calc is called enableAutomaticCalculation.

Code: Select all   Expand viewCollapse view

oDoc = ThisComponent
oDoc.enableAutomaticCalculation(False)

[goooly]

yupp, Thanks, and
oDoc.Calculate
is as I were pressing F9
(for others having the same problem)
Bye