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.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Cell Formulas

Thread ID:

Created:

Updated:

Platform:

Replies:

6496 Aug 14,2003 08:26 AM Aug 14,2003 11:50 AM Windows Forms 4
loading
Tags: GridControl
Greg Wright
Asked On August 14, 2003 08:26 AM

Can formulas be defined using R1C1 references? Thanks, Greg

Administrator [Syncfusion]
Replied On August 14, 2003 09:42 AM

If R1C1 means cell A1, then no, not currently. If this is not it, can you give an Excel example of what you mean?

Greg Wright
Replied On August 14, 2003 10:49 AM

> If R1C1 means cell A1, then no, not currently. > > If this is not it, can you give an Excel example of what you mean? > > Yes, R1C1 refers to A1. Are there any plans to implement this type of cell referencing? I have to build a lot of formulas dynamically. In most cases, I would have the row/col indexes of the cell(s) to include in a formula. Being able to use 'R1C1' syntax is obviously much simplier since I already have the indexes. If I can't use 'R1C1', the col index has to be converted into its corresponding Alpha name. Does grid have any method of converting a col index into its Alpha?

Administrator [Syncfusion]
Replied On August 14, 2003 10:53 AM

I am not sure whether we will make this available as an option. We'll have to look into what the impact would be. You can use the static method GridRangeInfo.GetAlphaLabel to convert from a colIndex into a alpha label.

Greg Wright
Replied On August 14, 2003 11:50 AM

Thanks Clay. I realize that if I am the only one requesting it, it would be a lower priority issue. I would be interested to find out if that's something that could be added to the queue of enhancements.

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

;