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.
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.
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.
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.