I am a little confused about what is the default data type for the cells in a column. The help file says: "Cell values are containers of the Variant data type."
But it also says: "You can face a problem when iGrid does not allow you to enter a fractional number in a cell that stores a numeric value. This occurs if you have initialized the cell with an integer (non-fractional) value."
It seems that the data type of a cell is assigned when the cell is initialized and is determined by the first value entered into a cell. So the data type of a cell is in fact not a variant but rather dynamically assigned by whatever is the first value entered into a cell in that column?
I want to initialize the cells of one column to hold the double data type. The help file says that I can do this in two ways:
iGrid1.ColDefaultCell(1).vValue = 0#
iGrid1.ColDefaultCell(1).vValue = CDbl(0)
Does this actually put a value of zero into all the cells of column 1 or only assign the double data type?
EDIT: I tested the code above and all the cells get a value of zero. Is it possible to initialize the cells of a column to the double data type but to have default null values?
Edited by user
| Reason: Not specified