poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <a...@superlinksoftware.com>
Subject Re: why doesnt poi.hssf count all columns ?
Date Tue, 01 Feb 2005 14:32:05 GMT
In the past it was because the Excel Dev Guide said that it was supposed
to be one less than the number of columns in the row (don't ask me why
-- this file format is crap hence the name calling).  If what you're
saying is true, either this changed later or the book lied and I
believed it.  Not sure which is the most likely.

To verify:

Test generating /reading with BiffViewer on Excel 97, 2000, XP, 2003 and
see if each return cols rather than cols-1
I don't have time to verify it right now.

-Andy

Balaji wrote:

>hi wolf, 
>
>I too faced the same problem, this problem happens only with POI generated Excel Documents,
If I opened the POI generated excel document and made some changes, that file column count
is taking very correctly.
>
>Regards,
>
>Balaji
>
>
>"Wolf Fietz" <info@technosoft-hofbieber.de> wrote in message news:ctcur4$hff$1@sea.gmane.org...
>  
>
>>hi all,
>>
>>there's a strange behaviour counting columns before readung excel tables :
>>
>>i refer to the examples given for reading and writing excel-sheets
>>if an excel table is manually generated , my be in this form :
>>
>>a1 b1 c1 d1
>>a2 b2 c2 d2
>>a3 b3 c3 d3
>>
>>the dimensions record counts 4 columns, so far ok
>>
>>but if the above table is automatically generated by hssf writer,
>>is says 3 columns instead of four  !?
>>
>>columnwidth and formats are all set well for every cell, but modifying
>>it takles no effect
>>
>>Only, if this automatic-genearated table is manually saved a 2nd time, then
>>suddenly
>>the column-count work correctly again !
>>
>>what i wonder about is, that only Label-SSTRecord and additionally
>>NumberRecord
>>is read in a serial  manner,
>>
>>but not SST-record, this reads a1 a2  a3 and then b1 c1 d1 b2 c2 b3 c3 d2 d3
>>..
>>for such behaviour any storing algorithm seems heavily to be found
>>
>>what reason for this ?
>>what can i do to get correct column-count ?
>>
>>regards
>>from wolf
>>
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
>>The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>>
>>
>>
>>    
>>
>
>  
>



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message