XmlMappedRange.FormulaLabel Property (2007 System)
Gets or sets the formula label type for the XmlMappedRange control.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)
Syntax
'Declaration
<BrowsableAttribute(False)> _
Public Property FormulaLabel As XlFormulaLabel
'Usage
Dim instance As XmlMappedRange
Dim value As XlFormulaLabel
value = instance.FormulaLabel
instance.FormulaLabel = value
[BrowsableAttribute(false)]
public XlFormulaLabel FormulaLabel { get; set; }
[BrowsableAttribute(false)]
public:
property XlFormulaLabel FormulaLabel {
XlFormulaLabel get ();
void set (XlFormulaLabel value);
}
public function get FormulaLabel () : XlFormulaLabel
public function set FormulaLabel (value : XlFormulaLabel)
Property Value
Type: XlFormulaLabel
The formula label type for the XmlMappedRange control.
Remarks
The return value of this property can be xlNone if the range contains no labels, or one of the following XlFormulaLabel constants:
Examples
The following code example uses the FormulaLabel property to set an XmlMappedRange to be a column label. This code example assumes that the current worksheet contains an XmlMappedRange named CustomerLastNameCell.
Private Sub ShowFormulaLabel()
Globals.ThisWorkbook.AcceptLabelsInFormulas = True
Me.CustomerLastNameCell.FormulaLabel = _
Excel.XlFormulaLabel.xlColumnLabels
End Sub
private void ShowFormulaLabel()
{
Globals.ThisWorkbook.AcceptLabelsInFormulas = true;
this.CustomerLastNameCell.FormulaLabel =
Excel.XlFormulaLabel.xlColumnLabels;
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.