[Solved] Basic Macro to Recalculate Spreadsheet

[saleem145]

Hello,

I am interested in writing a OO Basic Macro that will recalculate spreadsheet. How can I do this??

Thanks in advance,

Saleem

[Charlie Young]

Hello,

I am interested in writing a OO Basic Macro that will recalculate spreadsheet. How can I do this??

Thanks in advance,

Saleem

Code: Select all

Sub Calculate()
	ThisComponent.calculateAll()
End Sub

[Villeroy]

You can call any command by an ordinary hyperlink or hyperlink button:
.uno:AutomaticCalculation toggles automatic calculation (menu:Tools>Content>Auto Calculation)
.uno:Calculate calculates all "dirty cells" depending on modified cells when auto calc is off (key F9)
.uno:CalculateHard calculates the whole document (key Ctrl+Shift+F9)