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 2008/09/29 13:27:00 UTC
DO NOT REPLY [Bug 45909] New: isArgumentDelimiter does not recognise
semi-colon as delimiter
https://issues.apache.org/bugzilla/show_bug.cgi?id=45909
Summary: isArgumentDelimiter does not recognise semi-colon as
delimiter
Product: POI
Version: 3.1
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: torben.wolm@LEGO.com
When opening a spreadsheet that contains formulas which use ';' as argument
delimiter, I get a FormulaParseException.
For example:
org.apache.poi.hssf.model.FormulaParser$FormulaParseException: Parse error near
char 19 ';' in specified formula 'ROUND((K1171/X1171);1)'. Expected ',' or ')'
at
org.apache.poi.hssf.model.FormulaParser.expected(FormulaParser.java:139)
at
org.apache.poi.hssf.model.FormulaParser.Arguments(FormulaParser.java:410)
at
org.apache.poi.hssf.model.FormulaParser.function(FormulaParser.java:308)
This was not the case in version 2.5 of POI. Is there a particular reason that
"isArgumentDelimiter" does not accept ";"?
private static boolean isArgumentDelimiter(char ch) {
return ch == ',' || ch == ')';
}
It is quite a big task if we have to run through all our template XLS-files to
check for formulas and update the delimiters...
Kind regards
Torben
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45909] isArgumentDelimiter does not recognise
semi-colon as delimiter
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45909
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |WONTFIX
--- Comment #1 from Josh Micich <jo...@gildedtree.com> 2008-09-29 14:25:55 PST ---
POI consistently treats formula argument delimiters as commas. Depending on
internationalisation settings Excel will use ',' or ';' (but never both). In
other words, you can enter a formula with POI using commas, and it *may*
display in Excel with semicolons. Conversely, a formula entered in Excel with
semi-colons will render with commas in POI.
The choice of comma or semi-colon is not encoded in the excel files at all. On
windows systems, it is found in the 'Regional and Language Options' of Control
Panel. (So you don't need to worry about converting any XLS files).
The only way this exception can occur is if you supply a formula to POI using
semicolons. An easy work around is to make sure you use commas as argument
delimiters in any formulas you manipulate with java code. Were you doing
something else? If so, can you re-open and supply more details (full POI stack
trace, sample code, sample files)?
Use of semicolons in formulas was already mentioned in bug 45025. Adding an
internationalision feature to POI is possible, but probably not worth the
effort.
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 45909] isArgumentDelimiter does not recognise
semi-colon as delimiter
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=45909
Josh Micich <jo...@gildedtree.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |eduard.dudar@gmail.com
--- Comment #2 from Josh Micich <jo...@gildedtree.com> 2010-06-17 13:50:53 EDT ---
*** Bug 49457 has been marked as a duplicate of this bug. ***
--
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org