https://issues.apache.org/bugzilla/show_bug.cgi?id=44708
Summary: FormulaEvaluator can't handle all functions for XSSF
Product: POI
Version: unspecified
Platform: PC
OS/Version: Linux
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
In the ooxml branch, I have converted HSSFFormulaEvaluator to work with the new
generic interfaces. All of the HSSF formula tests still pass. Many simple
formulas for XSSF can be evaluated just fine
Next up, I've taken a copy of the TestFormulasFromSpreadsheet test, and saved
the test spreadsheet as .xlsx. This xssf version is in svn as
org.apache.poi.xssf.usermodel.TestFormulaEvaluatorOnXSSF
Unfortunately, when running for xssf, lots of the formulas fail to evaluate
properly, so I've had to disable the test (it's called
DISABLEDtestFunctionsFromTestSpreadsheet)
I suspect the issue is that XSSFWorkbook doesn't have a model.Workbook, which
model.FormulaParser expects, as possibly do some of the eval bits. XSSF doesn't
have anything equivalent. Probably, we'll need to tweak various bits to not use
the low level model.Workbook, but use the higher level stuff instead (since
both xssf and hssf have high level stuff). Otherwise, we'll have to try and
bodge up a fake model.Workbook for xssf
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
