Hello,
I have a problem assigning the cells (via grid editor) with string such as '07/2019 '(I don't want to use DateTime type with format 'mm/yyyy' because I get the same basic problem).
Through internal functions there is no problem but manually typing on the grid is not taken as a string field but as a number (division)
.
I looked at the code in
TsCustomWorksheetGrid.SetCellValue () and I have no way to solve.
I thought that having an event that bypasses automatic control could be useful.
maybe something like this:
function (ACol, ARow: Integer; AValue: Variant): TCellContentType of object;
Maybe there is a way to "lock" a cell only to receive a specific TCellContentType without ever losing its memory (for example if it is momentarily emptied).
Also with Worksheet.OnChangeCell () I can't do anything because it would need something before the actual modification.
Do I have any other way?
any help is welcome