Spreadsheet Hyperlink Wrong Hyperlink Window

[Kate]

Hello! I have a problem with Spreadsheet Hyperlink. We use it to open our own objects, and every time we click such hyperlinks, spreadsheet shows a wrong hyperlink window. How can I override OpenHyperlink function (as I did it with the RadRichText control), or just hide the wrong hyperlink window?

[Anna]

Hi,

You can easily suppress the alert by using the MessageShowing event of the RadSpreadsheet class. The following snippet hides the alerts containing a message about wrong address of the hyperlink or about a wrong reference:

private void RadSpreadsheet_MessageShowing(object sender, MessageShowingEventArgs e)
{
    string hyperlinkError = LocalizationManager.GetString("Spreadsheet_MessageBox_InvalidUriDescription");
    string referenceError = LocalizationManager.GetString("Spreadsheet_MessageBox_InvalidReferenceDescription");

    if (e.Content.Equals(hyperlinkError, StringComparison.CurrentCulture) ||
        e.Content.Equals(referenceError, StringComparison.CurrentCulture))
    {
        e.IsHandled = true;
    }
}

Regards,
Anna
Telerik

 

 

[Kate]

Thank you! We should update our product version.