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" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
> 
> 
> 

Reply via email to