Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

LibreOffice macro get index current sheet

Does someone know how to get the index of the current sheet in LibreOffice Macro Basic?

I successed to get the name:

cursheet = my_doc.getcurrentcontroller.activesheet.Name

But how to get index?

Moreover is there a place to find the documentation of all this component and basic language?

TY for your help.

like image 550
Lemaitre Cedric Avatar asked Oct 26 '25 10:10

Lemaitre Cedric


1 Answers

Looks like two qestions in one... Regarding the documentation, you may start at the OOo Wiki or the LO Wiki on Basic, respectively. For a more complete guide, check Andrew Pitonyak's resources on OpenOffice macros. Usually, all solutions working for OpenOffice.org should work with LO, too.

Regarding the index of the current sheet: as usual, the OpenOffice.org forums know the answer:

sSheet.RangeAddress.Sheet

like image 159
tohuwawohu Avatar answered Oct 29 '25 09:10

tohuwawohu



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!