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. Image for the cookie policy date

Personalize Errors using Named Ranges


I'm using the named ranges but I need to personalize the errors that are showed when the named range is not created. At this moment is showed 'bad index', but I need to personalize it in order to show a most friendly message,

Could you provide me an example?

Thanks in advance.

Carlos Diaz.

2 Replies

CD Carlos Diaz July 23, 2013 01:47 PM UTC

Is there a solution for this ? 

PS Pannir Selvam S Syncfusion Team July 23, 2013 05:18 PM UTC

Hi Carlos,


Apologize for the delay.


You can customize the error message shown for incorrect formulas by modifying the FormulaErrorString property of GridFormulaEngine like in the below code snippet.


Code Snippet[C#]:

var errorStrings = grid.Model.FormulaEngine.FormulaErrorStrings;

for (int i = 0; i < errorStrings.Length; i++)


    if (errorStrings[i] == "bad index")

        grid.Model.FormulaEngine.FormulaErrorStrings[i] = "Named range not exists";




We have prepared a sample based on this and you can download the sample from the below location


Please let us know if you have any other queries.





Live Chat Icon For mobile
Up arrow icon