Cell formatting question

[daveinhull]

Hi,

A quick question.

If I format a cell with, say

Code: Pascal  [Select][+][-]

1. Grid.NumberFormat[1,20] := 'mmm/yy';

would there be any difference if I typed in that cell or set the contents of the cell in code?

It seems, unless I've got something wrong, that if I type, say 1/12/21, I get what I would expect, Dec/21. But, if I set the cell contents to '1/12/21' with

Code: Pascal  [Select][+][-]

1. Grid.cells[1,20]:= '1/12/21';

all I get is 1/12/21, the formatting doesn't seem to take effect.

Is this correct?

Thanks
Dave

[wp]

Code: Pascal  [Select][+][-]

1. Grid.cells[1,20]:= '1/12/21';

all I get is 1/12/21, the formatting doesn't seem to take effect.

Doing this puts a string into the cell - there is no attempt to convert it to a date. But when you assign a TDateTime it works:

Code: Pascal  [Select][+][-]

1. Grid.Cells[1,20] := EncodeDate(2021, 1, 12);

[daveinhull]

Hi wp,

Yes it does't attempt to put a string into the cell, so I will change it to a TDateTime and give it a try.

Thanks
Dave