https://bz.apache.org/bugzilla/show_bug.cgi?id=61033
Bug ID: 61033
Summary: [PATCH] Add Workbook.setCellFormulaValidation to
control whether formulas are validated during
Cell.setCellFormula or not
Product: POI
Version: unspecified
Hardware: PC
OS: Linux
Status: NEW
Severity: enhancement
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 34946
--> https://bz.apache.org/bugzilla/attachment.cgi?id=34946&action=edit
patch
Our application must set formulas, then evaluate them. Cell.setCellFormula
does expensive formula parsing, then FormulaEvaluator.evaluate() parses it
again. With this patch if we turn off formula validation our total runtime per
job almost halves, dropping from 21 minutes to 11 minutes.
Let me know if anything should change. I implemented this as part of the
Workbook interface, but then realized that HSSFWorkbook and SXSSFWorkbook
actually don't parse the formula or throw the ParseException anyway, they might
in the future though so I guess this is still the correct place?
Thanks much!
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
