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 2010/07/22 23:31:37 UTC

DO NOT REPLY [Bug 49640] New: [PATCH] FormulaParser cannot parse formulas containing defined names beginning with an underscore

https://issues.apache.org/bugzilla/show_bug.cgi?id=49640

           Summary: [PATCH] FormulaParser cannot parse formulas containing
                    defined names beginning with an underscore
           Product: POI
           Version: 3.7-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: POI Overall
        AssignedTo: dev@poi.apache.org
        ReportedBy: DLewis400@Gmail.com


Created an attachment (id=25795)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25795)
Fixes incorrect rejection of defined names beginning with underscores in
formulas

Eclipse allows defined names to begin with either a letter or an underscore. 
These defined names may be present in a formula (e.g. =SUM(F15:F16)+_GP108). 
In the previous example _GP108 is a defined name beginning with an underscore.  

FormulaParser fails to process the defined name in the previous example because
the parseNonRange(int) function only tests whether the defined name begins with
a letter.  This occurs when processing xssf workbooks only.

The attached patch modifies the test for the defined name starting character to
accept underscores.

-- 
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 49640] [PATCH] FormulaParser cannot parse formulas containing defined names beginning with an underscore

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=49640

Yegor Kozlov <ye...@dinom.ru> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2010-07-26 11:53:56 EDT ---
Applied in r979329

Yegor

-- 
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