View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matt Matt is offline
external usenet poster
 
Posts: 516
Default Missing Cell in a column when it is on row 16

Hi,
I read an excel worksheet in Delphi.
In a particular column I have a column name, then 15 empty rows and then a
number on row 16.
This column has the type string.

First question:
When in Delphi I check the value on row 16 it says NULL, and not the value
given in excel. Why?

Second question:
If I move my value on row 16 to a row less than row 10 then the format of
the column is changed automatically to FLOAT and then the value is the same
as given in excel.