Formulas

Hi,

Can you let me know how to get the Cell location as A1 or A2 from the row and column index.

I have the row and column Index in my code. but in order for me to apply a formula I need to comvert this row & column index to A1 or A2.

thanks
thanvir

1 Reply

HA haneefm Syncfusion Team September 28, 2007 06:45 PM UTC

Hi Thanvir,

You can get the location text of the gridcell using the GridRangeInfo.GetAlphaLabel and GridRangeInfo.GetNumericLabel method. Here is a code snippet:

string cellLocationText = GridRangeInfo.GetAlphaLabel(ColIndex) + GridRangeInfo.GetNumericLabel(RowIndex);

Best Regards,
Haneef

Loader.
Up arrow icon