Click or drag to resize

TopBottom Class

Describe the TopBottom conditional formatting rule. This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.
Inheritance Hierarchy
System Object
Spire.Xls.Core.Spreadsheet.ConditionalFormatting TopBottom

Namespace: Spire.Xls.Core.Spreadsheet.ConditionalFormatting
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
public class TopBottom

The TopBottom type exposes the following members.

Properties
Name Description
Public property Rank
Get or set the value of "n" in a "top/bottom n" conditional formatting rule. If TopPercent or BottomPercent, the value must between 0 and 100. Otherwise it must between 0 and 1000. Default value is 10.
Public property Type
Gets or sets the type of top or bottom, either as a percentage or a fixed value.
Top
Methods
Name Description
Public method Equals
Determines whether the specified object is equal to the current object.
(Inherited from Object .)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Public method GetHashCode
Serves as the default hash function.
(Inherited from Object .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
See Also