Export (0) Print
Expand All

SmartTagBase.Expressions Property (2007 System)

Gets the collection of regular expressions that the smart tag will recognize.

Namespace:  Microsoft.Office.Tools
Assembly:  Microsoft.Office.Tools.Common.v9.0 (in Microsoft.Office.Tools.Common.v9.0.dll)

public RegexCollection Expressions { get; }

Property Value

Type: Microsoft.Office.Tools.RegexCollection
Gets a RegexCollection that contains the regular expressions that the smart tag will recognize.

Use the Add method to add a regular expression to the set of regular expressions that the smart tag will recognize.

The following code example creates a Microsoft.Office.Tools.Excel.SmartTag and then uses the Expressions property to add the regular expression "[I|i]ssue\s\d{5,6}" to the collection of regular expressions that the smart tag recognizes. This code example is part of a larger example provided for the Microsoft.Office.Tools.Excel.Action class.

This example is for a document-level customization.

private Microsoft.Office.Tools.Excel.Action displayAddress;

private void AddSmartTag()
{
    Microsoft.Office.Tools.Excel.SmartTag smartTagDemo =
        new Microsoft.Office.Tools.Excel.SmartTag(
        "www.microsoft.com/Demo#DemoSmartTag",
        "Demonstration Smart Tag");

    // Specify a term and an expression to recognize.
    smartTagDemo.Terms.Add("sale");
    smartTagDemo.Expressions.Add(
        new System.Text.RegularExpressions.Regex(
        @"[I|i]ssue\s\d{5,6}"));

    // Create the action.
    displayAddress = new Microsoft.Office.Tools.Excel.Action(
        "To be replaced");

    // Add the action to the smart tag.
    smartTagDemo.Actions = new Microsoft.Office.Tools.Excel.Action[] { 
        displayAddress };

    // Add the smart tag. 
    this.VstoSmartTags.Add(smartTagDemo);

    displayAddress.BeforeCaptionShow += new 
        Microsoft.Office.Tools.Excel.BeforeCaptionShowEventHandler(
        DisplayAddress_BeforeCaptionShow);

    displayAddress.Click += new 
        Microsoft.Office.Tools.Excel.ActionClickEventHandler(
        DisplayAddress_Click);
}

Community Additions

ADD
Show:
© 2014 Microsoft