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.
[Solved] Documentation for ScTableSheetObj
[Solved] Documentation for ScTableSheetObj
Last edited by Hagar Delest on Mon Oct 28, 2019 9:47 pm, edited 1 time in total.
Reason: tagged solved
Reason: tagged solved
OpenOffice 4.1.7 on Windows 7
Re: Documentation for ScTableSheetObj
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.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Documentation for ScTableSheetObj
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.
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.
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
[Solved] Re: Documentation for ScTableSheetObj
Thank's for your help.
FJCC: That was exactly what I was looking for.posting.php?mode=reply&f=20&t=99801#
FJCC: That was exactly what I was looking for.posting.php?mode=reply&f=20&t=99801#
OpenOffice 4.1.7 on Windows 7