# GoogleSheetsSetBasicFilterRequest

Applies a Google Sheets basic filter to a range.

Class 

`OfficeIMO.Excel.GoogleSheets`

**Namespace**

`OfficeIMO.Excel.GoogleSheets`

**Assembly**

`OfficeIMO.Excel.GoogleSheets`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[GoogleSheetsRequest.cs:151](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L151)

**Base**

`GoogleSheetsRequest`

**Modifiers**

sealed

Applies a Google Sheets basic filter to a range.

## Inheritance

- [GoogleSheetsRequest](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsrequest/)
- GoogleSheetsSetBasicFilterRequest

Filter members 

Show inherited

## Constructors

`public GoogleSheetsSetBasicFilterRequest()` [#](#constructor-ctor)

[GoogleSheetsRequest.cs:151](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L151)

Creates a basic-filter request.

## Inherited Methods

`public virtual bool Equals(object? obj)` [#](#method-equals-object)

Inherited from object

Parameters

**obj object? required**

Returns

`bool`

`public virtual int GetHashCode()` [#](#method-gethashcode)

Inherited from object

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public virtual string? ToString()` [#](#method-tostring)

Inherited from object

Returns

`string?`

## Properties

`public string SheetName { get; set; }` [#](#property-sheetname)

[GoogleSheetsRequest.cs:151](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L151)

Gets or sets the worksheet containing the filter.

`public string A1Range { get; set; }` [#](#property-a1range)

[GoogleSheetsRequest.cs:153](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L153)

Gets or sets the filter range in A1 notation.

`public int StartRowIndex { get; set; }` [#](#property-startrowindex)

[GoogleSheetsRequest.cs:155](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L155)

Gets or sets the inclusive zero-based first row.

`public int EndRowIndexExclusive { get; set; }` [#](#property-endrowindexexclusive)

[GoogleSheetsRequest.cs:157](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L157)

Gets or sets the exclusive zero-based ending row.

`public int StartColumnIndex { get; set; }` [#](#property-startcolumnindex)

[GoogleSheetsRequest.cs:159](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L159)

Gets or sets the inclusive zero-based first column.

`public int EndColumnIndexExclusive { get; set; }` [#](#property-endcolumnindexexclusive)

[GoogleSheetsRequest.cs:161](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L161)

Gets or sets the exclusive zero-based ending column.

`public IReadOnlyList<GoogleSheetsFilterColumnCriteria> Criteria { get; set; }` [#](#property-criteria)

[GoogleSheetsRequest.cs:163](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L163)

Gets or sets the column-specific filter criteria.

## Inherited Properties

`public string Kind { get; }` [#](#property-kind)

[GoogleSheetsRequest.cs:24](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Excel.GoogleSheets/GoogleSheetsRequest.cs#L24)

Inherited from [GoogleSheetsRequest](/api/excel-google-sheets/officeimo-excel-googlesheets-googlesheetsrequest/)

<!-- PowerForge markdown artifact sha256:D8B2028FC9CB8B7287BBAF1BAE87E260A6E4A961CAEB69ABC24D8295BF1ABDE9 -->
