Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

count cells in a range in macro

I have a cellrange and I'm trying to get the number of cells populated in that range.

oCellRange = rr_sheet.getCellRangeByName("a63:b68")

I tried count=oCellRange.computeFunction(com.sun.star.sheet.GeneralFunction.COUNT), but that gives the total number of rows in the range, I just want the ones that have data.

I tried the above call with COUNTA, but that complained and said it was not found. I could write a little function that loops through the DataArray, but I was trying to avoid that.