FormatConditionType
Vue de l’ensemble
‘FormatConditionType’ est un enum dans Aspose.Cells pour NET.
Description
‘FormatConditionType’ est un type d’enumer dans la bibliothèque Aspose.Cells FOSS pour .NET. Il définit un ensemble de constants nommés qui contrôlent le comportement ou spécifient les options au sein de l’API. Les enumérations telles que ‘FormatConditionTyp` aident à garantir la sécurité du type en limitant les valeurs à un set prédéfini.
Les valeurs
| Value | Description |
|---|---|
CellValue | Condition based on the cell value relative to a threshold |
Expression | Condition based on a custom formula expression |
ContainsText | Condition triggered when cell text contains a specified substring |
NotContainsText | Condition triggered when cell text does not contain a specified substring |
BeginsWith | Condition triggered when cell text starts with a specified string |
EndsWith | Condition triggered when cell text ends with a specified string |
TimePeriod | Condition based on a relative time period such as last week or this month |
DuplicateValues | Highlights cells whose values appear more than once in the range |
UniqueValues | Highlights cells whose values appear exactly once in the range |
Top10 | Highlights the top N values or top N percent of values in the range |
Bottom10 | Highlights the bottom N values or bottom N percent of values in the range |
AboveAverage | Highlights cells whose values exceed the range average |
BelowAverage | Highlights cells whose values fall below the range average |
ColorScale | Applies a graduated color scale across the value range |
DataBar | Displays a proportional data bar inside each cell |
IconSet | Assigns icon indicators based on value thresholds within the range |
Voir aussi
- Aspose.Cells pour .NET — Enterprise API Reference
