You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2008/04/02 01:49:06 UTC

DO NOT REPLY [Bug 44735] New: Re-serialization of DATAVALIDATION records is incorrect

https://issues.apache.org/bugzilla/show_bug.cgi?id=44735

           Summary: Re-serialization of DATAVALIDATION records is incorrect
           Product: POI
           Version: 3.0-dev
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: josh@gildedtree.com


There are probably many bugs here.


One bug is when the formulas involve references: Example of how to reproduce:
create a spreadsheet with a data validation: (Allow="Decimal", Data="between",
Minimum="=B1", Maximum="=C1").  POI *seems* to read the spreadsheet OK, but
crashes while trying to re-serialise this spreadsheet.

The attachment from bug 44710 won't re-open in Excel after being re-serialised
by POI. (https://issues.apache.org/bugzilla/attachment.cgi?id=21739)

The sample file referred to by TestBugs.test44593() (i.e. 44593.xls) also
causes Excel to report errors/data loss after being re-written by POI.


Some DATAVALIDATION encoding errors cause Excel(2007) to crash completely.


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 44735] Re-serialization of DATAVALIDATION records is incorrect

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44735

Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |RESOLVED
         Resolution|                            |FIXED

--- Comment #2 from Josh Micich <jo...@gildedtree.com> 2009-12-31 12:36:58 UTC ---
Retested OK with POI 3.6

There seems to have been two bugs that needed fixing.

The first bug fix was with bug 44792 (svn r646666).  This error was observable
the with file from bug 44710 (attachment id=21739) - Failure during re-reading
of CRNRecord:

org.apache.poi.hssf.record.RecordFormatException: Unable to construct record
instance
    ...
Caused by: java.lang.ArrayIndexOutOfBoundsException
    at
org.apache.poi.hssf.record.RecordInputStream.checkRecordPosition(RecordInputStream.java:132)
    at
org.apache.poi.hssf.record.RecordInputStream.readByte(RecordInputStream.java:140)
    at
org.apache.poi.hssf.record.constant.ConstantValueParser.readAConstantValue(ConstantValueParser.java:58)
    at
org.apache.poi.hssf.record.constant.ConstantValueParser.parse(ConstantValueParser.java:52)
    at org.apache.poi.hssf.record.CRNRecord.fillFields(CRNRecord.java:62)
    at org.apache.poi.hssf.record.Record.<init>(Record.java:55)
    at org.apache.poi.hssf.record.CRNRecord.<init>(CRNRecord.java:43)
    ...



The second bug was fixed with bug 44921 (svn r652934 + svn r652936).  This was
observable with an example file produced as described - POI failed to serialize
the DVRecord:
java.lang.RuntimeException: Coding Error: This method should never be called.
This ptg should be converted
    at org.apache.poi.hssf.record.formula.RefNVPtg.writeBytes(RefNVPtg.java:50)
    at org.apache.poi.hssf.record.DVRecord.serialize(DVRecord.java:462)
    at org.apache.poi.hssf.model.Sheet.serialize(Sheet.java:830)

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

DO NOT REPLY [Bug 44735] Re-serialization of DATAVALIDATION records is incorrect

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=44735


Nick Burch <ni...@torchbox.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO




--- Comment #1 from Nick Burch <ni...@torchbox.com>  2008-07-10 15:53:17 PST ---
Could you please re-test with POI 3.1 FINAL, and let us know if the problem is
now fixed? There have been some improvements in this area


-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org