https://bugs.documentfoundation.org/show_bug.cgi?id=150547
Bug ID: 150547
Summary: Unusable documentation for scripting
Product: LibreOffice
Version: 6.4.7.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: BASIC
Assignee: [email protected]
Reporter: [email protected]
Description:
I try to find the Sheet in a Basic script for more than a week.
The documentation on the net is for OpenOffice.
ThisComponent which returns the actual document fits here but there is no
Sheets method nor getSheetByName nor getSheetByIndex.
The documentation for ThisComponent says that the availble methods of the
object returned depends on the document type (what makes sense).
There is no way to figure out which methods ARE available tough using:
https://help.libreoffice.org/latest/gu/text/sbasic/shared/
Steps to Reproduce:
1. From a Spreadsheet open the Macro Editor
2. Get the actual document using ThisComponent
3. Try to find the Sheets, Cells, Rows, Columns, ...
Actual Results:
well, nothing
Expected Results:
Documentation which makes it possible to find the required information
Reproducible: Always
User Profile Reset: No
Additional Info:
Structuring the documentation as if it was an API documentation would make
sense.
Object/Service and in this Methods, Properties etc.
Doc = ThisComponent # which is a spreadsheet at the moment
Sheet = Doc.getSheets()
fails
There should a section "SpreadsheetDocumetObject" with the methods and
properties listed
Doc = ThisComponent
Sheet = Doc.theRightMethodFromTheDocumentationToGetTheSheets()
should work
--
You are receiving this mail because:
You are the assignee for the bug.
