poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 45909] New: isArgumentDelimiter does not recognise semi-colon as delimiter
Date Mon, 29 Sep 2008 11:27:00 GMT
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


Mime
View raw message