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

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?

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