https://issues.apache.org/bugzilla/show_bug.cgi?id=44953
Summary: Datavalidation across sheets (list mode)
Product: POI
Version: unspecified
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
Created an attachment (id=21934)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=21934)
validation fault across sheets
Data validation list using another sheet fails
setting the data validation formula to:
String strFormula = "sheet1!$B$6:$B$9"
The program runs fine but on opening the xls file Excel says
File error: data may have been lost
If I change the formula to use defined range the the library throws an
exception
Validation of data list on the same sheet work
attached java test source formula used on line 118
Note: source write file to root of drive c on windows
poi library 3.1 - beta 1
--
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
