[Solved] Documentation for ScTableSheetObj

Creating a macro - Writing a Script - Using the API

[Solved] Documentation for ScTableSheetObj

Postby Ove » Sun Oct 27, 2019 7:41 pm

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
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.
Last edited by Hagar Delest on Mon Oct 28, 2019 9:47 pm, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.7 on Windows 7
Posts: 10
Joined: Sun Oct 27, 2019 6:46 pm

Re: Documentation for ScTableSheetObj

Postby FJCC » Sun Oct 27, 2019 10:22 pm

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Posts: 7657
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Documentation for ScTableSheetObj

Postby JeJe » Sun Oct 27, 2019 10:45 pm

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.
Openoffice 4.1.2
Windows 8
Posts: 1033
Joined: Wed Mar 09, 2016 2:40 pm

[Solved] Re: Documentation for ScTableSheetObj

Postby Ove » Mon Oct 28, 2019 8:01 pm

Thank's for your help.
FJCC: That was exactly what I was looking for.posting.php?mode=reply&f=20&t=99801#
OpenOffice 4.1.7 on Windows 7
Posts: 10
Joined: Sun Oct 27, 2019 6:46 pm

Return to Macros and UNO API

Who is online

Users browsing this forum: No registered users and 4 guests