We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Referencing cells by their A1-style address

Thread ID:

Created:

Updated:

Platform:

Replies:

103235 Apr 15,2012 04:29 AM UTC Jan 13,2015 05:27 PM UTC WinForms 2
loading
Tags: GridControl
Administrator [Syncfusion]
Asked On April 15, 2012 04:29 AM UTC

I'm using a GridControl. I need to programmatically reference several cells by their A1-style addresses. Is there any syntax for doing so? If not, does the Syncfusion library offer a function for converting between an A1-style address to a column number and row number?

-TC


Jeya Preetha M [Syncfusion]
Replied On April 24, 2012 08:21 AM UTC

Hi Tc,

Thank you for your interest in Syncfusion Products.

To convert the row number and column number to A1 style address, Please make use of "GetAlphaLabel()" and "GetNumericLabel()" methods.


Console.Write(GridRangeInfo.GetAlphaLabel(3));
Console.Write(GridRangeInfo.GetNumericLabel(3));


Please let me know if you have any concerns.

Regards,
Jeya Preetha M


Chris Bishop
Replied On January 13, 2015 05:27 PM UTC

I'm using a GridControl. I need to programmatically reference several cells by their A1-style addresses. Is there any syntax for doing so? If not, does the Syncfusion library offer a function for converting between an A1-style address to a column number and row number?

-TC


To convert "A1":
Row 1 = model.Engine.RowIndex("A1")
Col 1 = model.Engine.ColIndex("A1")



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;