[Solved] BASIC Runtime Error in Calc Macro

[khanlon]

When I run the following CALC macro it works.

Sub Insert_Rows(Sheet_Idx, Row, Count)

Rem *** The following three lines added to run macro independently
Sheet_Idx = 0
Row = 62
Count = 1
Rem ***
Sheets = thisComponent.Sheets
Sheet = Sheets.getByIndex(Sheet_Idx)
Sheet.Rows.insertByIndex(Row, Count)

End Sub

However, when it is called from a function it receives the error below. Can someone tell me why this happens? Thanks.

"Basic Runtime Error. An exception occurred. Type:com.sun.star.uno.RuntimeException Message.

[Zizi64]

Please upload a sample ODS file with the embedded FULL macro code, to see: how you call the function, how you pass the parameters, what variable type parameters are you using, etc...


Do you want to call the function from a cell?

[Lupp]

The code works for me as expected in AOO Calc 4.1.3.

[khanlon]

Yes, I am calling it from my user written function in a calc cell.

[MrProgrammer]

Using macro as a function. Why isn't it working?

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[khanlon]

Thanks for the information / help.