[Solved] Cannot get SpreadsheetGrid.NumberFormat to work

[daveinhull]

Hi,

I'm struggling a bit with FPSpreadsheetGrid at the moment.
I'm trying to formal a cell to have date format of 'mmm/yy', but it dosn't seem to work.

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

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

But if I enter 1/1/22 into Cells[1,1] I just get 01/01/2022, not Jan/22 has I was expecting.

Any help would be appreciated.

many thanks in advance
Dave

[daveinhull]

Hi,

Any thoughts from anyone?

Thanks
Dave

[wp]

Did you try to uncheck AutoDetectCellType?

[daveinhull]

Hi wp,

That's got it. I had looked at this and I had unchecked AutoDetectCellType, but after I had tried working with setting formats and end up detecting the cell and manually formatting the date in code.
Silly developer error, changing more than one thing at once and not sticking to the testing strategy.

Appreciate you help

Thanks
Dave