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

Personalize Errors using Named Ranges

Thread ID:





110035 Jul 16,2013 08:52 PM UTC Jul 23,2013 05:18 PM UTC WPF 2
Tags: SpreadsheetControl(Classic)
Carlos Diaz
Asked On July 16, 2013 08:52 PM UTC


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.

Carlos Diaz
Replied On July 23, 2013 01:47 PM UTC

Is there a solution for this ? 

Pannir Selvam S [Syncfusion]
Replied On 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.






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

or the page will be automatically redirected to 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