Relative references point to a cell based on its position relative to the current cell.There are two types of cell references: relative and absolute. Formula One for Java automatically enters a relative reference identifying the cell(s) you select. Use the mouse to click and drag on cells and ranges.For information on defining names, see Using Names. Type in the name of a named cell or range.You can enter cell references in formulas in three ways: The range includes all cells in columns A, B, and C of rows 1, 2, and 3. For example, A1:C3 refers to the range anchored by cells A1 and C3.

You specify a range of cells by placing a colon (:) between two cell references. If a formula requires a number, you can substitute a reference to a cell that contains a number. The reference tells Formula One for Java to use the contents of the referenced cell(s) in the formula. For example, A1 refers to the cell at the intersection of column A and row 1. It identifies a cell or range of cells by referring to the column letter and row number of the cell(s). The following two methods: calculate() and calculateAll() are available from the reference is a cell's address. See also .XSpreadsheetDocument, .XSpreadsheet and .CellContentType Computing the Formula Listing 0 // C++ #include #include #include #include // added #include using namespace com :: sun :: star :: uno using namespace com :: sun :: star :: lang using namespace com :: sun :: star :: bridge // added using namespace com :: sun :: star :: frame using namespace rtl using namespace cppu // a procedure for what the so called boostrap First the ooConnect() part is given as the following code:.To save you searching in the previous chapters the starting code is presented to insert into the new listings given in this chapter. 8.1 Embedding Images (Java Code waiting for a C++ Translation).6.4 An Example from OooForum: Opening a Password protected Document.6.2 A second Example : Adding a Name to a Cell (or Cell Range).6 Ready to translate the Developers Guide into C++.

5.3 Getting a Cell range with a Selection.

5.2 Retrieve the absolute Address of the Cell Range.

5.1 Retrieve the absolute X and Y Positions of a Cell.

4.4 What is the Content Type of a Cell ?.

Openoffice calc absolute reference