Class Hierarchy

This inheritance list is sorted roughly, but not completely, alphabetically:

[detail level 1234]

CGoogle.Apis.Sheets.v4.SpreadsheetsResource.DeveloperMetadataResource	The "developerMetadata" collection of methods.
►CGoogle::Apis::Services::IClientService [external]
►CGoogle::Apis::Services::BaseClientService [external]
CGoogle.Apis.Sheets.v4.SheetsService	The Sheets Service.
►CGoogle::Apis::Requests::IClientServiceRequest [external]
►CGoogle::Apis::Requests::IClientServiceRequest< TResponse > [external]
►CGoogle::Apis::Requests::ClientServiceRequest< TResponse > [external]
CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< TResponse >	A base abstract class for Sheets requests.
►CGoogle::Apis::Requests::IDirectResponseSchema [external]
CGoogle.Apis.Sheets.v4.Data.AddBandingRequest	Adds a new banded range to the spreadsheet.
CGoogle.Apis.Sheets.v4.Data.AddBandingResponse	The result of adding a banded range.
CGoogle.Apis.Sheets.v4.Data.AddChartRequest	Adds a chart to a sheet in the spreadsheet.
CGoogle.Apis.Sheets.v4.Data.AddChartResponse	The result of adding a chart to a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.AddConditionalFormatRuleRequest	Adds a new conditional format rule at the given index. All subsequent rules' indexes are incremented.
CGoogle.Apis.Sheets.v4.Data.AddDimensionGroupRequest	Creates a group over the specified range
CGoogle.Apis.Sheets.v4.Data.AddDimensionGroupResponse	The result of adding a group.
CGoogle.Apis.Sheets.v4.Data.AddFilterViewRequest	Adds a filter view.
CGoogle.Apis.Sheets.v4.Data.AddFilterViewResponse	The result of adding a filter view.
CGoogle.Apis.Sheets.v4.Data.AddNamedRangeRequest	Adds a named range to the spreadsheet.
CGoogle.Apis.Sheets.v4.Data.AddNamedRangeResponse	The result of adding a named range.
CGoogle.Apis.Sheets.v4.Data.AddProtectedRangeRequest	Adds a new protected range.
CGoogle.Apis.Sheets.v4.Data.AddProtectedRangeResponse	The result of adding a new protected range.
CGoogle.Apis.Sheets.v4.Data.AddSheetRequest	Adds a new sheet. When a sheet is added at a given index, all subsequent sheets' indexes are incremented. To add an object sheet, use AddChartRequest instead and specify EmbeddedObjectPosition.sheetId or EmbeddedObjectPosition.newSheet.
CGoogle.Apis.Sheets.v4.Data.AddSheetResponse	The result of adding a sheet.
CGoogle.Apis.Sheets.v4.Data.AddSlicerRequest	Adds a slicer to a sheet in the spreadsheet.
CGoogle.Apis.Sheets.v4.Data.AddSlicerResponse	The result of adding a slicer to a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.AppendCellsRequest	Adds new cells after the last row with data in a sheet, inserting new rows into the sheet if necessary.
CGoogle.Apis.Sheets.v4.Data.AppendDimensionRequest	Appends rows or columns to the end of a sheet.
CGoogle.Apis.Sheets.v4.Data.AppendValuesResponse	The response when updating a range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.AutoFillRequest	Fills in more data based on existing data.
CGoogle.Apis.Sheets.v4.Data.AutoResizeDimensionsRequest	Automatically resizes one or more dimensions based on the contents of the cells in that dimension.
CGoogle.Apis.Sheets.v4.Data.BandedRange	A banded (alternating colors) range in a sheet.
CGoogle.Apis.Sheets.v4.Data.BandingProperties	Properties referring a single dimension (either row or column). If both BandedRange.row_properties and BandedRange.column_properties are set, the fill colors are applied to cells according to the following rules:
CGoogle.Apis.Sheets.v4.Data.BaselineValueFormat	Formatting options for baseline value.
CGoogle.Apis.Sheets.v4.Data.BasicChartAxis	An axis of the chart. A chart may not have more than one axis per axis position.
CGoogle.Apis.Sheets.v4.Data.BasicChartDomain	The domain of a chart. For example, if charting stock prices over time, this would be the date.
CGoogle.Apis.Sheets.v4.Data.BasicChartSeries	A single series of data in a chart. For example, if charting stock prices over time, multiple series may exist, one for the "Open Price", "High Price", "Low Price" and "Close Price".
CGoogle.Apis.Sheets.v4.Data.BasicChartSpec	The specification for a basic chart. See BasicChartType for the list of charts this supports.
CGoogle.Apis.Sheets.v4.Data.BasicFilter	The default filter associated with a sheet.
CGoogle.Apis.Sheets.v4.Data.BatchClearValuesByDataFilterRequest	The request for clearing more than one range selected by a DataFilter in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchClearValuesByDataFilterResponse	The response when clearing a range of values selected with DataFilters in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchClearValuesRequest	The request for clearing more than one range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchClearValuesResponse	The response when clearing a range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchGetValuesByDataFilterRequest	The request for retrieving a range of values in a spreadsheet selected by a set of DataFilters.
CGoogle.Apis.Sheets.v4.Data.BatchGetValuesByDataFilterResponse	The response when retrieving more than one range of values in a spreadsheet selected by DataFilters.
CGoogle.Apis.Sheets.v4.Data.BatchGetValuesResponse	The response when retrieving more than one range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchUpdateSpreadsheetRequest	The request for updating any aspect of a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchUpdateSpreadsheetResponse	The reply for batch updating a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchUpdateValuesByDataFilterRequest	The request for updating more than one range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchUpdateValuesByDataFilterResponse	The response when updating a range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchUpdateValuesRequest	The request for updating more than one range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BatchUpdateValuesResponse	The response when updating a range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.BooleanCondition	A condition that can evaluate to true or false. BooleanConditions are used by conditional formatting, data validation, and the criteria in filters.
CGoogle.Apis.Sheets.v4.Data.BooleanRule	A rule that may or may not match, depending on the condition.
CGoogle.Apis.Sheets.v4.Data.Border	A border along a cell.
CGoogle.Apis.Sheets.v4.Data.Borders	The borders of the cell.
CGoogle.Apis.Sheets.v4.Data.BubbleChartSpec	A bubble chart.
CGoogle.Apis.Sheets.v4.Data.CandlestickChartSpec	A candlestick chart.
CGoogle.Apis.Sheets.v4.Data.CandlestickData	The Candlestick chart data, each containing the low, open, close, and high values for a series.
CGoogle.Apis.Sheets.v4.Data.CandlestickDomain	The domain of a CandlestickChart.
CGoogle.Apis.Sheets.v4.Data.CandlestickSeries	The series of a CandlestickData.
CGoogle.Apis.Sheets.v4.Data.CellData	Data about a specific cell.
CGoogle.Apis.Sheets.v4.Data.CellFormat	The format of a cell.
CGoogle.Apis.Sheets.v4.Data.ChartAxisViewWindowOptions	The options that define a "view window" for a chart (such as the visible values in an axis).
CGoogle.Apis.Sheets.v4.Data.ChartCustomNumberFormatOptions	Custom number formatting options for chart attributes.
CGoogle.Apis.Sheets.v4.Data.ChartData	The data included in a domain or series.
CGoogle.Apis.Sheets.v4.Data.ChartSourceRange	Source ranges for a chart.
CGoogle.Apis.Sheets.v4.Data.ChartSpec	The specifications of a chart.
CGoogle.Apis.Sheets.v4.Data.ClearBasicFilterRequest	Clears the basic filter, if any exists on the sheet.
CGoogle.Apis.Sheets.v4.Data.ClearValuesRequest	The request for clearing a range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.ClearValuesResponse	The response when clearing a range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.Color	Represents a color in the RGBA color space. This representation is designed for simplicity of conversion to/from color representations in various languages over compactness; for example, the fields of this representation can be trivially provided to the constructor of "java.awt.Color" in Java; it can also be trivially provided to UIColor's "+colorWithRed:green:blue:alpha" method in iOS; and, with just a little work, it can be easily formatted into a CSS "rgba()" string in JavaScript, as well
CGoogle.Apis.Sheets.v4.Data.ColorStyle	A color value.
CGoogle.Apis.Sheets.v4.Data.ConditionalFormatRule	A rule describing a conditional format.
CGoogle.Apis.Sheets.v4.Data.ConditionValue	The value of the condition.
CGoogle.Apis.Sheets.v4.Data.CopyPasteRequest	Copies data from the source to the destination.
CGoogle.Apis.Sheets.v4.Data.CopySheetToAnotherSpreadsheetRequest	The request to copy a sheet across spreadsheets.
CGoogle.Apis.Sheets.v4.Data.CreateDeveloperMetadataRequest	A request to create developer metadata.
CGoogle.Apis.Sheets.v4.Data.CreateDeveloperMetadataResponse	The response from creating developer metadata.
CGoogle.Apis.Sheets.v4.Data.CutPasteRequest	Moves data from the source to the destination.
CGoogle.Apis.Sheets.v4.Data.DataFilter	Filter that describes what data should be selected or returned from a request.
CGoogle.Apis.Sheets.v4.Data.DataFilterValueRange	A range of values whose location is specified by a DataFilter.
CGoogle.Apis.Sheets.v4.Data.DataValidationRule	A data validation rule.
CGoogle.Apis.Sheets.v4.Data.DateTimeRule	Allows you to organize the date-time values in a source data column into buckets based on selected parts of their date or time values. For example, consider a pivot table showing sales transactions by date:
CGoogle.Apis.Sheets.v4.Data.DeleteBandingRequest	Removes the banded range with the given ID from the spreadsheet.
CGoogle.Apis.Sheets.v4.Data.DeleteConditionalFormatRuleRequest	Deletes a conditional format rule at the given index. All subsequent rules' indexes are decremented.
CGoogle.Apis.Sheets.v4.Data.DeleteConditionalFormatRuleResponse	The result of deleting a conditional format rule.
CGoogle.Apis.Sheets.v4.Data.DeleteDeveloperMetadataRequest	A request to delete developer metadata.
CGoogle.Apis.Sheets.v4.Data.DeleteDeveloperMetadataResponse	The response from deleting developer metadata.
CGoogle.Apis.Sheets.v4.Data.DeleteDimensionGroupRequest	Deletes a group over the specified range by decrementing the depth of the dimensions in the range
CGoogle.Apis.Sheets.v4.Data.DeleteDimensionGroupResponse	The result of deleting a group.
CGoogle.Apis.Sheets.v4.Data.DeleteDimensionRequest	Deletes the dimensions from the sheet.
CGoogle.Apis.Sheets.v4.Data.DeleteDuplicatesRequest	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
CGoogle.Apis.Sheets.v4.Data.DeleteDuplicatesResponse	The result of removing duplicates in a range.
CGoogle.Apis.Sheets.v4.Data.DeleteEmbeddedObjectRequest	Deletes the embedded object with the given ID.
CGoogle.Apis.Sheets.v4.Data.DeleteFilterViewRequest	Deletes a particular filter view.
CGoogle.Apis.Sheets.v4.Data.DeleteNamedRangeRequest	Removes the named range with the given ID from the spreadsheet.
CGoogle.Apis.Sheets.v4.Data.DeleteProtectedRangeRequest	Deletes the protected range with the given ID.
CGoogle.Apis.Sheets.v4.Data.DeleteRangeRequest	Deletes a range of cells, shifting other cells into the deleted area.
CGoogle.Apis.Sheets.v4.Data.DeleteSheetRequest	Deletes the requested sheet.
CGoogle.Apis.Sheets.v4.Data.DeveloperMetadata	Developer metadata associated with a location or object in a spreadsheet. Developer metadata may be used to associate arbitrary data with various parts of a spreadsheet and will remain associated at those locations as they move around and the spreadsheet is edited. For example, if developer metadata is associated with row 5 and another row is then subsequently inserted above row 5, that original metadata will still be associated with the row it was first associated with (what is now row 6). If the associated object is deleted its metadata is deleted too.
CGoogle.Apis.Sheets.v4.Data.DeveloperMetadataLocation	A location where metadata may be associated in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.DeveloperMetadataLookup	Selects DeveloperMetadata that matches all of the specified fields. For example, if only a metadata ID is specified this considers the DeveloperMetadata with that particular unique ID. If a metadata key is specified, this considers all developer metadata with that key. If a key, visibility, and location type are all specified, this considers all developer metadata with that key and visibility that are associated with a location of that type. In general, this selects all DeveloperMetadata that matches the intersection of all the specified fields; any field or combination of fields may be specified.
CGoogle.Apis.Sheets.v4.Data.DimensionGroup	A group over an interval of rows or columns on a sheet, which can contain or be contained within other groups. A group can be collapsed or expanded as a unit on the sheet.
CGoogle.Apis.Sheets.v4.Data.DimensionProperties	Properties about a dimension.
CGoogle.Apis.Sheets.v4.Data.DimensionRange	A range along a single dimension on a sheet. All indexes are zero-based. Indexes are half open: the start index is inclusive and the end index is exclusive. Missing indexes indicate the range is unbounded on that side.
CGoogle.Apis.Sheets.v4.Data.DuplicateFilterViewRequest	Duplicates a particular filter view.
CGoogle.Apis.Sheets.v4.Data.DuplicateFilterViewResponse	The result of a filter view being duplicated.
CGoogle.Apis.Sheets.v4.Data.DuplicateSheetRequest	Duplicates the contents of a sheet.
CGoogle.Apis.Sheets.v4.Data.DuplicateSheetResponse	The result of duplicating a sheet.
CGoogle.Apis.Sheets.v4.Data.Editors	The editors of a protected range.
CGoogle.Apis.Sheets.v4.Data.EmbeddedChart	A chart embedded in a sheet.
CGoogle.Apis.Sheets.v4.Data.EmbeddedObjectPosition	The position of an embedded object such as a chart.
CGoogle.Apis.Sheets.v4.Data.ErrorValue	An error in a cell.
CGoogle.Apis.Sheets.v4.Data.ExtendedValue	The kinds of value that a cell in a spreadsheet can have.
CGoogle.Apis.Sheets.v4.Data.FilterCriteria	Criteria for showing/hiding rows in a filter or filter view.
CGoogle.Apis.Sheets.v4.Data.FilterView	A filter view.
CGoogle.Apis.Sheets.v4.Data.FindReplaceRequest	Finds and replaces data in cells over a range, sheet, or all sheets.
CGoogle.Apis.Sheets.v4.Data.FindReplaceResponse	The result of the find/replace.
CGoogle.Apis.Sheets.v4.Data.GetSpreadsheetByDataFilterRequest	The request for retrieving a Spreadsheet.
CGoogle.Apis.Sheets.v4.Data.GradientRule	A rule that applies a gradient color scale format, based on the interpolation points listed. The format of a cell will vary based on its contents as compared to the values of the interpolation points.
CGoogle.Apis.Sheets.v4.Data.GridCoordinate	A coordinate in a sheet. All indexes are zero-based.
CGoogle.Apis.Sheets.v4.Data.GridData	Data in the grid, as well as metadata about the dimensions.
CGoogle.Apis.Sheets.v4.Data.GridProperties	Properties of a grid.
CGoogle.Apis.Sheets.v4.Data.GridRange	A range on a sheet. All indexes are zero-based. Indexes are half open, e.g the start index is inclusive and the end index is exclusive – [start_index, end_index). Missing indexes indicate the range is unbounded on that side
CGoogle.Apis.Sheets.v4.Data.HistogramChartSpec	A histogram chart. A histogram chart groups data items into bins, displaying each bin as a column of stacked items. Histograms are used to display the distribution of a dataset. Each column of items represents a range into which those items fall. The number of bins can be chosen automatically or specified explicitly.
CGoogle.Apis.Sheets.v4.Data.HistogramRule	Allows you to organize the numeric values in a source data column into buckets of a constant size. All values from HistogramRule.start to HistogramRule.end are placed into groups of size HistogramRule.interval. In addition, all values below HistogramRule.start are placed in one group, and all values above HistogramRule.end are placed in another. Only HistogramRule.interval is required, though if HistogramRule.start and HistogramRule.end are both provided, HistogramRule.start must be less than HistogramRule.end. For example, a pivot table showing average purchase amount by age that has 50+ rows:
CGoogle.Apis.Sheets.v4.Data.HistogramSeries	A histogram series containing the series color and data.
CGoogle.Apis.Sheets.v4.Data.InsertDimensionRequest	Inserts rows or columns in a sheet at a particular index.
CGoogle.Apis.Sheets.v4.Data.InsertRangeRequest	Inserts cells into a range, shifting the existing cells over or down.
CGoogle.Apis.Sheets.v4.Data.InterpolationPoint	A single interpolation point on a gradient conditional format. These pin the gradient color scale according to the color, type and value chosen.
CGoogle.Apis.Sheets.v4.Data.IterativeCalculationSettings	Settings to control how circular dependencies are resolved with iterative calculation.
CGoogle.Apis.Sheets.v4.Data.KeyValueFormat	Formatting options for key value.
CGoogle.Apis.Sheets.v4.Data.LineStyle	Properties that describe the style of a line.
CGoogle.Apis.Sheets.v4.Data.ManualRule	Allows you to manually organize the values in a source data column into buckets with names of your choosing. For example, a pivot table that aggregates population by state:
CGoogle.Apis.Sheets.v4.Data.ManualRuleGroup	A group name and a list of items from the source data that should be placed in the group with this name.
CGoogle.Apis.Sheets.v4.Data.MatchedDeveloperMetadata	A developer metadata entry and the data filters specified in the original request that matched it.
CGoogle.Apis.Sheets.v4.Data.MatchedValueRange	A value range that was matched by one or more data filers.
CGoogle.Apis.Sheets.v4.Data.MergeCellsRequest	Merges all cells in the range.
CGoogle.Apis.Sheets.v4.Data.MoveDimensionRequest	Moves one or more rows or columns.
CGoogle.Apis.Sheets.v4.Data.NamedRange	A named range.
CGoogle.Apis.Sheets.v4.Data.NumberFormat	The number format of a cell.
CGoogle.Apis.Sheets.v4.Data.OrgChartSpec	An org chart. Org charts require a unique set of labels in labels and may optionally include parent_labels and tooltips. parent_labels contain, for each node, the label identifying the parent node. tooltips contain, for each node, an optional tooltip
CGoogle.Apis.Sheets.v4.Data.OverlayPosition	The location an object is overlaid on top of a grid.
CGoogle.Apis.Sheets.v4.Data.Padding	The amount of padding around the cell, in pixels. When updating padding, every field must be specified.
CGoogle.Apis.Sheets.v4.Data.PasteDataRequest	Inserts data into the spreadsheet starting at the specified coordinate.
CGoogle.Apis.Sheets.v4.Data.PieChartSpec	A pie chart.
CGoogle.Apis.Sheets.v4.Data.PivotFilterCriteria	Criteria for showing/hiding rows in a pivot table.
CGoogle.Apis.Sheets.v4.Data.PivotGroup	A single grouping (either row or column) in a pivot table.
CGoogle.Apis.Sheets.v4.Data.PivotGroupRule	An optional setting on a PivotGroup that defines buckets for the values in the source data column rather than breaking out each individual value. Only one PivotGroup with a group rule may be added for each column in the source data, though on any given column you may add both a PivotGroup that has a rule and a PivotGroup that does not.
CGoogle.Apis.Sheets.v4.Data.PivotGroupSortValueBucket	Information about which values in a pivot group should be used for sorting.
CGoogle.Apis.Sheets.v4.Data.PivotGroupValueMetadata	Metadata about a value in a pivot grouping.
CGoogle.Apis.Sheets.v4.Data.PivotTable	A pivot table.
CGoogle.Apis.Sheets.v4.Data.PivotValue	The definition of how a value in a pivot table should be calculated.
CGoogle.Apis.Sheets.v4.Data.ProtectedRange	A protected range.
CGoogle.Apis.Sheets.v4.Data.RandomizeRangeRequest	Randomizes the order of the rows in a range.
CGoogle.Apis.Sheets.v4.Data.RepeatCellRequest	Updates all cells in the range to the values in the given Cell object. Only the fields listed in the fields field are updated; others are unchanged
CGoogle.Apis.Sheets.v4.Data.Request	A single kind of update to apply to a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.Response	A single response from an update.
CGoogle.Apis.Sheets.v4.Data.RowData	Data about each cell in a row.
CGoogle.Apis.Sheets.v4.Data.ScorecardChartSpec	A scorecard chart. Scorecard charts are used to highlight key performance indicators, known as KPIs, on the spreadsheet. A scorecard chart can represent things like total sales, average cost, or a top selling item. You can specify a single data value, or aggregate over a range of data. Percentage or absolute difference from a baseline value can be highlighted, like changes over time.
CGoogle.Apis.Sheets.v4.Data.SearchDeveloperMetadataRequest	A request to retrieve all developer metadata matching the set of specified criteria.
CGoogle.Apis.Sheets.v4.Data.SearchDeveloperMetadataResponse	A reply to a developer metadata search request.
CGoogle.Apis.Sheets.v4.Data.SetBasicFilterRequest	Sets the basic filter associated with a sheet.
CGoogle.Apis.Sheets.v4.Data.SetDataValidationRequest	Sets a data validation rule to every cell in the range. To clear validation in a range, call this with no rule specified.
CGoogle.Apis.Sheets.v4.Data.Sheet	A sheet in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.SheetProperties	Properties of a sheet.
CGoogle.Apis.Sheets.v4.Data.Slicer	A slicer in a sheet.
CGoogle.Apis.Sheets.v4.Data.SlicerSpec	The specifications of a slicer.
CGoogle.Apis.Sheets.v4.Data.SortRangeRequest	Sorts data in rows based on a sort order per column.
CGoogle.Apis.Sheets.v4.Data.SortSpec	A sort order associated with a specific column or row.
CGoogle.Apis.Sheets.v4.Data.SourceAndDestination	A combination of a source range and how to extend that source.
CGoogle.Apis.Sheets.v4.Data.Spreadsheet	Resource that represents a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.SpreadsheetProperties	Properties of a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.SpreadsheetTheme	Represents spreadsheet theme
CGoogle.Apis.Sheets.v4.Data.TextFormat	The format of a run of text in a cell. Absent values indicate that the field isn't specified.
CGoogle.Apis.Sheets.v4.Data.TextFormatRun	A run of a text format. The format of this run continues until the start index of the next run. When updating, all fields must be set.
CGoogle.Apis.Sheets.v4.Data.TextPosition	Position settings for text.
CGoogle.Apis.Sheets.v4.Data.TextRotation	The rotation applied to text in a cell.
CGoogle.Apis.Sheets.v4.Data.TextToColumnsRequest	Splits a column of text into multiple columns, based on a delimiter in each cell.
CGoogle.Apis.Sheets.v4.Data.ThemeColorPair	A pair mapping a spreadsheet theme color type to the concrete color it represents.
CGoogle.Apis.Sheets.v4.Data.TreemapChartColorScale	A color scale for a treemap chart.
CGoogle.Apis.Sheets.v4.Data.TreemapChartSpec	A Treemap chart.
CGoogle.Apis.Sheets.v4.Data.TrimWhitespaceRequest	Trims the whitespace (such as spaces, tabs, or new lines) in every cell in the specified range. This request removes all whitespace from the start and end of each cell's text, and reduces any subsequence of remaining whitespace characters to a single space. If the resulting trimmed text starts with a '+' or '=' character, the text remains as a string value and isn't interpreted as a formula.
CGoogle.Apis.Sheets.v4.Data.TrimWhitespaceResponse	The result of trimming whitespace in cells.
CGoogle.Apis.Sheets.v4.Data.UnmergeCellsRequest	Unmerges cells in the given range.
CGoogle.Apis.Sheets.v4.Data.UpdateBandingRequest	Updates properties of the supplied banded range.
CGoogle.Apis.Sheets.v4.Data.UpdateBordersRequest	Updates the borders of a range. If a field is not set in the request, that means the border remains as- is. For example, with two subsequent UpdateBordersRequest:
CGoogle.Apis.Sheets.v4.Data.UpdateCellsRequest	Updates all cells in a range with new data.
CGoogle.Apis.Sheets.v4.Data.UpdateChartSpecRequest	Updates a chart's specifications. (This does not move or resize a chart. To move or resize a chart, use UpdateEmbeddedObjectPositionRequest.)
CGoogle.Apis.Sheets.v4.Data.UpdateConditionalFormatRuleRequest	Updates a conditional format rule at the given index, or moves a conditional format rule to another index.
CGoogle.Apis.Sheets.v4.Data.UpdateConditionalFormatRuleResponse	The result of updating a conditional format rule.
CGoogle.Apis.Sheets.v4.Data.UpdateDeveloperMetadataRequest	A request to update properties of developer metadata. Updates the properties of the developer metadata selected by the filters to the values provided in the DeveloperMetadata resource. Callers must specify the properties they wish to update in the fields parameter, as well as specify at least one DataFilter matching the metadata they wish to update.
CGoogle.Apis.Sheets.v4.Data.UpdateDeveloperMetadataResponse	The response from updating developer metadata.
CGoogle.Apis.Sheets.v4.Data.UpdateDimensionGroupRequest	Updates the state of the specified group.
CGoogle.Apis.Sheets.v4.Data.UpdateDimensionPropertiesRequest	Updates properties of dimensions within the specified range.
CGoogle.Apis.Sheets.v4.Data.UpdateEmbeddedObjectPositionRequest	Update an embedded object's position (such as a moving or resizing a chart or image).
CGoogle.Apis.Sheets.v4.Data.UpdateEmbeddedObjectPositionResponse	The result of updating an embedded object's position.
CGoogle.Apis.Sheets.v4.Data.UpdateFilterViewRequest	Updates properties of the filter view.
CGoogle.Apis.Sheets.v4.Data.UpdateNamedRangeRequest	Updates properties of the named range with the specified namedRangeId.
CGoogle.Apis.Sheets.v4.Data.UpdateProtectedRangeRequest	Updates an existing protected range with the specified protectedRangeId.
CGoogle.Apis.Sheets.v4.Data.UpdateSheetPropertiesRequest	Updates properties of the sheet with the specified sheetId.
CGoogle.Apis.Sheets.v4.Data.UpdateSlicerSpecRequest	Updates a slicer's specifications. (This does not move or resize a slicer. To move or resize a slicer use UpdateEmbeddedObjectPositionRequest.
CGoogle.Apis.Sheets.v4.Data.UpdateSpreadsheetPropertiesRequest	Updates properties of a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.UpdateValuesByDataFilterResponse	The response when updating a range of values by a data filter in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.UpdateValuesResponse	The response when updating a range of values in a spreadsheet.
CGoogle.Apis.Sheets.v4.Data.ValueRange	Data within a range of the spreadsheet.
CGoogle.Apis.Sheets.v4.Data.WaterfallChartColumnStyle	Styles for a waterfall chart column.
CGoogle.Apis.Sheets.v4.Data.WaterfallChartCustomSubtotal	A custom subtotal column for a waterfall chart series.
CGoogle.Apis.Sheets.v4.Data.WaterfallChartDomain	The domain of a waterfall chart.
CGoogle.Apis.Sheets.v4.Data.WaterfallChartSeries	A single series of data for a waterfall chart.
CGoogle.Apis.Sheets.v4.Data.WaterfallChartSpec	A waterfall chart.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.AppendValuesResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.AppendRequest	Appends values to a spreadsheet. The input range is used to search for existing data and find a "table" within that range. Values will be appended to the next row of the table, starting with the first column of the table. See the guide and sample code for specific details of how tables are detected and data is appended
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.BatchClearValuesByDataFilterResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.BatchClearByDataFilterRequest	Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters will be cleared. Only values are cleared – all other properties of the cell (such as formatting, data validation, etc..) are kept.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.BatchClearValuesResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.BatchClearRequest	Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges. Only values are cleared – all other properties of the cell (such as formatting, data validation, etc..) are kept.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.BatchGetValuesByDataFilterResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.BatchGetByDataFilterRequest	Returns one or more ranges of values that match the specified data filters. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges that match any of the data filters in the request will be returned.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.BatchGetValuesResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.BatchGetRequest	Returns one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.BatchUpdateSpreadsheetResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.BatchUpdateRequest	Applies one or more updates to the spreadsheet
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.BatchUpdateValuesByDataFilterResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.BatchUpdateByDataFilterRequest	Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOption, and one or more DataFilterValueRanges.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.BatchUpdateValuesResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.BatchUpdateRequest	Sets values in one or more ranges of a spreadsheet. The caller must specify the spreadsheet ID, a valueInputOption, and one or more ValueRanges.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.ClearValuesResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.ClearRequest	Clears values from a spreadsheet. The caller must specify the spreadsheet ID and range. Only values are cleared – all other properties of the cell (such as formatting, data validation, etc..) are kept.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.DeveloperMetadata >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.DeveloperMetadataResource.GetRequest	Returns the developer metadata with the specified ID. The caller must specify the spreadsheet ID and the developer metadata's unique metadataId.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.SearchDeveloperMetadataResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.DeveloperMetadataResource.SearchRequest	Returns all developer metadata matching the specified DataFilter. If the provided DataFilter represents a DeveloperMetadataLookup object, this will return all DeveloperMetadata entries selected by it. If the DataFilter represents a location in a spreadsheet, this will return all developer metadata associated with locations intersecting that region.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.SheetProperties >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.SheetsResource.CopyToRequest	Copies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.Spreadsheet >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.CreateRequest	Creates a spreadsheet, returning the newly created spreadsheet.
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.GetByDataFilterRequest	Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.GetRequest	Returns the spreadsheet at the given ID. The caller must specify the spreadsheet ID
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.UpdateValuesResponse >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.UpdateRequest	Sets values in a range of a spreadsheet. The caller must specify the spreadsheet ID, range, and a valueInputOption.
►CGoogle.Apis.Sheets.v4.SheetsBaseServiceRequest< Google.Apis.Sheets.v4.Data.ValueRange >
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource.GetRequest	Returns a range of values from a spreadsheet. The caller must specify the spreadsheet ID and a range.
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.SheetsResource	The "sheets" collection of methods.
CGoogle.Apis.Sheets.v4.SpreadsheetsResource	The "spreadsheets" collection of methods.
CGoogle.Apis.Sheets.v4.SpreadsheetsResource.ValuesResource	The "values" collection of methods.