Page 1 of 1

[Solved] Documentation for ScTableSheetObj

PostPosted: Sun Oct 27, 2019 7:41 pm
by Ove
Honorable members

I'm new to the OpenOffice Macro interface, and i'm having a hard time finding any valuable documentation, except for your examples (thank you). For example
ThisComponent.getcurrentcontroller.activesheet
returns an object of type ScTableSheetObj, but where is that documented? What methodes are available from the activesheet object?
Currently i need to check if the sheet has a valid selection or not. If no cells are selected,
oCurSelection = thisComponent.CurrentSelection()
works fine, but
firstRow = oCurSelection.getByIndex(0).StartRow
crashes the macro with:
"BASIC runtime error. Property or method not found: getByIndex",
If I select some cells the macro runs fine fine.

Re: Documentation for ScTableSheetObj

PostPosted: Sun Oct 27, 2019 10:22 pm
by FJCC
The best way to see the properties and methods of an object is to use an object inspection tool. Here is a tutorial for the MRI tool.. There is also a tool called Xray that is very similar.

Re: Documentation for ScTableSheetObj

PostPosted: Sun Oct 27, 2019 10:45 pm
by JeJe
The OpenOffice Api documentation:

https://www.openoffice.org/api/docs/com ... tView.html

A search for the thing you want information about in the search box here, or a search engine (just adding the word Openoffice to the search) will nearly always yield a previous thread on the subject, with solutions.

[Solved] Re: Documentation for ScTableSheetObj

PostPosted: Mon Oct 28, 2019 8:01 pm
by Ove
Thank's for your help.
FJCC: That was exactly what I was looking for.posting.php?mode=reply&f=20&t=99801#