Hinweis
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, sich anzumelden oder das Verzeichnis zu wechseln.
Für den Zugriff auf diese Seite ist eine Autorisierung erforderlich. Sie können versuchen, das Verzeichnis zu wechseln.
Gets or sets a value that determines whether conditional formats will occur automatically.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public Property EnableFormatConditionsCalculation As Boolean
public bool EnableFormatConditionsCalculation { get; set; }
Property Value
Type: System.Boolean
true if evaluation of conditional formats will occur automatically; otherwise, false. The default is true.
Remarks
When the EnableFormatConditionsCalculation property is set to false, existing conditional formats will not be re-evaluated. Any previously applied conditional formatting will still be visible, but will not be updated as cell values or AppliesTo ranges are changed.
Set this property to true to configure a rule completely before evaluating it. This can result in a performance increase if the range over which the condition is applied is large.
.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.