poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 60517] Incorrect parsing multiple sheet in formula
Date Wed, 04 Jan 2017 21:50:22 GMT

--- Comment #6 from Javen O'Neal <onealj@apache.org> ---
Created attachment 34589
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=34589&action=edit
Simplified test case workbook XLS

It looks like Excel 2013 allows sheet ranges to be unquoted if the first and
last sheet do not contain special characters that would require quoting for a
single sheet cell reference.

Otherwise, Excel 2013 quotes the sheet range instead of quoting the sheets

Valid: Sheet1:Sheet2!A1
Valid: 'Sheet1:Sheet2'!A1
Valid: 'Sheet 1:Sheet 2'!A1
Invalid: 'Sheet1':'Sheet2'!A1
Invalid: 'Sheet1'!A1:'Sheet2'!A1
Invalid: Sheet 1:Sheet 2!A1

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

View raw message