The data sheet will store stock values from the StockServer. Before the data is retrieved from the StockServer, the sheet is populated with the right cell styles and the formulas that define the stock portfolio. This example shows the creation of the green text style. When the StockOfficeProxy was implemented to render the values as cells in a spreadsheet, a separate thread was created so that the sheet would be updated at the same time as elements were retrieved from the StockServer. The DataSheet inner class extends the Thread class to update the spreadsheet.
All examples here show the code executing on the same machine, using the localhost interface.
Once the code is running locally, it is easy to distribute the application across several machines. This program is partially based on the remote communications demo found in the UNO Developers Kit. Some of the APIs have changed, but the overall architectural information and programming examples remain helpful. Running Using the StarOffice SDK may also be helpful if you are having difficulty getting this first program loaded. The OpenOffice.org application can act as a client for just about any server or service.