poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stéphane VANDENBOGAERDE /vst .Y" <stephane.vandenbogae...@mikrosimage.fr>
Subject Re: HFFSCell : null / blank
Date Tue, 22 Jan 2008 15:44:55 GMT
"POI Users List" <user@poi.apache.org> écrit :
>
>Consider the following row:
>
>   col 1    |   col 2   |   col 3    |  col 4  |  col 5  |  col 6 
>-----------------------------------------------------------------
>Foo        |           |    22      | (blank) |         |  33
>
>getPhysicalNumberOfCells() returns 4
>getFirstCol() returns 0
>getLastCol() returns 5
>
>getCell((short)1) returns null
>getCell((short)4) returns null

Thanks for this explanation.

But here what behaviour I get :

In Excel, I have :

    col0    |    col1    |    col2    |    col3    |    col4    |    col5 
  
---------------------------------------------------------------------
    foo0       foo1                        foo3


getPhysicalNumberOfCells() returns me 6.

So I can conclude that my array in interpreted as :

    col0    |    col1    |    col2    |    col3    |    col4    |    col5 
  
---------------------------------------------------------------------
    foo0       foo1       BLANK     foo3      BLANK    BLANK

But so I shouldn't get null cells...


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message