You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2016/04/20 21:23:21 UTC
[Bug 59362] New: Formula parsing fails with doubled semi-column in
SUM()
https://bz.apache.org/bugzilla/show_bug.cgi?id=59362
Bug ID: 59362
Summary: Formula parsing fails with doubled semi-column in
SUM()
Product: POI
Version: 3.14-FINAL
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: ian@cybercat.ca
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.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59362] Formula parsing fails with doubled semi-column in SUM()
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59362
Ian Giguère <ia...@cybercat.ca> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |ian@cybercat.ca
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59362] Formula parsing fails with doubled semi-colon in SUM()
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59362
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution|--- |WONTFIX
--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59362] Formula parsing fails with doubled semi-colon in SUM()
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59362
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|REOPENED |NEEDINFO
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59362] Formula parsing fails with doubled semi-colon in SUM()
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59362
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |INVALID
Summary|Formula parsing fails with |Formula parsing fails with
|doubled semi-column in |doubled semi-colon in SUM()
|SUM() |
Status|NEW |RESOLVED
--- Comment #1 from Javen O'Neal <on...@apache.org> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 59362] Formula parsing fails with doubled semi-colon in SUM()
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=59362
Javen O'Neal <on...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|RESOLVED |REOPENED
Resolution|INVALID |---
--- Comment #2 from Javen O'Neal <on...@apache.org> ---
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.
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org