59362
2016-04-20 19:23:21 +0000
Formula parsing fails with doubled semi-colon in SUM()
2016-05-17 19:27:01 +0000
1
1
1
Unclassified
POI
SS Common
3.14-FINAL
PC
Linux
RESOLVED
WONTFIX
P2
normal
---
1
ian
dev
ian
0
oldest_to_newest
190415
0
ian
2016-04-20 19:23:21 +0000
I get a MissingArgPtg when trying to analyse a cell with the following formula: "=SUM(C9;D9;;E9)"
The double semi-column generates that.
But Excel and LibreOffice can manage it.
Context: we have people creating and testing spreadsheets in Excel. But we are using the spreadsheet programmatically to compute prices.
If it works in Excel, can we assume it should works through the POI API?
Thank you.
190417
1
onealj
2016-04-20 21:26:21 +0000
I tried typing that formula into Excel 2013 and got a "we found a typo in your formula and tried to correct it" error. Semicolons are not valid separators. Use commas instead.
190418
2
onealj
2016-04-20 21:34:51 +0000
What locale of Excel are using? I suppose Excel and LibreOffice may have changed the formula argument delimiter from a comma to a semicolon for locales that use comma as the delimiter between the whole and fractional part of a number.
Is POI's formula parser locale-aware?
If so, then this bug is really the same as SUM(C9,D9,,E9) (which is valid for Excel 2013 en-us)
If not, then I would expect SUM(C9;D9) to fail as well.
Please respond what locale you're using for Excel, LibreOffice, the file, and POI.
Please report if POI is able to parse SUM(C9;D9) on your system.
191037
3
dominik.stadler
2016-05-17 19:27:01 +0000
No response on the questions, so no way to fix something here for now, please reopen with the required info if you are still having this problem.