https://issues.apache.org/bugzilla/show_bug.cgi?id=44951
Summary: DVRecord doesn't support Decimal and Date validation
types
Product: POI
Version: 3.0
Platform: PC
OS/Version: Windows 2000
Status: NEW
Severity: major
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [EMAIL PROTECTED]
(at least, decimal and date are the ones I've tried)
How to reproduce: create a new excel, select a cell and add a validation
Allow: decimal
Data: between
Minimum:0
Maximum:999999
Opening the XLS file with POI fails with an exception.
This is the stack trace
org.apache.poi.hssf.record.RecordFormatException: Unable to construct record
instance
at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:199)
at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java:117)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:207)
at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:148)
at pruebas.PoiTest.testRunTest(PoiTest.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
...
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:80)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:44)
at java.lang.reflect.Constructor.newInstance(Constructor.java:315)
at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java:187)
... 18 more
Caused by: java.lang.UnsupportedOperationException: Unknown Ptg in Formula:
0x0 (0)
at org.apache.poi.hssf.record.formula.Ptg.createPtg(Ptg.java:357)
at org.apache.poi.hssf.record.DVRecord.fillFields(DVRecord.java:201)
at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
at org.apache.poi.hssf.record.DVRecord.<init>(DVRecord.java:134)
... 23 more
--
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]
