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: [email protected]
ReportedBy: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
