https://issues.apache.org/bugzilla/show_bug.cgi?id=45091
Summary: Custom validation formula is corrupted by POI
Product: POI
Version: 3.0-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
Created an attachment (id=22027)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=22027)
Sample excel spreadsheet that causes problem
I have created a new workbook using Excel 2000. I pick a cell, say C3, and
apply custom data validation to it using the following formula
=UPPER(C3)="X"
so that users can only enter x into the cell. I then saved the workbook.
If I then read in the workbook into an HSSFWorkbook and then save it again the
formula changes to
=UPPER(A1)="X"
If the formula is changed to
=UPPER($C$3)="X" then the formula is not changed when the workbook is loaded
into the HSSFWorkbook object.
I have seen this bug with the latest beta 3 build of poi
(poi-3.1-beta3-20080529).
--
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]
