Hi, I'm trying to create an AreaReference (org.apache.poi.ss.util.AreaReference) using the following reference: OFFSET($'SEA 05 Staff Data'.$A$2,,,COUNTIF($'SEA 05 Staff Data'.$L$2:$L$100,">0"),14)
When doing so I receive the following exception: Exception in thread "main" java.lang.IllegalArgumentException: References passed to the AreaReference must be contiguous, use generateContiguous(ref) if you have non-contiguous references The result of the above formula is a contiguous AreaReference. Since an AreaReference object does not reference a workbook, it has no means of evaluating the above formula - which I guess is the ultimate reason for the above exception. How can I evaluate a formula into an AreaReference? FormulaEvaluators (org.apache.poi.ss.usermodel.FormulaEvaluator) only seem to evaluate single cells. Thanks & Best regards, Martin -- View this message in context: http://apache-poi.1045710.n5.nabble.com/References-passed-to-the-AreaReference-must-be-contiguous-tp5723848.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
