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