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

Using ADDRESS Formula Produces Error

Thread ID:





123481 Mar 21,2016 05:29 PM UTC Mar 22,2016 06:05 AM UTC WinForms 1
Tags: GridControl
Asked On March 21, 2016 05:29 PM UTC

I am attempting to use both the COUNTIF and ADDRESS formulas but am not having success. I know the row number and column number of the cells that I want to use in the COUNTIF formula. I figured I would use the ADDRESS formula within the COUNTIF formula to convert my numbers to a cell reference. I couldn't get that to work so I trimmed down the formula to just use the ADDRESS formula to see if that was working. I cannot get that to work either. Here is my simple code:
grid[5, 5].CellType = GridCellTypeName.FormulaCell;
grid[5, 5].Text = "=ADDRESS(3, 4)";

When I run this code I see the message "Index was outside the bounds of the array." in the grid in cell 5,5. I get that message regardless of which row and column number I use in the ADDRESS formula. What am I doing wrong?


Amresh S [Syncfusion]
Replied On March 22, 2016 06:05 AM UTC

Hi Daniel,

Thank you for using Syncfusion products.

We analyzed your query and found it is a bug. It will be rectified in our upcoming releases.

Since the third parameter is mandatory in Grid and, it could be passed as 0 or 1.

The following code example could be used for your requirement.

Code Example:

this.gridControl1[5, 5].Text = "=Address(3,4,1)";

Please let us know if you have any other queries.


Amresh S.


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.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

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