libreofficelibreoffice-calclibreoffice-basic

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.


Solution

  • 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