4

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.

Pᴇʜ
  • 56,719
  • 10
  • 49
  • 73
Lemaitre Cedric
  • 139
  • 2
  • 7

1 Answers1

3

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

tohuwawohu
  • 13,268
  • 4
  • 42
  • 61