DO NOT REPLY [Bug 25457] New: - [PATCH] Formula Parser doesn't allow ' around worksheet names

[bu...@apache.org]

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=25457>.
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=25457

[PATCH] Formula Parser doesn't allow ' around worksheet names

           Summary: [PATCH] Formula Parser doesn't allow ' around worksheet
                    names
           Product: POI
           Version: 2.0-pre3
          Platform: All
        OS/Version: Other
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: pete@quantrix.com


In Excel, worksheets with spaces and/or weird characters in their names can be 
referred to using single-ticks.  For instance: 'Profit and Loss'!A3..A5

The patch I'm submitting allows formulas to surround worksheet names with 
single-ticks.  As a side-effect it allows one to surround regular cell 
references with single-ticks in certain cases.  The parser seemed to be 
generous about these cases in general, so I assumed it would be ok.

This patch was generated against the REL_2_0_RC1 tagged version.  Please let 
me know if you'd like it against the tip of REL_2_BRANCH and/or the HEAD 
itself.

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-dev-help@jakarta.apache.org