Personalize Errors using Named Ranges

[Carlos Diaz]

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]

Is there a solution for this ? 

[Pannir Selvam S]

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