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 2003/03/03 10:41:25 UTC

DO NOT REPLY [Bug 17582] New: - Formula Parser cannot parse formulas containing non-alphabetical characters

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17582>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=17582

Formula Parser cannot parse formulas containing non-alphabetical characters

           Summary: Formula Parser cannot parse formulas containing non-
                    alphabetical characters
           Product: POI
           Version: unspecified
          Platform: PC
        OS/Version: Other
            Status: NEW
          Severity: Critical
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: ext-jens.riis@nokia.com


The formulaparser fails when text contains no alpha characters (e.g) giving the 
argument "(" & F3 & ")" throws an exception. The code in 
org.apache.poi.hssf.model.FormulaParser.StringLiteral() executes the method 
GetNameAsIs() which in turn calls isAlpha() that only allows for alphabetic 
characters which of course is to limited for a formula like the above.