DisplayReferenceName Property (WorkbookView)

Visual Basic
C#
Delphi
JScript
Managed Extensions for C++
C++/CLI

'Declaration
 
<System.ComponentModel.CategoryAttribute("Display")>
<System.ComponentModel.DescriptionAttribute("Determines which name or names to display on custom tabs created with the DisplayReference property.")>
<System.ComponentModel.DefaultValueAttribute()>
Public Property DisplayReferenceName As System.String

'Usage
 
Dim instance As WorkbookView
Dim value As System.String
 
instance.DisplayReferenceName = value
 
value = instance.DisplayReferenceName

[System.ComponentModel.Category("Display")]
[System.ComponentModel.Description("Determines which name or names to display on custom tabs created with the DisplayReference property.")]
[System.ComponentModel.DefaultValue()]
public System.string DisplayReferenceName {get; set;}

public read-write property DisplayReferenceName: System.String;

System.ComponentModel.CategoryAttribute("Display")
System.ComponentModel.DescriptionAttribute("Determines which name or names to display on custom tabs created with the DisplayReference property.")
System.ComponentModel.DefaultValueAttribute()
public function get,set DisplayReferenceName : System.String

[System.ComponentModel.Category("Display")]
[System.ComponentModel.Description("Determines which name or names to display on custom tabs created with the DisplayReference property.")]
[System.ComponentModel.DefaultValue()]
public: __property System.string* get_DisplayReferenceName();
public: __property void set_DisplayReferenceName( 
   System.string* value
);

[System.ComponentModel.Category("Display")]
[System.ComponentModel.Description("Determines which name or names to display on custom tabs created with the DisplayReference property.")]
[System.ComponentModel.DefaultValue()]
public:
property System.String^ DisplayReferenceName {
   System.String^ get();
   void set (    System.String^ value);
}

Use the WorkbookView.DisplayReferenceName property in conjunction with the WorkbookView.DisplayReference property to specify the text to display on the "sheet tabs" of the workbook view control.

The names are specified as a comma separated list of formulas which return the text to display. Some valid examples include:

"\"MySheet1\", \"MySheet2\"" displays "MySheet1" on the first sheet tab and "MySheet2" on the second sheet tab.
"[Book1]Sheet1!A1" displays the text in the cell A1 on the first sheet tab.

C#

/*
         * Demonstrate DisplayReference and DisplayReferenceName usage.
         */
        private void radioButton_CheckedChanged(object sender, EventArgs e)
        {
            if (radioButtonWorkbook.Checked)
            {
                // Change the display reference to a workbook.
                workbookView.DisplayReference = "Book2";
                workbookView.DisplayReferenceName = null;
            }
            else if (radioButtonWorksheet.Checked)
            {
                // Change the display reference to a worksheet and name it.
                workbookView.DisplayReference = "[Book1]Sheet1!A:IV";
                workbookView.DisplayReferenceName = "\"My Worksheet\"";
            }
            else if (radioButtonRange.Checked)
            {
                // Change the display reference to a range and name it.
                workbookView.DisplayReference = "[Book3]Sheet2!A1:C3";
                workbookView.DisplayReferenceName = "\"My Range\"";
            }
            else if (radioButtonDefinedName.Checked)
            {
                // Change the display reference to a defined name and name it.
                workbookView.DisplayReference = "Book2!MyName";
                workbookView.DisplayReferenceName = "\"My Defined Name\"";
            }
            else if (radioButtonMultipleRanges.Checked)
            {
                // Change the display reference to multiple ranges and name them.
                workbookView.DisplayReference = "[Book1]Sheet1!A1:C3,[Book1]Sheet1!4:6,[Book1]Sheet1!D:F";
                workbookView.DisplayReferenceName = "\"My Range1\",\"My Range2\",\"My Range3\"";
            }
        }

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

WorkbookView Class
WorkbookView Members
DisplayReference Property