Hello, Please start with setting up a build environment: http://openoffice.apache.org/orientation/intro-development.html This page provides you an orientation about OpenOFFICE development.
This page helps you startoff with your development. OpenOffice API's are available for Java,Python,C++ and Basic. http://wiki.openoffice.org/wiki/Documentation/DevGuide/OpenOffice.org_Developers_Guide . Dev guide gives you some examples, gives you an idea about what are the functions available and how to use them. The solution for your problem is : Get the current context using Bootstrap. XComponentContext xRemoteContext = Bootstrap.bootstrap(); To access the services which provide you with functions to interact with objects, get the service Manager: XMultiComponentFactory xRemoteServiceManager = xRemoteContext.getServiceManager(); Then create a object which links to desktop frame: Object desktop = xRemoteServiceManager.createInstanceWithContext( "com.sun.star.frame.Desktop", xRemoteContext); Create Componenet loader object using desktop object: XComponentLoader xComponentLoader = (XComponentLoader) UnoRuntime.queryInterface(XComponentLoader.class, desktop); Now U can use the function loadComponentFromURL to open a new spreadsheet/spreadsheet from hardDisk. Infact document files can also be loaded in the same way. Read the dev-guide page step by step for more detailed explanation. http://wiki.openoffice.org/wiki/Documentation/DevGuide/FirstSteps/Example:_Working_with_a_Spreadsheet_Document This page gives basic information about spreadsheets. Check this out for advanced examples: http://wiki.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Spreadsheet_Documents Interfaces like XCell , XCellRange will be useful in formatting and accessing data. I'm also a beginner. Someone will confirm my explanations. On Fri, Apr 19, 2013 at 5:39 PM, Winman Software <i...@winmansoftware.com>wrote: > while working with calc spreadsheet how should I start with. > > how can I compile and run the spreadsheet program. > > if I wish to work with front end development how can I continue. > > Please suggest > > > > -- Rajath S, M.Sc(Hons.) Physics, Birla Institute of Technology and Science - Pilani, Pilani