[Solved] Cannot get SpreadsheetGrid.NumberFormat to work
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
daveinhull · 2022-01-27 23:05

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][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
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 · 2022-01-30 16:42

Hi,

Any thoughts from anyone?

Thanks
Dave

----------------------------------------------------------------------
wp · 2022-01-30 17:29

Did you try to uncheck AutoDetectCellType?

----------------------------------------------------------------------
daveinhull · 2022-01-31 08:42

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