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 2009/07/06 14:22:39 UTC

DO NOT REPLY [Bug 47479] New: initialisation of record 0x205 left 1 bytes remaining still to be read

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

           Summary: initialisation of record 0x205 left 1 bytes remaining
                    still to be read
           Product: POI
           Version: 3.5-dev
          Platform: Macintosh
        OS/Version: Linux
            Status: NEW
          Severity: critical
          Priority: P1
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: vesa_akerman@sil.org


Gives this error when creating new HSSFWorkbook.  The excel file was made with
OpenOffice 3.0, and converted to Microsoft Excel 97/... format.
This error occurs ONLY WHEN THERE ARE BOOLEAN VALUES in the spreadsheet!

-- 
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 47479] 'initialisation of record 0x205 left 1 bytes remaining still to be read', when BOOLEAN values in the spreadsheet

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


Vesa Akerman <ve...@sil.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|initialisation of record    |'initialisation of record
                   |0x205 left 1 bytes          |0x205 left 1 bytes
                   |remaining still to be read  |remaining still to be
                   |                            |read', when BOOLEAN values
                   |                            |in the spreadsheet




-- 
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 47479] 'initialisation of record 0x205 left 1 bytes remaining still to be read', when BOOLEAN values in the spreadsheet

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


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

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




--- Comment #1 from Josh Micich <jo...@gildedtree.com>  2009-07-06 13:06:27 PST ---
I think the mistake is in OOO Calc - line 651 of xetable.cxx:
(http://svn.services.openoffice.org/ooo/trunk/sc/source/filter/excel/xetable.cxx)
This is inconsistent with the documentation.

I would propose this fix:

Index: xetable.cxx
===================================================================
--- xetable.cxx (revision 268869 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=268869 ))
+++ xetable.cxx (working copy)
@@ -648,7 +648,7 @@

 void XclExpBooleanCell::WriteContents( XclExpStream& rStrm )
 {
-    rStrm << sal_uInt16( mbValue ? 1 : 0 ) << EXC_BOOLERR_BOOL;
+    rStrm << sal_uInt8( mbValue ? 1 : 0 ) << EXC_BOOLERR_BOOL;
 }

 //
----------------------------------------------------------------------------


I guess Excel is able to read the file because the desired value of 0
(==EXC_BOOLERR_BOOL) still gets written to the second data byte.  


Fixed in svn r791595 ( https://svn.apache.org/viewcvs.cgi?view=rev&rev=791595 )

I wrote a unit test to reproduce the problem and also modified POI to tolerate
the OOO Calc bug.

-- 
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