Please point me to Calc Basic API tutorials...
Posted: Wed Feb 20, 2008 2:03 am
Welcome beginner. Please answer all of the questions below which may provide information necessary to answer your question.
-----------------------------------------------------------------------------------------------------------
Which version of OpenOffice.org are you using? 2.3.1
What Operating System (version) are you using? Windows 2000 w/most recent service packs etc.
What is your question or comment?
I desperately need help with using the basic API for Calc. I've probably had to many years using VBA with Excel as nothing in the OpenOffice documentation makes any sense to me. Neither StarOfficeBasicGuide nor StarOfficeBasicTutorial are helpful. The tutorials seem to be just code fragments with key pieces of code missing. As an example the Guide has the following code fragment but it is not clear to me form the discussion in the document what statement or statements are missing as the code will not execute as written.
Dim Sheets As Object
Dim SheetNames
Dim I As Integer
Sheets = Spreadsheet.Sheets
SheetNames = Sheets.getElementNames
For I=LBound(SheetNames) To UBound(SheetNames)
MsgBox SheetNames(I)
Next I
I've searched for OpenOffice Calc API tutorials at the beginner level but havn't found anything that helps.
Thanks for any help.
-----------------------------------------------------------------------------------------------------------
Which version of OpenOffice.org are you using? 2.3.1
What Operating System (version) are you using? Windows 2000 w/most recent service packs etc.
What is your question or comment?
I desperately need help with using the basic API for Calc. I've probably had to many years using VBA with Excel as nothing in the OpenOffice documentation makes any sense to me. Neither StarOfficeBasicGuide nor StarOfficeBasicTutorial are helpful. The tutorials seem to be just code fragments with key pieces of code missing. As an example the Guide has the following code fragment but it is not clear to me form the discussion in the document what statement or statements are missing as the code will not execute as written.
Dim Sheets As Object
Dim SheetNames
Dim I As Integer
Sheets = Spreadsheet.Sheets
SheetNames = Sheets.getElementNames
For I=LBound(SheetNames) To UBound(SheetNames)
MsgBox SheetNames(I)
Next I
I've searched for OpenOffice Calc API tutorials at the beginner level but havn't found anything that helps.
Thanks for any help.