https://bz.apache.org/bugzilla/show_bug.cgi?id=56499
--- Comment #8 from Dominik Stadler <dominik.stad...@gmx.at> ---
Some analysis:
* IFERROR is not part of the default set of Excel functions, but is marked as
"external" in the parsed formula:
Ptg[7]=org.apache.poi.ss.formula.ptg.FuncVarPtg [#external# nArgs=3]V
* The externalname is added by POI as follows:
[EXTERNALNAME]
.options = 0
.ix = 0
.name = IFERROR
org.apache.poi.ss.formula.ptg.ErrPtg [#REF!].
[/EXTERNALNAME]
* When the file is edited and saved in Excel it is saved as follows:
[NAME]
.option flags = 0x038B
.keyboard shortcut = 0x00
.length of the name = 13
.extSheetIx(1-based, 0=Global)= 0
.sheetTabIx = 0
.Menu text length = 0
.Description text length= 0
.Help topic text length = 0
.Status bar text length = 0
.NameIsMultibyte = false
.Name (Unicode text) = _xlfn.IFERROR
.Formula (nTokens=1):
org.apache.poi.ss.formula.ptg.ErrPtg [#NAME?].
.Menu text =
.Description text=
.Help topic text =
.Status bar text =
[/NAME]
* The external name is currently built in InternalWorkbook.getNameXPtg()
--
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
