https://bz.apache.org/bugzilla/show_bug.cgi?id=66651
Bug ID: 66651
Summary: References to non existing named cells inside Formulas
throws exception even with IF/ISERROR
Product: POI
Version: 5.2.3-FINAL
Hardware: PC
OS: All
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
If there is a reference to a non existent named cell in a formula the following
exception is thrown:
"Specified named range 'NAMEVAR' does not exist in the current workbook."
This is also the case if the name is wrapped inside a "ISERROR" or "IFERROR".
There we would expect the same behavior as in Excel, also even if it is just
inserted I'd expect a Name error in the Cell and not a runtime exception,
essentially the same behavior that is present if a formula is set to divide by
0.
Also there if there is a reference to an non existing sheet or external
workbook then one can use:
>FormulaEvaluator#setIgnoreMissingWorkbooks()
to get Excels behavior, but named cells will still fail.
Code to reproduce:
>Workbook workbook = new XSSFWorkbook();
>Cell cell = workbook.createSheet().createRow(0).createCell(0);
>cell.setCellFormula("ISERROR(NAMEVAR)");
--
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]
