Grid FormulaCell: position of A1 cell

Question

Hi

I am trying to setup a data grid with 3 header rows.  By doing this, my first data cell is in [3,1], and to reference this cell using a formula, I have to use "A3" (ex: "=A3*2").  Since it is the top-left cell in my grid, I would prefer to use "A1" to reference this cell.  Is it possible to do that?

Thanks,
Jean-Francois

Administrator · Answer

There is no property setting that will handle this. 

One way to get this behavior is to use 2 grids, a headergrid and the main grid. You could have a Panel and docked the headergrid to the top and just let it have the 3 headers and no other rows. Then you could dock-fill the main grid and hiding its header row. You can then handle some event to tie the two grid togerther so scrolling is synced up and column sizes are synced up. Attached is a little sample. PanelWithTwoGrids.zip