-
Notifications
You must be signed in to change notification settings - Fork 89
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Table syntax support for Util.getFormulaCellRefs() #240
Comments
Solution: extend |
I added |
Formula "FUNC(a[b],c[d])" does not work. I'm going to push a bugfix. |
- Gradle 7.4.2 - override annotation
PR #312 is my 2nd attempt to solve this issue. |
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:
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.
The text was updated successfully, but these errors were encountered: