Archive for Spreadsheets

Symphony Thursday: Developer 101 - Spreadsheets "Hello World"

February 19 2009

Symphony Thursday: Developer 101 1. Introduction to UNO Development and Documents/Writer "Hello World" 2. Spreadsheets"Hello World" Last time, I covered the basics of UNO Development and walked you thru a "Hello World" application for OpenOffice.org Writer and Lotus Symphony Documents. This blog entry will cover an introduction to OpenOffice.org Calc and Lotus Symphony Spreadsheets. Introduction to Lotus Symphony Spreadsheets Just like we did with Lotus Symphony Documents, we have to call the Service Manager and the Desktop. Set SM=CreateObject("com.sun.star.ServiceManager") Set Desktop=SM.createInstance("com.sun.star.frame.Desktop") Next, we need to start the Calc / Spreasheets appplication. They use a different URL to define the application, one specific for Calc / Presentations. Set CalcApplication = Desktop.loadComponentFromURL_("private:factory/scalc","_blank",0,args) The command above creates the workbook and opens it for the user. We then need to get the