I'm trying to figure out, as the subject says, whether a cell is in a particular (not necessarily contiguous) area. Seems like there would be an existing utility for that, but maybe not.
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. It just seems like there should be a "contains" somewhere. The closest thing I can find is in org.apache.poi.hssf.record.cf (I'm using xssf, but I'm not sure why it should matter), and it compares cell ranges, so I'd have to convert my single address to a CellRangeAddress. Am I missing something? ===Blake===
