Apache OpenOffice (AOO) Bugzilla – Issue 696
sheet ranges not working
Last modified: 2013-02-24 21:06:39 UTC
hi the follwing code is not working ** iam using OpenOffice 6.09 API's to read an excel file: ** iam unable to get maxRow and maxColumn ** it reads 0 , 0 for maxRow AND maxColumn ** the same code works fine with StarOffice5.2API's ,OpenOfficeBean.jar XCellRangesQuery xi = (XCellRangesQuery) UnoRuntime.queryInterface (XCellRangesQuery.class, oSheet); XSheetCellRanges ranges = xi.queryEmptyCells(); CellRangeAddress add[] = ranges.getRangeAddressess(); System.out.println("SR--> "+add.length); for(int i=0;i<add.length;i++) { if(maxR < add[i].StartRow) maxR = add[i].StartRow; if(maxC < add[i].StartColumn) maxC = add[i].StartColumn; } System.out.println("--->"+maxR+" --->"+maxC); Regard's Ananth
API problem
Bug in queryEmptyCells.
Fixed in 630. If you have version 619 or above, update sc/source/core/data/markdata.cxx to revision 1.3 to get the fix.
close now