AutoFilter class reference

  • bool getRef(int* rowFirst, int* rowLast, int* colFirst, int* colLast)
    Gets the cell range of AutoFilter with header. Returns false if error. Get error info with Book::errorMessage().
  • void setRef(int rowFirst, int rowLast, int colFirst, int colLast)
    Sets the cell range of AutoFilter with header.
  • FilterColumn column(int colId)
    Returns the AutoFilter column by zero-based index. Creates it if it doesn't exist.
  • int columnSize() const
    Returns the number of specified AutoFilter columns which have a filter information.
  • FilterColumn columnByIndex(int index)
    Returns the specified AutoFilter column which have a filter information by index.
  • bool getSortRange(int* rowFirst, int* rowLast, int* colFirst, int* colLast)
    Gets the whole range of data to sort. Returns false if error. Get error info with Book::errorMessage().
  • bool getSort(int* columnIndex, bool* descending)
    Gets the zero-based index of sorted column in AutoFilter and its sort order. Returns false if error. Get error info with Book::errorMessage().
  • bool setSort(int columnIndex, bool descending = false)
    Sets the sorted column in AutoFilter by zero-based index and its sort order. Returns false if error. Get error info with Book::errorMessage(). See the example.