aspose.cells

Class FilterColumn

Represents a filter for a single column. The Filter object is a member of the Filters collection

Property Getters/Setters Summary
functiongetFieldIndex()
function
           Gets and sets the column offset in the range.
functiongetFilter()
function
setFilter(value)
           Gets and sets the condition of filtering data.
functiongetFilterType()
function
           Gets and sets the type fo filtering data. The value of the property is FilterType integer constant.
functionisDropdownVisible()
function
           Indicates whether the AutoFilter button for this column is visible.
functiongetVisibledropdown()
function
           Indicates whether the AutoFilter button for this column is visible.
 

    • Property Getters/Setters Detail

      • isDropdownVisible/setDropdownVisible : boolean 

        function isDropdownVisible() / function setDropdownVisible(value)
        
        Indicates whether the AutoFilter button for this column is visible.
      • getVisibledropdown/setVisibledropdown : boolean 

        function getVisibledropdown() / function setVisibledropdown(value)
        
        Indicates whether the AutoFilter button for this column is visible. NOTE: This member is now obsolete. Instead, please use FilterColumn.IsDropdownVisible to check whether the AutoFilter button for this column is visible. This property will be removed 12 months later since September 2020. Aspose apologizes for any inconvenience you may have experienced.
      • getFilter/setFilter : Object 

        function getFilter() / function setFilter(value)
        
        Gets and sets the condition of filtering data.
      • getFilterType/setFilterType : Number 

        function getFilterType() / function setFilterType(value)
        
        Gets and sets the type fo filtering data. The value of the property is FilterType integer constant.
      • getFieldIndex/setFieldIndex : Number 

        function getFieldIndex() / function setFieldIndex(value)
        
        Gets and sets the column offset in the range.