Formulas

[Thanvir Hussain]

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

[haneefm]

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