Hi,
I'm trying to use a FPSpreadsheetGrid, but when I enter a value into a cell and then press an arrow key or use the mouse to select anopther cell, the value in the cell I've just left (the one I entered the vale into) is null.
E.g.
I type 'hello' into Cells[1,1] and then press right arrow and in the OnSelectCell routine I check the value of Cells[1,1] and its null. This happens with all the arrow keys, the tab key and if I select another cell with the mouse.
However, if I use the return key it work, i.e I enter the hello intp Cells[1,1] and press return, it moves cells according to AutoAdvance and the OnSelectCell event shows that Cells[1,1] has the correct value, hello.
Is this the correct behaviour and ifit is how to I force Cells[1,1] to take the value?
Thanks
Dave
[Edit: If I use OnSelection rather than OnSelectCell it works as expected - guess I'm not clear about the difference, but assume that OnSelectCell is before the cell is actually selected and the therefore before the previous cell is finsihed doing everything it needs to do]