Table syntax support for Util.getFormulaCellRefs()

[SoltauFintel]

Using German formula =SUMMEWENNS(AktuellerBestandTabelle[Buchwert_Direkt];AktuellerBestandTabelle[Zinsblock ohne 71_72];WAHR;AktuellerBestandTabelle[Erste Fälligkeit Jahr];0) will result in wrong value 0.

Cause is this code in StandardFormulaProcessor.java:116:

if (isFormulaCellRefsEmpty && isFormulaJointedCellRefsEmpty
   && (!formulaCellData.isParameterizedFormulaCell() || formulaCellData.isJointedFormulaCell())) {
         targetFormulaString = formulaCellData.getDefaultValue() != null ? formulaCellData.getDefaultValue() : "0";
}

isFormulaCellRefsEmpty is true because JXLS doesn't recognize the table syntax (e.g. "AktuellerBestandTabelle[Buchwert_Direkt]") as a cell ref. Util.getFormulaCellRefs returns an empty list.

[SoltauFintel]

Solution: extend Utl.regexCellRef with + "|[a-zA-Z_]+[a-zA-Z0-9_]*\\[.+\\]". However, many testcases will fail.

[leonate]

Solution: extend Utl.regexCellRef with + "|[a-zA-Z_]+[a-zA-Z0-9_]*\\[.+\\]". However, many testcases will fail.

I added |[a-zA-Z_]+[a-zA-Z0-9_]*\[.+\] to the Util.regexCellRef pattern as you suggested and mvn verify still works fine for me. So I committed the change to the feature-240 branch.

[SoltauFintel]

Formula "FUNC(a[b],c[d])" does not work. I'm going to push a bugfix.

[SoltauFintel]

PR #312 is my 2nd attempt to solve this issue.