Re: [sc-dev] How to access cell values in a cell range in Calc add-ins?

2010-10-18 Thread Niklas Nebel
On 10/18/10 07:51, Pivithuru Wijegunawardana wrote: You can use com.sun.star.sheet.XCellRangeAddressable interface and CellRangeAddress. com.sun.star.sheet.XCellRangeAddressable xRangeAddr = (com.sun.star.sheet.XCellRangeAddressable)

[sc-dev] How to access cell values in a cell range in Calc add-ins?

2010-10-17 Thread Nadee Hwg
Hi, i have succeeded in adding a function to Calc and reading the input figures on a Calc spreadsheet. I'm using the projectName.impl.java file generated and changing its return statement so as to give the result of my function. But I can only access a pre-defined number of cells only. i.e. the

Re: [sc-dev] How to access cell values in a cell range in Calc add-ins?

2010-10-17 Thread Pivithuru Wijegunawardana
Hi Nadee, You can use com.sun.star.sheet.XCellRangeAddressable interface and CellRangeAddress. com.sun.star.sheet.XCellRangeAddressable xRangeAddr = (com.sun.star.sheet.XCellRangeAddressable) UnoRuntime.queryInterface(com.sun.star.sheet.XCellRangeAddressable.class, xCellRange); CellRangeAddress