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

Personalize Errors using Named Ranges

Thread ID:

Created:

Updated:

Platform:

Replies:

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

Hello,

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.

 

Thanks,

Pannir



FormulaValueChanged_49143bb3.zip

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

;