Steps to Reproduce

Run Issue200Test and check TestZSS214

Current Result

INFO: Not implemented when parsing #REF!Unable to render embedded object: File ($I$18 at [214-npe-rename.xlsx]Sheet1!nullINFO: Not implemented when parsing #REF) not found.!$A$1:$I$18 at [214-npe-rename.xlsx]Sheet1!nullorg.zkoss.poi.ss.formula.FormulaParseException: Not implemented at org.zkoss.poi.ss.formula.token.OpNode.toExternalRef(OpNode.java:144) at org.zkoss.poi.ss.formula.token.ExclamationNode.normalize(ExclamationNode.java:44) at org.zkoss.poi.ss.formula.token.ColonOpNode._normalize(ColonOpNode.java:150) at org.zkoss.poi.ss.formula.token.ColonOpNode.normalize(ColonOpNode.java:121) at org.zkoss.poi.ss.formula.FormulaTokenParser.parse(FormulaTokenParser.java:154) at org.zkoss.poi.ss.formula.FormulaTokenParser.parse(FormulaTokenParser.java:139) at io.keikaiex.formula.FormulaEngineEx.parse(FormulaEngineEx.java:84) at io.keikai.model.impl.sys.formula.FormulaEngineImpl.parse0(FormulaEngineImpl.java:229) at io.keikai.model.impl.sys.formula.FormulaEngineImpl.parse(FormulaEngineImpl.java:187) at io.keikai.model.impl.NameImpl.parseAndEvalFormula(NameImpl.java:137) at io.keikai.model.impl.NameImpl.setRefersToFormula(NameImpl.java:120) at io.keikai.importer.XlsxImporter.importNamedRange(XlsxImporter.java:2363) at io.keikai.importer.XlsxImporter.imports(XlsxImporter.java:267) at io.keikai.range.impl.imexp.ExcelImportAdapter.imports(ExcelImportAdapter.java:48) at io.keikai.api.impl.ImporterImpl.imports(ImporterImpl.java:58) at io.keikai.api.impl.ImporterImpl.imports(ImporterImpl.java:48) at io.keikai.Util.loadBook(Util.java:76) at io.keikai.issue.Issue200Test.testZSS214(Issue200Test.java:1515) 

Expected Result

No such warning

Debug Information

This might not be a bug. Excel complains the tested file and ask if you want to repair it.

The core cause is that a DefinedName whose formula refer to an incorrect range. However, Excel repair the file by removing the DefinedName.

Workaround