SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Interface FilterHiddenOptions

    Options for IFormulaContext.filterHidden.

    interface FilterHiddenOptions {
        axes?: IRange.AxisSelection;
        onlyWhileFiltered?: boolean;
    }
    Index
    axes? onlyWhileFiltered?
    axes?: IRange.AxisSelection

    Which axis to filter on.

    IRange.AxisSelection.Row

    onlyWhileFiltered?: boolean

    Skip the hidden rows or columns only while the range's sheet is filtered: while some AutoFilter or table on that sheet holds a condition, whether or not it hides a row. Until then range is returned as it is, hidden rows included.

    This is SUBTOTAL 1-11 (Excel: they "include manually hidden rows", which is what an unfiltered sheet reads as). SUBTOTAL 101-111 and AGGREGATE leave it off and skip always.

    false

    Settings
    Member Visibility

    On This Page
    Properties