Porting Excel/VBA to Calc/StarBasic

Short Description
Although OpenOffice 1.1 Calc is able to read Microsoft Excel workbooks, … The information contained here is based on Excel 2000 and OpenOffice 1.1 object …

Website: documentation.openoffice.org | Filesize: 812kb

Content
Porting Excel/VBA to
Calc/StarBasic
Title: Porting Excel/VBA to Calc/StarBasic
Version: 1.0
First edition: June 6, 2004
First English
edition: June 6, 2004Contents
Contents
Contents…………………………………………………………………………………………………………………………ii
Overview………………………………………………………………………………………………………………………iii
Copyright and trademark information……………………………………………………………………………iii
Feedback…………………………………………………………………………………………………………………..iii
Acknowledgments………………………………………………………………………………………………………iv
Modifications and updates …………………………………………………………………………………………..iv
Introduction…………………………………………………………………………………………………………………….1
Terminology……………………………………………………………………………………………………………….1
StarBasic Background…………………………………………………………………………………………………..1
Understanding the OpenOffice Object Model………………………………………………………………….2
Examples of Porting Visual Basic for Applications to StarBasic…………………………………………….4
General Programming Notes………………………………………………………………………………………….4
Application…………………………………………………………………………………………………………………5
Workbooks/Workbook………………………………………………………………………………………………….7
Worksheets/Worksheet……………………………………………………………………………………………….11
Range/Cell………………………………………………………………………………………………………………..14
Charts/Chart……………………………………………………………………………………………………………..19
Controls……………………………………………………………………………………………………………………22
UserForms………………………………………………………………………………………………………………..24
Integrated Development Environment (IDE) Differences…………………………………………………….33
Porting Sample Workbook [Spreadsheet]…………………………………………………………………………..35
Porting Tasks…………………………………………………………………………………………………………….35
Run-time Experiences…………………………………………………………………………………………………39
Appendix A: XRay tool………………………………………………………………………………………………….40
Appendix B: Supporting Functions…………………………………………………………………………………..44
Appendix C: Multi-Page Control……………………………………………………………………………………..48
Bibliography…………………………………………………………………………………………………………………53
Public Documentation License, Version 1.0……………………………………………………………………….54
Porting Excel/VBA to Calc/StarBasic ii…