3.12 org.apache.poi.ss.formula.FormulaParseException

[Brian Milnes]

Folks,

 I have a strange bug that I can't quite grasp.

org.apache.poi.ss.formula.FormulaParseException: Unused input [[llave]]
after attempting to parse the formula [[1]!tbltipoentidad[llave]]
    at
org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:1577)
    at org.apache.poi.ss.formula.FormulaParser.parse(FormulaParser.java:145)
    at
org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateName(XSSFFormulaUtils.java:116)
    at
org.apache.poi.xssf.usermodel.helpers.XSSFFormulaUtils.updateSheetName(XSSFFormulaUtils.java:70)
    at
org.apache.poi.xssf.usermodel.XSSFWorkbook.setSheetName(XSSFWorkbook.java:1439)

I could not find the string involved with searching or dumping
strings/formulas using POI until I rewrote the sheet as a FOPS
and it is here in the XML.

....
  <table:named-expression table:name="lsTipoEntidad"
table:base-cell-address="$&apos;9&apos;.$A$1"
table:expression="[1]!tbltipoentidad[llave]"/>
   </table:named-expressions>

 Can anyone tell me something of what's going on?

 Where is this object in the XLSX data structures and why is it not parsing
correctly as a formula? Should it be a formula?

 Thanks, Brian