https://bz.apache.org/bugzilla/show_bug.cgi?id=62969
--- Comment #1 from Greg Woolsey <greg.wool...@gmail.com> --- Current thinking involves augmenting FormulaEvaluator with a flag (or facility for multiple flags, perhaps an EnumMap?) to control which value is returned by the function in that invocation/evaluation. The Formula interface would take the OperationEvaluationContext in which it is being called, which would have access to the flags via the WorkbookEvaluator. WorkbookEvaluator appears to be the only class that ever constructs OperationEvaluationContext objects and uses them to evaluate functions. This would enable a given cell to be evaluated in the context of cached results in two different ways based on the state of the flags for the current FormulaEvaluator. Testing will be needed to see if the cache needs to be cleared when flags change, in order to properly re-process the formula. Also, this could have side effects for other cells whose formulas reference the cell with the HYPERLINK() formula call - we would want dependent cell calculations to continue to always use the display label result. Perhaps that means the cache mechanism needs to know about the presence or absence of flags also, and skip cache reads and writes when flags are set. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org For additional commands, e-mail: dev-h...@poi.apache.org
