Bug 59362 - Formula parsing fails with doubled semi-colon in SUM()
Summary: Formula parsing fails with doubled semi-colon in SUM()
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.14-FINAL
Hardware: PC Linux
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2016-04-20 19:23 UTC by Ian Giguère
Modified: 2016-05-17 19:27 UTC (History)
1 user (show)


Note You need to log in before you can comment on or make changes to this bug.
Description Ian Giguère 2016-04-20 19:23:21 UTC
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.
Comment 1 Javen O'Neal 2016-04-20 21:26:21 UTC
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.
Comment 2 Javen O'Neal 2016-04-20 21:34:51 UTC
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.
Comment 3 Dominik Stadler 2016-05-17 19:27:01 UTC
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.