Did you know that the OpenOffice.org Wiki has a WYSIWYG editor? See Help:FCKeditor

From OpenOffice.org Wiki

The method getCellRangeAddress() of the interface com.sun.star.sheet.XCellRangeAddressable returns a com.sun.star.table.CellRangeAddress struct that contains the absolute address of the cell in the spreadsheet document, including the sheet index. This is useful to get the address of cell ranges returned by other methods.

 // --- Get cell range address. ---
 com.sun.star.sheet.XCellRangeAddressable xRangeAddr = (com.sun.star.sheet.XCellRangeAddressable)
     UnoRuntime.queryInterface(com.sun.star.sheet.XCellRangeAddressable.class, xCellRange);
 aRangeAddress = xRangeAddr.getRangeAddress();
 System.out.println("Address of this range: Sheet=" + aRangeAddress.Sheet);
 System.out.println(
     "Start column=" + aRangeAddress.StartColumn + "; Start row=" + aRangeAddress.StartRow);
 System.out.println(
     "End column =" + aRangeAddress.EndColumn + "; End row =" + aRangeAddress.EndRow);