LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
missing column szelinko Excel Discussion (Misc queries) 0 March 28th 08 03:26 PM
Help - Column D is missing. CarlosJumenez Excel Worksheet Functions 3 October 16th 07 06:11 PM
Row and column headings missing Steve Excel Worksheet Functions 6 August 9th 07 10:52 PM
Missing column and row markers Lauren Giles Excel Discussion (Misc queries) 4 February 28th 07 01:11 AM
Display missing Part Number if Column A does not match column B Erik T Excel Worksheet Functions 2 April 17th 06 11:23 PM


All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"