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" <[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/
--------------------------------------------------------------------- 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/
