Re: why doesnt poi.hssf count all columns ?

["Andrew C. Oliver" <an...@superlinksoftware.com>]

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" <in...@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/