Removes rows within this range that contain values in the specified columns that are duplicates of values in any previous row. Rows with identical values but different letter cases, formatting, or formulas are considered to be duplicates. More...
Properties | |
| virtual System.Collections.Generic.IList< DimensionRange > | ComparisonColumns [get, set] |
| The columns in the range to analyze for duplicate values. If no columns are selected then all columns are analyzed for duplicates. More... | |
| virtual GridRange | Range [get, set] |
| The range to remove duplicates rows from. More... | |
| virtual string | ETag [get, set] |
| The ETag of the item. More... | |
 Properties inherited from Google::Apis::Requests::IDirectResponseSchema | |
| string | ETag |
Detailed Description
Removes rows within this range that contain values in the specified columns that are duplicates of values in any previous row. Rows with identical values but different letter cases, formatting, or formulas are considered to be duplicates.
This request also removes duplicate rows hidden from view (for example, due to a filter). When removing duplicates, the first instance of each duplicate row scanning from the top downwards is kept in the resulting range. Content outside of the specified range isn't removed, and rows considered duplicates do not have to be adjacent to each other in the range.
Property Documentation
◆ ComparisonColumns
|
getset |
The columns in the range to analyze for duplicate values. If no columns are selected then all columns are analyzed for duplicates.
◆ ETag
|
getset |
The ETag of the item.
◆ Range
|
getset |
The range to remove duplicates rows from.
The documentation for this class was generated from the following file:
- Google.Apis.Sheets.v4.cs
