https://issues.apache.org/bugzilla/show_bug.cgi?id=45041
Josh Micich <[EMAIL PROTECTED]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #3 from Josh Micich <[EMAIL PROTECTED]> 2008-05-19 16:16:32 PST ---
The problem appears to be with the use of semicolons (;) for argument
separators when POI expects commas (,). My understanding was that Excel uses
commas too. Is there any circumstance that allows semicolon?
If I change the semicolons to commas, POI parses the formula OK.
I have added a patch (in svn r658033) to improve the formula parse error
messages. The first code example in this bugzilla should now produce this:
Exception in thread "main"
org.apache.poi.hssf.model.FormulaParser$FormulaParseException: Parse error near
char 16';' in specified formula
'(1+IRR(SUMIF(A:A;ROW(INDIRECT(MIN(A:A)&":"&MAX(A:A)));B:B);0))^365-1'.
Expected Integer
at
org.apache.poi.hssf.model.FormulaParser.expected(FormulaParser.java:140)
at ...
BTW - The full column references should not be a problem for this example. A
partial fix for bug 44410 was applied in svn r628044 (rel 3.1-beta1), and this
seems to be enough to make expressions like 'A:A' work.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
