why doesnt poi.hssf count all columns ?

[Wolf Fietz]

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-***@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/

[Balaji]

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

Post by Wolf Fietz
hi all,
i refer to the examples given for reading and writing excel-sheets
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
---------------------------------------------------------------------
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/

[Andrew C. Oliver]

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

Post by Balaji
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

Post by Wolf Fietz
hi all,
i refer to the examples given for reading and writing excel-sheets
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
---------------------------------------------------------------------
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-***@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/