On Tue, 21 Oct 2014, Blake Watson wrote:
I'm working with the output of the sheet's getDataValidations method, which
gives me a getRegions (returning a CellRangeAddressList).
So I can go through each CellRangeAddress, and compare the first and last
columns and rows with the column and row of the cell I'm curious about.
I think the method you want is on SheetUtil:
https://poi.apache.org/apidocs/org/apache/poi/ss/util/SheetUtil.html#containsCell%28org.apache.poi.ss.util.CellRangeAddress,%20int,%20int%29
boolean containsCell(CellRangeAddress cr, int rowIx, int colIx)
That should let you easily see if a given cell co-ordinates are in a cell
range address or not
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
