- get(String, Integer) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata
-
Returns the developer metadata with the specified ID.
- Get(String, Integer) - Constructor for class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
Returns the developer metadata with the specified ID.
- get(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets
-
Returns the spreadsheet at the given ID.
- Get(String) - Constructor for class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
Returns the spreadsheet at the given ID.
- get(String, String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values
-
Returns a range of values from a spreadsheet.
- Get(String, String) - Constructor for class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
Returns a range of values from a spreadsheet.
- get$Xgafv() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
V1 error format.
- getA1Range() - Method in class com.google.api.services.sheets.v4.model.DataFilter
-
Selects data that matches the specified A1 range.
- getAbstractGoogleClient() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
- getAccessToken() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
OAuth access token.
- getAddBanding() - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a new banded range
- getAddBanding() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a banded range.
- getAddChart() - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a chart.
- getAddChart() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a chart.
- getAddConditionalFormatRule() - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a new conditional format rule.
- getAddDimensionGroup() - Method in class com.google.api.services.sheets.v4.model.Request
-
Creates a group over the specified range.
- getAddDimensionGroup() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a dimension group.
- getAddFilterView() - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a filter view.
- getAddFilterView() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a filter view.
- getAddNamedRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a named range.
- getAddNamedRange() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a named range.
- getAddProtectedRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a protected range.
- getAddProtectedRange() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a protected range.
- getAddSheet() - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a sheet.
- getAddSheet() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a sheet.
- getAddSlicer() - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a slicer.
- getAddSlicer() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a slicer.
- getAggregateType() - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
The aggregation type for key and baseline chart data in scorecard chart.
- getAllSheets() - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True to find/replace over all sheets.
- getAlpha() - Method in class com.google.api.services.sheets.v4.model.Color
-
The fraction of this color that should be applied to the pixel.
- getAlt() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Data format for response.
- getAltText() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The alternative text that describes the chart.
- getAnchorCell() - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The cell the object is anchored to.
- getAngle() - Method in class com.google.api.services.sheets.v4.model.TextRotation
-
The angle between the standard orientation and the desired orientation.
- getAppendCells() - Method in class com.google.api.services.sheets.v4.model.Request
-
Appends cells after the last row with data in a sheet.
- getAppendDimension() - Method in class com.google.api.services.sheets.v4.model.Request
-
Appends dimensions to the end of a sheet.
- getApplyToPivotTables() - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
True if the filter should apply to pivot tables.
- getAutoFill() - Method in class com.google.api.services.sheets.v4.model.Request
-
Automatically fills in more data based on existing data.
- getAutoRecalc() - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The amount of time to wait before volatile functions are recalculated.
- getAutoResizeDimensions() - Method in class com.google.api.services.sheets.v4.model.Request
-
Automatically resizes one or more dimensions based on the contents of the cells in that
dimension.
- getAxis() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The axis on the chart.
- getBackgroundColor() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The background color of the cell.
- getBackgroundColor() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The background color of the entire chart.
- getBackgroundColor() - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The background color of the slicer.
- getBackgroundColor() - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The background fill color to sort by; cells with this fill color are sorted to the top.
- getBackgroundColorStyle() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The background color of the cell.
- getBackgroundColorStyle() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The background color of the entire chart.
- getBackgroundColorStyle() - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The background color of the slicer.
- getBackgroundColorStyle() - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The background fill color to sort by; cells with this fill color are sorted to the top.
- getBandedRange() - Method in class com.google.api.services.sheets.v4.model.AddBandingRequest
-
The banded range to add.
- getBandedRange() - Method in class com.google.api.services.sheets.v4.model.AddBandingResponse
-
The banded range that was added.
- getBandedRange() - Method in class com.google.api.services.sheets.v4.model.UpdateBandingRequest
-
The banded range to update with the new properties.
- getBandedRangeId() - Method in class com.google.api.services.sheets.v4.model.BandedRange
-
The id of the banded range.
- getBandedRangeId() - Method in class com.google.api.services.sheets.v4.model.DeleteBandingRequest
-
The ID of the banded range to delete.
- getBandedRanges() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The banded (alternating colors) ranges on this sheet.
- getBarColor() - Method in class com.google.api.services.sheets.v4.model.HistogramSeries
-
The color of the column representing this series in each bucket.
- getBarColorStyle() - Method in class com.google.api.services.sheets.v4.model.HistogramSeries
-
The color of the column representing this series in each bucket.
- getBaselineValueData() - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
The data for scorecard baseline value.
- getBaselineValueFormat() - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
Formatting options for baseline value.
- getBasicChart() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A basic chart specification, can be one of many kinds of charts.
- getBasicFilter() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The filter on this sheet, if any.
- getBlue() - Method in class com.google.api.services.sheets.v4.model.Color
-
The amount of blue in the color as a value in the interval [0, 1].
- getBold() - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
True if the text is bold.
- getBooleanRule() - Method in class com.google.api.services.sheets.v4.model.ConditionalFormatRule
-
The formatting is either "on" or "off" according to the rule.
- getBoolValue() - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents a boolean value.
- getBorders() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The borders of the cell.
- getBottom() - Method in class com.google.api.services.sheets.v4.model.Borders
-
The bottom border of the cell.
- getBottom() - Method in class com.google.api.services.sheets.v4.model.Padding
-
The bottom padding of the cell.
- getBottom() - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The border to put at the bottom of the range.
- getBubbleBorderColor() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The bubble border color.
- getBubbleBorderColorStyle() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The bubble border color.
- getBubbleChart() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A bubble chart specification.
- getBubbleLabels() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data containing the bubble labels.
- getBubbleMaxRadiusSize() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The max radius size of the bubbles, in pixels.
- getBubbleMinRadiusSize() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The minimum radius size of the bubbles, in pixels.
- getBubbleOpacity() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The opacity of the bubbles between 0 and 1.0.
- getBubbleSizes() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data contianing the bubble sizes.
- getBubbleTextStyle() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The format of the text inside the bubbles.
- getBuckets() - Method in class com.google.api.services.sheets.v4.model.PivotGroupSortValueBucket
-
Determines the bucket from which values are chosen to sort.
- getBucketSize() - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
By default the bucket size (the range of values stacked in a single column) is chosen
automatically, but it may be overridden here.
- getByDataFilter(String, GetSpreadsheetByDataFilterRequest) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets
-
Returns the spreadsheet at the given ID.
- GetByDataFilter(String, GetSpreadsheetByDataFilterRequest) - Constructor for class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
Returns the spreadsheet at the given ID.
- getCalculatedDisplayType() - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
If specified, indicates that pivot values should be displayed as the result of a calculation
with another pivot value.
- getCallback() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
JSONP
- getCandlestickChart() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A candlestick chart specification.
- getCell() - Method in class com.google.api.services.sheets.v4.model.RepeatCellRequest
-
The data to write.
- getCellsChangedCount() - Method in class com.google.api.services.sheets.v4.model.TrimWhitespaceResponse
-
The number of cells that were trimmed of whitespace.
- getChart() - Method in class com.google.api.services.sheets.v4.model.AddChartRequest
-
The chart that should be added to the spreadsheet, including the position where it should be
placed.
- getChart() - Method in class com.google.api.services.sheets.v4.model.AddChartResponse
-
The newly added chart.
- getChartId() - Method in class com.google.api.services.sheets.v4.model.EmbeddedChart
-
The ID of the chart.
- getChartId() - Method in class com.google.api.services.sheets.v4.model.UpdateChartSpecRequest
-
The ID of the chart to update.
- getCharts() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The specifications of every chart on this sheet.
- getChartType() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The type of the chart.
- getClearBasicFilter() - Method in class com.google.api.services.sheets.v4.model.Request
-
Clears the basic filter on a sheet.
- getClearedRange() - Method in class com.google.api.services.sheets.v4.model.ClearValuesResponse
-
The range (in A1 notation) that was cleared.
- getClearedRanges() - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterResponse
-
The ranges that were cleared, in A1 notation.
- getClearedRanges() - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesResponse
-
The ranges that were cleared, in A1 notation.
- getCloseSeries() - Method in class com.google.api.services.sheets.v4.model.CandlestickData
-
The range data (vertical axis) for the close/final value for each candle.
- getCollapsed() - Method in class com.google.api.services.sheets.v4.model.DimensionGroup
-
This field is true if this group is collapsed.
- getCollapsed() - Method in class com.google.api.services.sheets.v4.model.PivotGroupValueMetadata
-
True if the data corresponding to the value is collapsed.
- getColor() - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The color for elements (such as bars, lines, and points) associated with this series.
- getColor() - Method in class com.google.api.services.sheets.v4.model.Border
-
The color of the border.
- getColor() - Method in class com.google.api.services.sheets.v4.model.InterpolationPoint
-
The color this interpolation point should use.
- getColor() - Method in class com.google.api.services.sheets.v4.model.ThemeColorPair
-
The concrete color corresponding to the theme color type.
- getColor() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartColumnStyle
-
The color of the column.
- getColorData() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The data that determines the background color of each treemap data cell.
- getColorScale() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The color scale for data cells in the treemap chart.
- getColorStyle() - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The color for elements (such as bars, lines, and points) associated with this series.
- getColorStyle() - Method in class com.google.api.services.sheets.v4.model.Border
-
The color of the border.
- getColorStyle() - Method in class com.google.api.services.sheets.v4.model.InterpolationPoint
-
The color this interpolation point should use.
- getColorStyle() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartColumnStyle
-
The color of the column.
- getColorType() - Method in class com.google.api.services.sheets.v4.model.ThemeColorPair
-
The type of the spreadsheet theme color.
- getColumnCount() - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
The number of columns in the grid.
- getColumnGroupControlAfter() - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
True if the column grouping control toggle is shown after the group.
- getColumnGroups() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
All column groups on this sheet, ordered by increasing range start index, then by group depth.
- getColumnIndex() - Method in class com.google.api.services.sheets.v4.model.GridCoordinate
-
The column index of the coordinate.
- getColumnIndex() - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The column index in the data table on which the filter is applied to.
- getColumnMetadata() - Method in class com.google.api.services.sheets.v4.model.GridData
-
Metadata about the requested columns in the grid, starting with the column in start_column.
- getColumnProperties() - Method in class com.google.api.services.sheets.v4.model.BandedRange
-
Properties for column bands.
- getColumns() - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
Each column grouping in the pivot table.
- getCompareMode() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The behavior of tooltips and data highlighting when hovering on data and chart area.
- getComparisonColumns() - Method in class com.google.api.services.sheets.v4.model.DeleteDuplicatesRequest
-
The columns in the range to analyze for duplicate values.
- getComparisonType() - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
The comparison type of key value with baseline value.
- getCondition() - Method in class com.google.api.services.sheets.v4.model.BooleanRule
-
The condition of the rule.
- getCondition() - Method in class com.google.api.services.sheets.v4.model.DataValidationRule
-
The condition that data in the cell must match.
- getCondition() - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
A condition that must be true for values to be shown.
- getConditionalFormats() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The conditional format rules in this sheet.
- getConnectorLineStyle() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
The line style for the connector lines.
- getConvergenceThreshold() - Method in class com.google.api.services.sheets.v4.model.IterativeCalculationSettings
-
When iterative calculation is enabled and successive results differ by less than this threshold
value, the calculation rounds stop.
- getCoordinate() - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
The coordinate at which the data should start being inserted.
- getCopyPaste() - Method in class com.google.api.services.sheets.v4.model.Request
-
Copies data from one area and pastes it to another.
- getCreateDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.Request
-
Creates new developer metadata
- getCreateDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from creating a developer metadata entry.
- getCriteria() - Method in class com.google.api.services.sheets.v4.model.BasicFilter
-
The criteria for showing/hiding values per column.
- getCriteria() - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The criteria for showing/hiding values per column.
- getCriteria() - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
An optional mapping of filters per source column offset.
- getCustomFormatOptions() - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
Custom formatting options for numeric key/baseline values in scorecard chart.
- getCustomSubtotals() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
Custom subtotal columns appearing in this series.
- getCutPaste() - Method in class com.google.api.services.sheets.v4.model.Request
-
Cuts data from one area and pastes it to another.
- getData() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
The new values to apply to the spreadsheet.
- getData() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
The new values to apply to the spreadsheet.
- getData() - Method in class com.google.api.services.sheets.v4.model.CandlestickChartSpec
-
The Candlestick chart data.
- getData() - Method in class com.google.api.services.sheets.v4.model.CandlestickDomain
-
The data of the CandlestickDomain.
- getData() - Method in class com.google.api.services.sheets.v4.model.CandlestickSeries
-
The data of the CandlestickSeries.
- getData() - Method in class com.google.api.services.sheets.v4.model.HistogramSeries
-
The data for this histogram series.
- getData() - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
The data to insert.
- getData() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
Data in the grid, if this is a grid sheet.
- getData() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartDomain
-
The data of the WaterfallChartDomain.
- getData() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
The data being visualized in this series.
- getDataFilter() - Method in class com.google.api.services.sheets.v4.model.DataFilterValueRange
-
The data filter describing the location of the values in the spreadsheet.
- getDataFilter() - Method in class com.google.api.services.sheets.v4.model.DeleteDeveloperMetadataRequest
-
The data filter describing the criteria used to select which developer metadata entry to
delete.
- getDataFilter() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The data filter that selected the range that was updated.
- getDataFilters() - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterRequest
-
The DataFilters used to determine which ranges to clear.
- getDataFilters() - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest
-
The data filters used to match the ranges of values to retrieve.
- getDataFilters() - Method in class com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest
-
The DataFilters used to select which ranges to retrieve from the spreadsheet.
- getDataFilters() - Method in class com.google.api.services.sheets.v4.model.MatchedDeveloperMetadata
-
All filters matching the returned developer metadata.
- getDataFilters() - Method in class com.google.api.services.sheets.v4.model.MatchedValueRange
-
The DataFilters from the request that matched the range of values.
- getDataFilters() - Method in class com.google.api.services.sheets.v4.model.SearchDeveloperMetadataRequest
-
The data filters describing the criteria used to determine which DeveloperMetadata entries to
return.
- getDataFilters() - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataRequest
-
The filters matching the developer metadata entries to update.
- getDataIsSubtotal() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartCustomSubtotal
-
True if the data point at subtotal_index is the subtotal.
- getDataRange() - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The data range of the slicer.
- getDataValidation() - Method in class com.google.api.services.sheets.v4.model.CellData
-
A data validation rule on the cell, if any.
- getDateTimeRenderOption() - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest
-
How dates, times, and durations should be represented in the output.
- getDateTimeRenderOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
How dates, times, and durations should be represented in the output.
- getDateTimeRenderOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
How dates, times, and durations should be represented in the output.
- getDateTimeRule() - Method in class com.google.api.services.sheets.v4.model.PivotGroupRule
-
A DateTimeRule.
- getDefaultFormat() - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The default format of all cells in the spreadsheet.
- getDeleteBanding() - Method in class com.google.api.services.sheets.v4.model.Request
-
Removes a banded range
- getDeleteConditionalFormatRule() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes an existing conditional format rule.
- getDeleteConditionalFormatRule() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from deleting a conditional format rule.
- getDeletedDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.DeleteDeveloperMetadataResponse
-
The metadata that was deleted.
- getDeleteDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes developer metadata
- getDeleteDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from deleting a developer metadata entry.
- getDeleteDimension() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes rows or columns in a sheet.
- getDeleteDimensionGroup() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a group over the specified range.
- getDeleteDimensionGroup() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from deleting a dimension group.
- getDeleteDuplicates() - Method in class com.google.api.services.sheets.v4.model.Request
-
Removes rows containing duplicate values in specified columns of a cell range.
- getDeleteDuplicates() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from removing rows containing duplicate values.
- getDeleteEmbeddedObject() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes an embedded object (e.g, chart, image) in a sheet.
- getDeleteFilterView() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a filter view from a sheet.
- getDeleteNamedRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a named range.
- getDeleteProtectedRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a protected range.
- getDeleteRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a range of cells from a sheet, shifting the remaining cells.
- getDeleteSheet() - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a sheet.
- getDelimiter() - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
The delimiter in the data.
- getDelimiter() - Method in class com.google.api.services.sheets.v4.model.TextToColumnsRequest
-
The delimiter to use.
- getDelimiterType() - Method in class com.google.api.services.sheets.v4.model.TextToColumnsRequest
-
The delimiter type to use.
- getDepth() - Method in class com.google.api.services.sheets.v4.model.DimensionGroup
-
The depth of the group, representing how many groups have a range that wholly contains the
range of this group.
- getDescription() - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Description which is appended after the baseline value.
- getDescription() - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The description of this protected range.
- getDestination() - Method in class com.google.api.services.sheets.v4.model.CopyPasteRequest
-
The location to paste to.
- getDestination() - Method in class com.google.api.services.sheets.v4.model.CutPasteRequest
-
The top-left coordinate where the data should be pasted.
- getDestinationIndex() - Method in class com.google.api.services.sheets.v4.model.MoveDimensionRequest
-
The zero-based start index of where to move the source data to, based on the coordinates
*before* the source data is removed from the grid.
- getDestinationSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.CopySheetToAnotherSpreadsheetRequest
-
The ID of the spreadsheet to copy the sheet to.
- getDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.CreateDeveloperMetadataRequest
-
The developer metadata to create.
- getDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.CreateDeveloperMetadataResponse
-
The developer metadata that was created.
- getDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.DimensionProperties
-
The developer metadata associated with a single row or column.
- getDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.MatchedDeveloperMetadata
-
The developer metadata matching the specified filters.
- getDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The developer metadata associated with a sheet.
- getDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The developer metadata associated with a spreadsheet.
- getDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataRequest
-
The value that all metadata matched by the data filters will be updated to.
- getDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataResponse
-
The updated developer metadata.
- getDeveloperMetadataLookup() - Method in class com.google.api.services.sheets.v4.model.DataFilter
-
Selects data associated with the developer metadata matching the criteria described by this
DeveloperMetadataLookup.
- getDimension() - Method in class com.google.api.services.sheets.v4.model.AppendDimensionRequest
-
Whether rows or columns should be appended.
- getDimension() - Method in class com.google.api.services.sheets.v4.model.DimensionRange
-
The dimension of the span.
- getDimension() - Method in class com.google.api.services.sheets.v4.model.SourceAndDestination
-
The dimension that data should be filled into.
- getDimensionGroup() - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionGroupRequest
-
The group whose state should be updated.
- getDimensionGroups() - Method in class com.google.api.services.sheets.v4.model.AddDimensionGroupResponse
-
All groups of a dimension after adding a group to that dimension.
- getDimensionGroups() - Method in class com.google.api.services.sheets.v4.model.DeleteDimensionGroupResponse
-
All groups of a dimension after deleting a group from that dimension.
- getDimensionIndex() - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The dimension the sort should be applied to.
- getDimensionRange() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLocation
-
Represents the row or column when metadata is associated with a dimension.
- getDimensions() - Method in class com.google.api.services.sheets.v4.model.AutoResizeDimensionsRequest
-
The dimensions to automatically resize.
- getDomain() - Method in class com.google.api.services.sheets.v4.model.BasicChartDomain
-
The data of the domain.
- getDomain() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data containing the bubble x-values.
- getDomain() - Method in class com.google.api.services.sheets.v4.model.CandlestickChartSpec
-
The domain data (horizontal axis) for the candlestick chart.
- getDomain() - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
The data that covers the domain of the pie chart.
- getDomain() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
The domain data (horizontal axis) for the waterfall chart.
- getDomains() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The domain of data this is charting.
- getDomainUsersCanEdit() - Method in class com.google.api.services.sheets.v4.model.Editors
-
True if anyone in the document's domain has edit access to the protected range.
- getDuplicateFilterView() - Method in class com.google.api.services.sheets.v4.model.Request
-
Duplicates a filter view.
- getDuplicateFilterView() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from duplicating a filter view.
- getDuplicateSheet() - Method in class com.google.api.services.sheets.v4.model.Request
-
Duplicates a sheet.
- getDuplicateSheet() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from duplicating a sheet.
- getDuplicatesRemovedCount() - Method in class com.google.api.services.sheets.v4.model.DeleteDuplicatesResponse
-
The number of duplicate rows removed.
- getEditors() - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The users and groups with edit access to the protected range.
- getEffectiveFormat() - Method in class com.google.api.services.sheets.v4.model.CellData
-
The effective format being used by the cell.
- getEffectiveValue() - Method in class com.google.api.services.sheets.v4.model.CellData
-
The effective value of the cell.
- getEnd() - Method in class com.google.api.services.sheets.v4.model.HistogramRule
-
The maximum value at which items are placed into buckets of constant size.
- getEndColumnIndex() - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The end column (exclusive) of the range, or not set if unbounded.
- getEndIndex() - Method in class com.google.api.services.sheets.v4.model.DimensionRange
-
The end (exclusive) of the span, or not set if unbounded.
- getEndRowIndex() - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The end row (exclusive) of the range, or not set if unbounded.
- getErrorValue() - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents an error.
- getFields() - Method in class com.google.api.services.sheets.v4.model.AppendCellsRequest
-
The fields of CellData that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.RepeatCellRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateBandingRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateCellsRequest
-
The fields of CellData that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionGroupRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionPropertiesRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionRequest
-
The fields of OverlayPosition that should be updated when setting a new position.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateFilterViewRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateNamedRangeRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateProtectedRangeRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateSheetPropertiesRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateSlicerSpecRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.model.UpdateSpreadsheetPropertiesRequest
-
The fields that should be updated.
- getFields() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Selector specifying which fields to include in a partial response.
- getFillLength() - Method in class com.google.api.services.sheets.v4.model.SourceAndDestination
-
The number of rows or columns that data should be filled into.
- getFilter() - Method in class com.google.api.services.sheets.v4.model.AddFilterViewRequest
-
The filter to add.
- getFilter() - Method in class com.google.api.services.sheets.v4.model.AddFilterViewResponse
-
The newly added filter view.
- getFilter() - Method in class com.google.api.services.sheets.v4.model.DuplicateFilterViewResponse
-
The newly created filter.
- getFilter() - Method in class com.google.api.services.sheets.v4.model.SetBasicFilterRequest
-
The filter to set.
- getFilter() - Method in class com.google.api.services.sheets.v4.model.UpdateFilterViewRequest
-
The new properties of the filter view.
- getFilterCriteria() - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The filtering criteria of the slicer.
- getFilterId() - Method in class com.google.api.services.sheets.v4.model.DeleteFilterViewRequest
-
The ID of the filter to delete.
- getFilterId() - Method in class com.google.api.services.sheets.v4.model.DuplicateFilterViewRequest
-
The ID of the filter being duplicated.
- getFilterViewId() - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The ID of the filter view.
- getFilterViews() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The filter views in this sheet.
- getFind() - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
The value to search.
- getFindReplace() - Method in class com.google.api.services.sheets.v4.model.Request
-
Finds and replaces occurrences of some text with other text.
- getFindReplace() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from doing a find/replace.
- getFirstBandColor() - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The first color that is alternating.
- getFirstBandColorStyle() - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The first color that is alternating.
- getFirstValueIsTotal() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
True to interpret the first value as a total.
- getFontFamily() - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
The font family.
- getFontName() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The name of the font to use by default for all chart text (e.g.
- getFontSize() - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
The size of the font.
- getFooterColor() - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The color of the last row or column.
- getFooterColorStyle() - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The color of the last row or column.
- getForegroundColor() - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The foreground color to sort by; cells with this foreground color are sorted to the top.
- getForegroundColor() - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
The foreground color of the text.
- getForegroundColorStyle() - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The foreground color to sort by; cells with this foreground color are sorted to the top.
- getForegroundColorStyle() - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
The foreground color of the text.
- getFormat() - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The format of the title.
- getFormat() - Method in class com.google.api.services.sheets.v4.model.BooleanRule
-
The format to apply.
- getFormat() - Method in class com.google.api.services.sheets.v4.model.TextFormatRun
-
The format of this run.
- getFormattedValue() - Method in class com.google.api.services.sheets.v4.model.CellData
-
The formatted value of the cell.
- getFormula() - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
A custom formula to calculate the value.
- getFormulasChanged() - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of formula cells changed.
- getFormulaValue() - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents a formula.
- getFrozenColumnCount() - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
The number of columns that are frozen in the grid.
- getFrozenRowCount() - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
The number of rows that are frozen in the grid.
- getGradientRule() - Method in class com.google.api.services.sheets.v4.model.ConditionalFormatRule
-
The formatting will vary based on the gradients in the rule.
- getGreen() - Method in class com.google.api.services.sheets.v4.model.Color
-
The amount of green in the color as a value in the interval [0, 1].
- getGridProperties() - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
Additional properties of the sheet if this sheet is a grid.
- getGridRange() - Method in class com.google.api.services.sheets.v4.model.DataFilter
-
Selects data that matches the range described by the GridRange.
- getGroupIds() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data containing the bubble group IDs.
- getGroupName() - Method in class com.google.api.services.sheets.v4.model.ManualRuleGroup
-
The group name, which must be a string.
- getGroupRule() - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The group rule to apply to this row/column group.
- getGroups() - Method in class com.google.api.services.sheets.v4.model.Editors
-
The email addresses of groups with edit access to the protected range.
- getGroups() - Method in class com.google.api.services.sheets.v4.model.ManualRule
-
The list of group names and the corresponding items from the source data that map to each group
name.
- getHeaderColor() - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The color of the first row or column.
- getHeaderColor() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The background color for header cells.
- getHeaderColorStyle() - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The color of the first row or column.
- getHeaderColorStyle() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The background color for header cells.
- getHeaderCount() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The number of rows or columns in the data that are "headers".
- getHeightPixels() - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The height of the object, in pixels.
- getHidden() - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
True if the sheet is hidden in the UI, false if it's visible.
- getHiddenByFilter() - Method in class com.google.api.services.sheets.v4.model.DimensionProperties
-
True if this dimension is being filtered.
- getHiddenByUser() - Method in class com.google.api.services.sheets.v4.model.DimensionProperties
-
True if this dimension is explicitly hidden.
- getHiddenDimensionStrategy() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
Determines how the charts will use hidden rows or columns.
- getHiddenValues() - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
Values that should be hidden.
- getHideConnectorLines() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
True to hide connector lines between columns.
- getHideGridlines() - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
True if the grid isn't showing gridlines in the UI.
- getHideTooltips() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
True to hide tooltips.
- getHideTrailingSubtotal() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
True to hide the subtotal column from the end of the series.
- getHighSeries() - Method in class com.google.api.services.sheets.v4.model.CandlestickData
-
The range data (vertical axis) for the high/maximum value for each candle.
- getHintedLevels() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The number of additional data levels beyond the labeled levels to be shown on the treemap
chart.
- getHistogramChart() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A histogram chart specification.
- getHistogramRule() - Method in class com.google.api.services.sheets.v4.model.PivotGroupRule
-
A HistogramRule.
- getHorizontalAlignment() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The horizontal alignment of the value in the cell.
- getHorizontalAlignment() - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The horizontal alignment of title in the slicer.
- getHorizontalAlignment() - Method in class com.google.api.services.sheets.v4.model.TextPosition
-
Horizontal alignment setting for the piece of text.
- getHtml() - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
True if the data is HTML.
- getHyperlink() - Method in class com.google.api.services.sheets.v4.model.CellData
-
A hyperlink this cell points to, if any.
- getHyperlinkDisplayType() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
How a hyperlink, if it exists, should be displayed in the cell.
- getIncludeFormulas() - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True if the search should include cells with formulas.
- getIncludeGridData() - Method in class com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest
-
True if grid data should be returned.
- getIncludeGridData() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
True if grid data should be returned.
- getIncludeSpreadsheetInResponse() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest
-
Determines if the update response should include the spreadsheet resource.
- getIncludeValuesInResponse() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
Determines if the update response should include the values of the cells that were updated.
- getIncludeValuesInResponse() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
Determines if the update response should include the values of the cells that were updated.
- getIncludeValuesInResponse() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
Determines if the update response should include the values of the cells that were appended.
- getIncludeValuesInResponse() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
Determines if the update response should include the values of the cells that were updated.
- getIndex() - Method in class com.google.api.services.sheets.v4.model.AddConditionalFormatRuleRequest
-
The zero-based index where the rule should be inserted.
- getIndex() - Method in class com.google.api.services.sheets.v4.model.DeleteConditionalFormatRuleRequest
-
The zero-based index of the rule to be deleted.
- getIndex() - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The index of the sheet within the spreadsheet.
- getIndex() - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleRequest
-
The zero-based index of the rule that should be replaced or moved.
- getInheritFromBefore() - Method in class com.google.api.services.sheets.v4.model.InsertDimensionRequest
-
Whether dimension properties should be extended from the dimensions before or after the newly
inserted dimensions.
- getInnerHorizontal() - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The horizontal border to put within the range.
- getInnerVertical() - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The vertical border to put within the range.
- getInputMessage() - Method in class com.google.api.services.sheets.v4.model.DataValidationRule
-
A message to show the user when adding data to the cell.
- getInsertDataOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
How the input data should be inserted.
- getInsertDimension() - Method in class com.google.api.services.sheets.v4.model.Request
-
Inserts new rows or columns in a sheet.
- getInsertRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Inserts new cells in a sheet, shifting the existing cells.
- getInsertSheetIndex() - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetRequest
-
The zero-based index where the new sheet should be inserted.
- getInterpolateNulls() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
If some values in a series are missing, gaps may appear in the chart (e.g, segments of lines in
a line chart will be missing).
- getInterval() - Method in class com.google.api.services.sheets.v4.model.HistogramRule
-
The size of the buckets that are created.
- getItalic() - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
True if the text is italicized.
- getItems() - Method in class com.google.api.services.sheets.v4.model.ManualRuleGroup
-
The items in the source data that should be placed into this group.
- getIterativeCalculationSettings() - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
Determines whether and how circular references are resolved with iterative calculation.
- getKey() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
API key.
- getKeyValueData() - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
The data for scorecard key value.
- getKeyValueFormat() - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
Formatting options for key value.
- getLabel() - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The labels to use for the row/column groups which can be customized.
- getLabel() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartColumnStyle
-
The label of the column's legend.
- getLabel() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartCustomSubtotal
-
A label for the subtotal column.
- getLabels() - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The data containing the labels for all the nodes in the chart.
- getLabels() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The data that contains the treemap cell labels.
- getLeft() - Method in class com.google.api.services.sheets.v4.model.Borders
-
The left border of the cell.
- getLeft() - Method in class com.google.api.services.sheets.v4.model.Padding
-
The left padding of the cell.
- getLeft() - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The border to put at the left of the range.
- getLegendPosition() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The position of the chart legend.
- getLegendPosition() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
Where the legend of the chart should be drawn.
- getLegendPosition() - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
The position of the chart legend.
- getLegendPosition() - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
Where the legend of the pie chart should be drawn.
- getLength() - Method in class com.google.api.services.sheets.v4.model.AppendDimensionRequest
-
The number of rows or columns to append.
- getLevels() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The number of data levels to show on the treemap chart.
- getLineSmoothing() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
Gets whether all lines should be rendered smooth or straight by default.
- getLineStyle() - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The line style of this series.
- getLocale() - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The locale of the spreadsheet in one of the following formats:
* an ISO 639-1 language code such as `en`
* an ISO 639-2 language code such as `fil`, if no 639-1 code exists
* a combination of the ISO language code and country code, such as `en_US`
Note: when updating this field, not all locales/languages are supported.
- getLocation() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
The location where the metadata is associated.
- getLocationMatchingStrategy() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Determines how this lookup matches the location.
- getLocationType() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLocation
-
The type of location this object represents.
- getLocationType() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to those entries which are associated with locations of
the specified type.
- getLowSeries() - Method in class com.google.api.services.sheets.v4.model.CandlestickData
-
The range data (vertical axis) for the low/minimum value for each candle.
- getMajorDimension() - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest
-
The major dimension that results should use.
- getMajorDimension() - Method in class com.google.api.services.sheets.v4.model.DataFilterValueRange
-
The major dimension of the values.
- getMajorDimension() - Method in class com.google.api.services.sheets.v4.model.ValueRange
-
The major dimension of the values.
- getMajorDimension() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
The major dimension that results should use.
- getMajorDimension() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
The major dimension that results should use.
- getManualRule() - Method in class com.google.api.services.sheets.v4.model.PivotGroupRule
-
A ManualRule.
- getMatchCase() - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True if the search is case sensitive.
- getMatchedDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.SearchDeveloperMetadataResponse
-
The metadata matching the criteria of the search request.
- getMatchEntireCell() - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True if the find value should match the entire cell.
- getMaximized() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
True to make a chart fill the entire space in which it's rendered with minimum padding.
- getMaxIterations() - Method in class com.google.api.services.sheets.v4.model.IterativeCalculationSettings
-
When iterative calculation is enabled, the maximum number of calculation rounds to perform.
- getMaxpoint() - Method in class com.google.api.services.sheets.v4.model.GradientRule
-
The final interpolation point.
- getMaxValue() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The maximum possible data value.
- getMaxValueColor() - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value greater than or equal to maxValue.
- getMaxValueColorStyle() - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value greater than or equal to maxValue.
- getMergeCells() - Method in class com.google.api.services.sheets.v4.model.Request
-
Merges cells together.
- getMerges() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The ranges that are merged together.
- getMergeType() - Method in class com.google.api.services.sheets.v4.model.MergeCellsRequest
-
How the cells should be merged.
- getMessage() - Method in class com.google.api.services.sheets.v4.model.ErrorValue
-
A message with more information about the error (in the spreadsheet's locale).
- getMetadataId() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
The spreadsheet-scoped unique ID that identifies the metadata.
- getMetadataId() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to that which has a matching
DeveloperMetadata.metadata_id.
- getMetadataId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
The ID of the developer metadata to retrieve.
- getMetadataKey() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
The metadata key.
- getMetadataKey() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to that which has a matching
DeveloperMetadata.metadata_key.
- getMetadataLocation() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to those entries associated with the specified location.
- getMetadataValue() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
Data associated with the metadata's key.
- getMetadataValue() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to that which has a matching
DeveloperMetadata.metadata_value.
- getMidpoint() - Method in class com.google.api.services.sheets.v4.model.GradientRule
-
An optional midway interpolation point.
- getMidValueColor() - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value at the midpoint between minValue and
maxValue.
- getMidValueColorStyle() - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value at the midpoint between minValue and
maxValue.
- getMinpoint() - Method in class com.google.api.services.sheets.v4.model.GradientRule
-
The starting interpolation point.
- getMinValue() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The minimum possible data value.
- getMinValueColor() - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value less than or equal to minValue.
- getMinValueColorStyle() - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value less than or equal to minValue.
- getMoveDimension() - Method in class com.google.api.services.sheets.v4.model.Request
-
Moves rows or columns to another location in a sheet.
- getName() - Method in class com.google.api.services.sheets.v4.model.NamedRange
-
The name of the named range.
- getName() - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
A name to use for the value.
- getNamedRange() - Method in class com.google.api.services.sheets.v4.model.AddNamedRangeRequest
-
The named range to add.
- getNamedRange() - Method in class com.google.api.services.sheets.v4.model.AddNamedRangeResponse
-
The named range to add.
- getNamedRange() - Method in class com.google.api.services.sheets.v4.model.UpdateNamedRangeRequest
-
The named range to update with the new properties.
- getNamedRangeId() - Method in class com.google.api.services.sheets.v4.model.DeleteNamedRangeRequest
-
The ID of the named range to delete.
- getNamedRangeId() - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The named range this filter view is backed by, if any.
- getNamedRangeId() - Method in class com.google.api.services.sheets.v4.model.NamedRange
-
The ID of the named range.
- getNamedRangeId() - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The named range this protected range is backed by, if any.
- getNamedRanges() - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The named ranges defined in a spreadsheet.
- getNegativeColor() - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Color to be used, in case baseline value represents a negative change for key value.
- getNegativeColorStyle() - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Color to be used, in case baseline value represents a negative change for key value.
- getNegativeColumnsStyle() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
Styles for all columns in this series with negative values.
- getNewIndex() - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleRequest
-
The zero-based new index the rule should end up at.
- getNewIndex() - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleResponse
-
The index of the new rule.
- getNewPosition() - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionRequest
-
An explicit position to move the embedded object to.
- getNewRule() - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleResponse
-
The new rule that replaced the old rule (if replacing), or the rule that was moved (if moved)
- getNewSheet() - Method in class com.google.api.services.sheets.v4.model.EmbeddedObjectPosition
-
If true, the embedded object is put on a new sheet whose ID is chosen for you.
- getNewSheetId() - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetRequest
-
If set, the ID of the new sheet.
- getNewSheetName() - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetRequest
-
The name of the new sheet.
- getNoDataColor() - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells that have no color data associated with them.
- getNoDataColorStyle() - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells that have no color data associated with them.
- getNodeColor() - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The color of the org chart nodes.
- getNodeColorStyle() - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The color of the org chart nodes.
- getNodeSize() - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The size of the org chart nodes.
- getNote() - Method in class com.google.api.services.sheets.v4.model.CellData
-
Any note on the cell.
- getNumberFormat() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
A format describing how number values should be represented to the user.
- getNumberFormatSource() - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
The number format source used in the scorecard chart.
- getNumberValue() - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents a double value.
- getOauthToken() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
OAuth 2.0 token for the current user.
- getObjectId() - Method in class com.google.api.services.sheets.v4.model.DeleteEmbeddedObjectRequest
-
The ID of the embedded object to delete.
- getObjectId() - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionRequest
-
The ID of the object to moved.
- getOccurrencesChanged() - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of occurrences (possibly multiple within a cell) changed.
- getOffsetXPixels() - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The horizontal offset, in pixels, that the object is offset from the anchor cell.
- getOffsetYPixels() - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The vertical offset, in pixels, that the object is offset from the anchor cell.
- getOldIndex() - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleResponse
-
The old index of the rule.
- getOldRule() - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleResponse
-
The old (deleted) rule.
- getOpenSeries() - Method in class com.google.api.services.sheets.v4.model.CandlestickData
-
The range data (vertical axis) for the open/initial value for each candle.
- getOrgChart() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
An org chart specification.
- getOutlierPercentile() - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
The outlier percentile is used to ensure that outliers do not adversely affect the calculation
of bucket sizes.
- getOverlayPosition() - Method in class com.google.api.services.sheets.v4.model.EmbeddedObjectPosition
-
The position at which the object is overlaid on top of a grid.
- getPadding() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The padding of the cell.
- getParentLabels() - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The data containing the label of the parent for the corresponding node.
- getParentLabels() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The data the contains the treemap cells' parent labels.
- getPasteData() - Method in class com.google.api.services.sheets.v4.model.Request
-
Pastes data (HTML or delimited) into a sheet.
- getPasteOrientation() - Method in class com.google.api.services.sheets.v4.model.CopyPasteRequest
-
How that data should be oriented when pasting.
- getPasteType() - Method in class com.google.api.services.sheets.v4.model.CopyPasteRequest
-
What kind of data to paste.
- getPasteType() - Method in class com.google.api.services.sheets.v4.model.CutPasteRequest
-
What kind of data to paste.
- getPattern() - Method in class com.google.api.services.sheets.v4.model.NumberFormat
-
Pattern string used for formatting.
- getPieChart() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A pie chart specification.
- getPieHole() - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
The size of the hole in the pie chart.
- getPivotTable() - Method in class com.google.api.services.sheets.v4.model.CellData
-
A pivot table anchored at this cell.
- getPixelSize() - Method in class com.google.api.services.sheets.v4.model.DimensionProperties
-
The height (if a row) or width (if a column) of the dimension in pixels.
- getPosition() - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Specifies the horizontal text positioning of baseline value.
- getPosition() - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The position of this axis.
- getPosition() - Method in class com.google.api.services.sheets.v4.model.EmbeddedChart
-
The position of the chart.
- getPosition() - Method in class com.google.api.services.sheets.v4.model.KeyValueFormat
-
Specifies the horizontal text positioning of key value.
- getPosition() - Method in class com.google.api.services.sheets.v4.model.Slicer
-
The position of the slicer.
- getPosition() - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionResponse
-
The new position of the embedded object.
- getPositiveColor() - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Color to be used, in case baseline value represents a positive change for key value.
- getPositiveColorStyle() - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Color to be used, in case baseline value represents a positive change for key value.
- getPositiveColumnsStyle() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
Styles for all columns in this series with positive values.
- getPrefix() - Method in class com.google.api.services.sheets.v4.model.ChartCustomNumberFormatOptions
-
Custom prefix to be prepended to the chart attribute.
- getPrettyPrint() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Returns response with indentations and line breaks.
- getPrimaryFontFamily() - Method in class com.google.api.services.sheets.v4.model.SpreadsheetTheme
-
/ Name of the primary font family.
- getProperties() - Method in class com.google.api.services.sheets.v4.model.AddSheetRequest
-
The properties the new sheet should have.
- getProperties() - Method in class com.google.api.services.sheets.v4.model.AddSheetResponse
-
The properties of the newly added sheet.
- getProperties() - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetResponse
-
The properties of the duplicate sheet.
- getProperties() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The properties of the sheet.
- getProperties() - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
Overall properties of a spreadsheet.
- getProperties() - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionPropertiesRequest
-
Properties to update.
- getProperties() - Method in class com.google.api.services.sheets.v4.model.UpdateSheetPropertiesRequest
-
The properties to update.
- getProperties() - Method in class com.google.api.services.sheets.v4.model.UpdateSpreadsheetPropertiesRequest
-
The properties to update.
- getProtectedRange() - Method in class com.google.api.services.sheets.v4.model.AddProtectedRangeRequest
-
The protected range to be added.
- getProtectedRange() - Method in class com.google.api.services.sheets.v4.model.AddProtectedRangeResponse
-
The newly added protected range.
- getProtectedRange() - Method in class com.google.api.services.sheets.v4.model.UpdateProtectedRangeRequest
-
The protected range to update with the new properties.
- getProtectedRangeId() - Method in class com.google.api.services.sheets.v4.model.DeleteProtectedRangeRequest
-
The ID of the protected range to delete.
- getProtectedRangeId() - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The ID of the protected range.
- getProtectedRanges() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The protected ranges in this sheet.
- getQuotaUser() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Available to use for quota purposes for server-side applications.
- getRandomizeRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Randomizes the order of the rows in a range.
- getRange() - Method in class com.google.api.services.sheets.v4.model.AddDimensionGroupRequest
-
The range over which to create a group.
- getRange() - Method in class com.google.api.services.sheets.v4.model.AutoFillRequest
-
The range to autofill.
- getRange() - Method in class com.google.api.services.sheets.v4.model.BandedRange
-
The range over which these properties are applied.
- getRange() - Method in class com.google.api.services.sheets.v4.model.BasicFilter
-
The range the filter covers.
- getRange() - Method in class com.google.api.services.sheets.v4.model.DeleteDimensionGroupRequest
-
The range of the group to be deleted.
- getRange() - Method in class com.google.api.services.sheets.v4.model.DeleteDimensionRequest
-
The dimensions to delete from the sheet.
- getRange() - Method in class com.google.api.services.sheets.v4.model.DeleteDuplicatesRequest
-
The range to remove duplicates rows from.
- getRange() - Method in class com.google.api.services.sheets.v4.model.DeleteRangeRequest
-
The range of cells to delete.
- getRange() - Method in class com.google.api.services.sheets.v4.model.DimensionGroup
-
The range over which this group exists.
- getRange() - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The range this filter view covers.
- getRange() - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
The range to find/replace over.
- getRange() - Method in class com.google.api.services.sheets.v4.model.InsertDimensionRequest
-
The dimensions to insert.
- getRange() - Method in class com.google.api.services.sheets.v4.model.InsertRangeRequest
-
The range to insert new cells into.
- getRange() - Method in class com.google.api.services.sheets.v4.model.MergeCellsRequest
-
The range of cells to merge.
- getRange() - Method in class com.google.api.services.sheets.v4.model.NamedRange
-
The range this represents.
- getRange() - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The range that is being protected.
- getRange() - Method in class com.google.api.services.sheets.v4.model.RandomizeRangeRequest
-
The range to randomize.
- getRange() - Method in class com.google.api.services.sheets.v4.model.RepeatCellRequest
-
The range to repeat the cell in.
- getRange() - Method in class com.google.api.services.sheets.v4.model.SetDataValidationRequest
-
The range the data validation rule should apply to.
- getRange() - Method in class com.google.api.services.sheets.v4.model.SortRangeRequest
-
The range to sort.
- getRange() - Method in class com.google.api.services.sheets.v4.model.TrimWhitespaceRequest
-
The range whose cells to trim.
- getRange() - Method in class com.google.api.services.sheets.v4.model.UnmergeCellsRequest
-
The range within which all cells should be unmerged.
- getRange() - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The range whose borders should be updated.
- getRange() - Method in class com.google.api.services.sheets.v4.model.UpdateCellsRequest
-
The range to write data to.
- getRange() - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionPropertiesRequest
-
The rows or columns to update.
- getRange() - Method in class com.google.api.services.sheets.v4.model.ValueRange
-
The range the values cover, in A1 notation.
- getRange() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
The A1 notation of a range to search for a logical table of data.
- getRange() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
The A1 notation of the values to clear.
- getRange() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
The A1 notation of the values to retrieve.
- getRange() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
The A1 notation of the values to update.
- getRanges() - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesRequest
-
The ranges to clear, in A1 notation.
- getRanges() - Method in class com.google.api.services.sheets.v4.model.ConditionalFormatRule
-
The ranges that are formatted if the condition is true.
- getRanges() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
The ranges to retrieve from the spreadsheet.
- getRanges() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
The A1 notation of the values to retrieve.
- getRed() - Method in class com.google.api.services.sheets.v4.model.Color
-
The amount of red in the color as a value in the interval [0, 1].
- getRelativeDate() - Method in class com.google.api.services.sheets.v4.model.ConditionValue
-
A relative date (based on the current date).
- getRepeatCell() - Method in class com.google.api.services.sheets.v4.model.Request
-
Repeats a single cell across a range.
- getRepeatHeadings() - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
True if the headings in this pivot group should be repeated.
- getReplacement() - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
The value to use as the replacement.
- getReplies() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetResponse
-
The reply of the updates.
- getRequestingUserCanEdit() - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
True if the user who requested this protected range can edit the protected area.
- getRequests() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest
-
A list of updates to apply to the spreadsheet.
- getResponseDateTimeRenderOption() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
Determines how dates, times, and durations in the response should be rendered.
- getResponseDateTimeRenderOption() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
Determines how dates, times, and durations in the response should be rendered.
- getResponseDateTimeRenderOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
Determines how dates, times, and durations in the response should be rendered.
- getResponseDateTimeRenderOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
Determines how dates, times, and durations in the response should be rendered.
- getResponseIncludeGridData() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest
-
True if grid data should be returned.
- getResponseRanges() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest
-
Limits the ranges included in the response spreadsheet.
- getResponses() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The response for each range updated.
- getResponses() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
One UpdateValuesResponse per requested range, in the same order as the requests appeared.
- getResponseValueRenderOption() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
Determines how values in the response should be rendered.
- getResponseValueRenderOption() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
Determines how values in the response should be rendered.
- getResponseValueRenderOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
Determines how values in the response should be rendered.
- getResponseValueRenderOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
Determines how values in the response should be rendered.
- getReversed() - Method in class com.google.api.services.sheets.v4.model.BasicChartDomain
-
True to reverse the order of the domain values (horizontal axis).
- getReversed() - Method in class com.google.api.services.sheets.v4.model.CandlestickDomain
-
True to reverse the order of the domain values (horizontal axis).
- getReversed() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartDomain
-
True to reverse the order of the domain values (horizontal axis).
- getRgbColor() - Method in class com.google.api.services.sheets.v4.model.ColorStyle
-
RGB color.
- getRight() - Method in class com.google.api.services.sheets.v4.model.Borders
-
The right border of the cell.
- getRight() - Method in class com.google.api.services.sheets.v4.model.Padding
-
The right padding of the cell.
- getRight() - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The border to put at the right of the range.
- getRightToLeft() - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
True if the sheet is an RTL sheet instead of an LTR sheet.
- getRowCount() - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
The number of rows in the grid.
- getRowData() - Method in class com.google.api.services.sheets.v4.model.GridData
-
The data in the grid, one entry per row, starting with the row in startRow.
- getRowGroupControlAfter() - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
True if the row grouping control toggle is shown after the group.
- getRowGroups() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
All row groups on this sheet, ordered by increasing range start index, then by group depth.
- getRowIndex() - Method in class com.google.api.services.sheets.v4.model.GridCoordinate
-
The row index of the coordinate.
- getRowMetadata() - Method in class com.google.api.services.sheets.v4.model.GridData
-
Metadata about the requested rows in the grid, starting with the row in start_row.
- getRowProperties() - Method in class com.google.api.services.sheets.v4.model.BandedRange
-
Properties for row bands.
- getRows() - Method in class com.google.api.services.sheets.v4.model.AppendCellsRequest
-
The data to append.
- getRows() - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
Each row grouping in the pivot table.
- getRows() - Method in class com.google.api.services.sheets.v4.model.UpdateCellsRequest
-
The data to write.
- getRowsChanged() - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of rows changed.
- getRule() - Method in class com.google.api.services.sheets.v4.model.AddConditionalFormatRuleRequest
-
The rule to add.
- getRule() - Method in class com.google.api.services.sheets.v4.model.DeleteConditionalFormatRuleResponse
-
The rule that was deleted.
- getRule() - Method in class com.google.api.services.sheets.v4.model.SetDataValidationRequest
-
The data validation rule to set on each cell in the range, or empty to clear the data
validation in the range.
- getRule() - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleRequest
-
The rule that should replace the rule at the given index.
- getScaleFactor() - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
Value to scale scorecard key and baseline value.
- getScorecardChart() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A scorecard chart specification.
- getSearchByRegex() - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True if the find value is a regex.
- getSecondBandColor() - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The second color that is alternating.
- getSecondBandColorStyle() - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The second color that is alternating.
- getSelectedNodeColor() - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The color of the selected org chart nodes.
- getSelectedNodeColorStyle() - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The color of the selected org chart nodes.
- getSeries() - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The data being visualized in this chart series.
- getSeries() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The data this chart is visualizing.
- getSeries() - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data contianing the bubble y-values.
- getSeries() - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
The series for a histogram may be either a single series of values to be bucketed or multiple
series, each of the same length, containing the name of the series followed by the values to be
bucketed for that series.
- getSeries() - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
The data that covers the one and only series of the pie chart.
- getSeries() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
The data this waterfall chart is visualizing.
- getSetBasicFilter() - Method in class com.google.api.services.sheets.v4.model.Request
-
Sets the basic filter on a sheet.
- getSetDataValidation() - Method in class com.google.api.services.sheets.v4.model.Request
-
Sets data validation for one or more cells.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.AppendCellsRequest
-
The sheet ID to append the data to.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.AppendDimensionRequest
-
The sheet to append rows or columns to.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.ClearBasicFilterRequest
-
The sheet ID on which the basic filter should be cleared.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.DeleteConditionalFormatRuleRequest
-
The sheet the rule is being deleted from.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.DeleteSheetRequest
-
The ID of the sheet to delete.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLocation
-
The ID of the sheet when metadata is associated with an entire sheet.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.DimensionRange
-
The sheet this span is on.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.EmbeddedObjectPosition
-
The sheet this is on.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
The sheet to find/replace over.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.GridCoordinate
-
The sheet this coordinate is on.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The sheet this range is on.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The ID of the sheet.
- getSheetId() - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleRequest
-
The sheet of the rule to move.
- getSheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
The ID of the sheet to copy.
- getSheets() - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The sheets that are part of a spreadsheet.
- getSheetsChanged() - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of sheets changed.
- getSheetType() - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The type of sheet.
- getShiftDimension() - Method in class com.google.api.services.sheets.v4.model.DeleteRangeRequest
-
The dimension from which deleted cells will be replaced with.
- getShiftDimension() - Method in class com.google.api.services.sheets.v4.model.InsertRangeRequest
-
The dimension which will be shifted when inserting cells.
- getShowCustomUi() - Method in class com.google.api.services.sheets.v4.model.DataValidationRule
-
True if the UI should be customized based on the kind of condition.
- getShowItemDividers() - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
Whether horizontal divider lines should be displayed between items in each column.
- getShowTotals() - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
True if the pivot table should include the totals for this grouping.
- getSizeData() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The data that determines the size of each treemap data cell.
- getSlicer() - Method in class com.google.api.services.sheets.v4.model.AddSlicerRequest
-
The slicer that should be added to the spreadsheet, including the position where it should be
placed.
- getSlicer() - Method in class com.google.api.services.sheets.v4.model.AddSlicerResponse
-
The newly added slicer.
- getSlicerId() - Method in class com.google.api.services.sheets.v4.model.Slicer
-
The ID of the slicer.
- getSlicerId() - Method in class com.google.api.services.sheets.v4.model.UpdateSlicerSpecRequest
-
The id of the slicer to update.
- getSlicers() - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The slicers on this sheet.
- getSortOrder() - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The order the values in this group should be sorted.
- getSortOrder() - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The order data should be sorted.
- getSortRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Sorts data in a range.
- getSortSpecs() - Method in class com.google.api.services.sheets.v4.model.BasicFilter
-
The sort order per column.
- getSortSpecs() - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The sort order per column.
- getSortSpecs() - Method in class com.google.api.services.sheets.v4.model.SortRangeRequest
-
The sort order per column.
- getSource() - Method in class com.google.api.services.sheets.v4.model.CopyPasteRequest
-
The source range to copy.
- getSource() - Method in class com.google.api.services.sheets.v4.model.CutPasteRequest
-
The source data to cut.
- getSource() - Method in class com.google.api.services.sheets.v4.model.MoveDimensionRequest
-
The source dimensions to move.
- getSource() - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
The range the pivot table is reading data from.
- getSource() - Method in class com.google.api.services.sheets.v4.model.SourceAndDestination
-
The location of the data to use as the source of the autofill.
- getSource() - Method in class com.google.api.services.sheets.v4.model.TextToColumnsRequest
-
The source data range.
- getSourceAndDestination() - Method in class com.google.api.services.sheets.v4.model.AutoFillRequest
-
The source and destination areas to autofill.
- getSourceColumnOffset() - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The column offset of the source range that this grouping is based on.
- getSourceColumnOffset() - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
The column offset of the source range that this value reads from.
- getSourceRange() - Method in class com.google.api.services.sheets.v4.model.ChartData
-
The source ranges of the data.
- getSources() - Method in class com.google.api.services.sheets.v4.model.ChartSourceRange
-
The ranges of data for a series or domain.
- getSourceSheetId() - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetRequest
-
The sheet to duplicate.
- getSpec() - Method in class com.google.api.services.sheets.v4.model.EmbeddedChart
-
The specification of the chart.
- getSpec() - Method in class com.google.api.services.sheets.v4.model.Slicer
-
The specification of the slicer.
- getSpec() - Method in class com.google.api.services.sheets.v4.model.UpdateChartSpecRequest
-
The specification to apply to the chart.
- getSpec() - Method in class com.google.api.services.sheets.v4.model.UpdateSlicerSpecRequest
-
The specification to apply to the slicer.
- getSpreadsheet() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLocation
-
True when metadata is associated with an entire spreadsheet.
- GetSpreadsheetByDataFilterRequest - Class in com.google.api.services.sheets.v4.model
-
The request for retrieving a Spreadsheet.
- GetSpreadsheetByDataFilterRequest() - Constructor for class com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest
-
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.AppendValuesResponse
-
The spreadsheet the updates were applied to.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterResponse
-
The spreadsheet the updates were applied to.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesResponse
-
The spreadsheet the updates were applied to.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterResponse
-
The ID of the spreadsheet the data was retrieved from.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesResponse
-
The ID of the spreadsheet the data was retrieved from.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetResponse
-
The spreadsheet the updates were applied to.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The spreadsheet the updates were applied to.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The spreadsheet the updates were applied to.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.ClearValuesResponse
-
The spreadsheet the updates were applied to.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The ID of the spreadsheet.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The spreadsheet the updates were applied to.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
The spreadsheet to apply the updates to.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
The ID of the spreadsheet to retrieve metadata from.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
The ID of the spreadsheet to retrieve metadata from.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
The spreadsheet to request.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
The spreadsheet to request.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
The ID of the spreadsheet containing the sheet to copy.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
The ID of the spreadsheet to update.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
The ID of the spreadsheet to update.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
The ID of the spreadsheet to update.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
The ID of the spreadsheet to retrieve data from.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
The ID of the spreadsheet to retrieve data from.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
The ID of the spreadsheet to update.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
The ID of the spreadsheet to update.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
The ID of the spreadsheet to update.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
The ID of the spreadsheet to retrieve data from.
- getSpreadsheetId() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
The ID of the spreadsheet to update.
- getSpreadsheetTheme() - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
Theme applied to the spreadsheet.
- getSpreadsheetUrl() - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The url of the spreadsheet.
- getStackedType() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The stacked type for charts that support vertical stacking.
- getStackedType() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
The stacked type.
- getStart() - Method in class com.google.api.services.sheets.v4.model.HistogramRule
-
The minimum value at which items are placed into buckets of constant size.
- getStart() - Method in class com.google.api.services.sheets.v4.model.UpdateCellsRequest
-
The coordinate to start writing data at.
- getStartColumn() - Method in class com.google.api.services.sheets.v4.model.GridData
-
The first column this GridData refers to, zero-based.
- getStartColumnIndex() - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The start column (inclusive) of the range, or not set if unbounded.
- getStartIndex() - Method in class com.google.api.services.sheets.v4.model.DimensionRange
-
The start (inclusive) of the span, or not set if unbounded.
- getStartIndex() - Method in class com.google.api.services.sheets.v4.model.TextFormatRun
-
The character index where this run starts.
- getStartRow() - Method in class com.google.api.services.sheets.v4.model.GridData
-
The first row this GridData refers to, zero-based.
- getStartRowIndex() - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The start row (inclusive) of the range, or not set if unbounded.
- getStrict() - Method in class com.google.api.services.sheets.v4.model.DataValidationRule
-
True if invalid data should be rejected.
- getStrikethrough() - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
True if the text has a strikethrough.
- getStringValue() - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents a string value.
- getStyle() - Method in class com.google.api.services.sheets.v4.model.Border
-
The style of the border.
- getSubtitle() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The subtitle of the chart.
- getSubtitleTextFormat() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The subtitle text format.
- getSubtitleTextPosition() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The subtitle text position.
- getSubtotalColumnsStyle() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
Styles for all subtotal columns in this series.
- getSubtotalIndex() - Method in class com.google.api.services.sheets.v4.model.WaterfallChartCustomSubtotal
-
The 0-based index of a data point within the series.
- getSuffix() - Method in class com.google.api.services.sheets.v4.model.ChartCustomNumberFormatOptions
-
Custom suffix to be appended to the chart attribute.
- getSummarizeFunction() - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
A function to summarize the value.
- getTabColor() - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The color of the tab in the UI.
- getTabColorStyle() - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The color of the tab in the UI.
- getTableRange() - Method in class com.google.api.services.sheets.v4.model.AppendValuesResponse
-
The range (in A1 notation) of the table that values are being appended to (before the values
were appended).
- getTargetAxis() - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The minor axis that will specify the range of values for this series.
- getTextDirection() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The direction of the text in the cell.
- getTextFormat() - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Text formatting options for baseline value.
- getTextFormat() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The format of the text in the cell (unless overridden by a format run).
- getTextFormat() - Method in class com.google.api.services.sheets.v4.model.KeyValueFormat
-
Text formatting options for key value.
- getTextFormat() - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The text format of title in the slicer.
- getTextFormat() - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The text format for all labels on the chart.
- getTextFormatRuns() - Method in class com.google.api.services.sheets.v4.model.CellData
-
Runs of rich text applied to subsections of the cell.
- getTextRotation() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The rotation applied to text in a cell
- getTextToColumns() - Method in class com.google.api.services.sheets.v4.model.Request
-
Converts a column of text into many columns of text.
- getThemeColor() - Method in class com.google.api.services.sheets.v4.model.ColorStyle
-
Theme color.
- getThemeColors() - Method in class com.google.api.services.sheets.v4.model.SpreadsheetTheme
-
The spreadsheet theme color pairs.
- getThreeDimensional() - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
True to make the chart 3D.
- getThreeDimensional() - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
True if the pie is three dimensional.
- getTimeZone() - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The time zone of the spreadsheet, in CLDR format such as `America/New_York`.
- getTitle() - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The title of this axis.
- getTitle() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The title of the chart.
- getTitle() - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The name of the filter view.
- getTitle() - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The name of the sheet.
- getTitle() - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The title of the slicer.
- getTitle() - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The title of the spreadsheet.
- getTitleTextFormat() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The title text format.
- getTitleTextPosition() - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The axis title text position.
- getTitleTextPosition() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The title text position.
- getTooltips() - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The data containing the tooltip for the corresponding node.
- getTop() - Method in class com.google.api.services.sheets.v4.model.Borders
-
The top border of the cell.
- getTop() - Method in class com.google.api.services.sheets.v4.model.Padding
-
The top padding of the cell.
- getTop() - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The border to put at the top of the range.
- getTotalUpdatedCells() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The total number of cells updated.
- getTotalUpdatedCells() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The total number of cells updated.
- getTotalUpdatedColumns() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The total number of columns where at least one cell in the column was updated.
- getTotalUpdatedColumns() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The total number of columns where at least one cell in the column was updated.
- getTotalUpdatedRows() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The total number of rows where at least one cell in the row was updated.
- getTotalUpdatedRows() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The total number of rows where at least one cell in the row was updated.
- getTotalUpdatedSheets() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The total number of sheets where at least one cell in the sheet was updated.
- getTotalUpdatedSheets() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The total number of sheets where at least one cell in the sheet was updated.
- getTreemapChart() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A treemap chart specification.
- getTrimWhitespace() - Method in class com.google.api.services.sheets.v4.model.Request
-
Trims cells of whitespace (such as spaces, tabs, or new lines).
- getTrimWhitespace() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from trimming whitespace.
- getType() - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The type of this series.
- getType() - Method in class com.google.api.services.sheets.v4.model.BooleanCondition
-
The type of condition.
- getType() - Method in class com.google.api.services.sheets.v4.model.DateTimeRule
-
The type of date-time grouping to apply.
- getType() - Method in class com.google.api.services.sheets.v4.model.ErrorValue
-
The type of error.
- getType() - Method in class com.google.api.services.sheets.v4.model.InterpolationPoint
-
How the value should be interpreted.
- getType() - Method in class com.google.api.services.sheets.v4.model.LineStyle
-
The dash type of the line.
- getType() - Method in class com.google.api.services.sheets.v4.model.NumberFormat
-
The type of the number format.
- getType() - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
How the data should be pasted.
- getUnderline() - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
True if the text is underlined.
- getUnmergeCells() - Method in class com.google.api.services.sheets.v4.model.Request
-
Unmerges merged cells.
- getUnprotectedRanges() - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The list of unprotected ranges within a protected sheet.
- getUpdateBanding() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a banded range
- getUpdateBorders() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates the borders in a range of cells.
- getUpdateCells() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates many cells at once.
- getUpdateChartSpec() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a chart's specifications.
- getUpdateConditionalFormatRule() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates an existing conditional format rule.
- getUpdateConditionalFormatRule() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from updating a conditional format rule.
- getUpdatedCells() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The number of cells updated.
- getUpdatedCells() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The number of cells updated.
- getUpdatedColumns() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The number of columns where at least one cell in the column was updated.
- getUpdatedColumns() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The number of columns where at least one cell in the column was updated.
- getUpdatedData() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The values of the cells in the range matched by the dataFilter after all updates were applied.
- getUpdatedData() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The values of the cells after updates were applied.
- getUpdateDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates an existing developer metadata entry
- getUpdateDeveloperMetadata() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from updating a developer metadata entry.
- getUpdateDimensionGroup() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates the state of the specified group.
- getUpdateDimensionProperties() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates dimensions' properties.
- getUpdatedRange() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The range (in A1 notation) that updates were applied to.
- getUpdatedRange() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The range (in A1 notation) that updates were applied to.
- getUpdatedRows() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The number of rows where at least one cell in the row was updated.
- getUpdatedRows() - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The number of rows where at least one cell in the row was updated.
- getUpdatedSpreadsheet() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetResponse
-
The spreadsheet after updates were applied.
- getUpdateEmbeddedObjectPosition() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates an embedded object's (e.g.
- getUpdateEmbeddedObjectPosition() - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from updating an embedded object's position.
- getUpdateFilterView() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates the properties of a filter view.
- getUpdateNamedRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a named range.
- getUpdateProtectedRange() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a protected range.
- getUpdates() - Method in class com.google.api.services.sheets.v4.model.AppendValuesResponse
-
Information about the updates that were applied.
- getUpdateSheetProperties() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a sheet's properties.
- getUpdateSlicerSpec() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a slicer's specifications.
- getUpdateSpreadsheetProperties() - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates the spreadsheet's properties.
- getUploadProtocol() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Upload protocol for media (e.g.
- getUploadType() - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Legacy upload protocol for media (e.g.
- getUseAlternateSeries() - Method in class com.google.api.services.sheets.v4.model.AutoFillRequest
-
True if we should generate data with the "alternate" series.
- getUserEnteredFormat() - Method in class com.google.api.services.sheets.v4.model.CellData
-
The format the user entered for the cell.
- getUserEnteredValue() - Method in class com.google.api.services.sheets.v4.model.CellData
-
The value the user entered in the cell.
- getUserEnteredValue() - Method in class com.google.api.services.sheets.v4.model.ConditionValue
-
A value the condition is based on.
- getUsers() - Method in class com.google.api.services.sheets.v4.model.Editors
-
The email addresses of users with edit access to the protected range.
- getValue() - Method in class com.google.api.services.sheets.v4.model.InterpolationPoint
-
The value this interpolation point uses.
- getValue() - Method in class com.google.api.services.sheets.v4.model.PivotGroupValueMetadata
-
The calculated value the metadata corresponds to.
- getValueBucket() - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The bucket of the opposite pivot group to sort by.
- getValueInputOption() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
How the input data should be interpreted.
- getValueInputOption() - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
How the input data should be interpreted.
- getValueInputOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
How the input data should be interpreted.
- getValueInputOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
How the input data should be interpreted.
- getValueLayout() - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
Whether values should be listed horizontally (as columns) or vertically (as rows).
- getValueMetadata() - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
Metadata about values in the grouping.
- getValueRange() - Method in class com.google.api.services.sheets.v4.model.MatchedValueRange
-
The values matched by the DataFilter.
- getValueRanges() - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterResponse
-
The requested values with the list of data filters that matched them.
- getValueRanges() - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesResponse
-
The requested values.
- getValueRenderOption() - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest
-
How values should be represented in the output.
- getValueRenderOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
How values should be represented in the output.
- getValueRenderOption() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
How values should be represented in the output.
- getValues() - Method in class com.google.api.services.sheets.v4.model.BooleanCondition
-
The values of the condition.
- getValues() - Method in class com.google.api.services.sheets.v4.model.DataFilterValueRange
-
The data to be written.
- getValues() - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
A list of values to include in the pivot table.
- getValues() - Method in class com.google.api.services.sheets.v4.model.RowData
-
The values in the row, one per column.
- getValues() - Method in class com.google.api.services.sheets.v4.model.ValueRange
-
The data that was read or to be written.
- getValuesChanged() - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of non-formula cells changed.
- getValuesIndex() - Method in class com.google.api.services.sheets.v4.model.PivotGroupSortValueBucket
-
The offset in the PivotTable.values list which the values in this grouping should be sorted by.
- getVertical() - Method in class com.google.api.services.sheets.v4.model.TextRotation
-
If true, text reads top to bottom, but the orientation of individual characters is unchanged.
- getVerticalAlignment() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The vertical alignment of the value in the cell.
- getViewWindowMax() - Method in class com.google.api.services.sheets.v4.model.ChartAxisViewWindowOptions
-
The maximum numeric value to be shown in this view window.
- getViewWindowMin() - Method in class com.google.api.services.sheets.v4.model.ChartAxisViewWindowOptions
-
The minimum numeric value to be shown in this view window.
- getViewWindowMode() - Method in class com.google.api.services.sheets.v4.model.ChartAxisViewWindowOptions
-
The view window's mode.
- getViewWindowOptions() - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The view window options for this axis.
- getVisibility() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
The metadata visibility.
- getVisibility() - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to that which has a matching
DeveloperMetadata.visibility.
- getVisibleBackgroundColor() - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
The background fill color to filter by; only cells with this fill color are shown.
- getVisibleBackgroundColorStyle() - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
The background fill color to filter by; only cells with this fill color are shown.
- getVisibleForegroundColor() - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
The foreground color to filter by; only cells with this foreground color are shown.
- getVisibleForegroundColorStyle() - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
The foreground color to filter by; only cells with this foreground color are shown.
- getVisibleValues() - Method in class com.google.api.services.sheets.v4.model.PivotFilterCriteria
-
Values that should be included.
- getWarningOnly() - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
True if this protected range will show a warning when editing.
- getWaterfallChart() - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A waterfall chart specification.
- getWidth() - Method in class com.google.api.services.sheets.v4.model.Border
-
The width of the border, in pixels.
- getWidth() - Method in class com.google.api.services.sheets.v4.model.LineStyle
-
The thickness of the line, in px.
- getWidthPixels() - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The width of the object, in pixels.
- getWrapStrategy() - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The wrap strategy for the value in the cell.
- GradientRule - Class in com.google.api.services.sheets.v4.model
-
A rule that applies a gradient color scale format, based on the interpolation points listed.
- GradientRule() - Constructor for class com.google.api.services.sheets.v4.model.GradientRule
-
- GridCoordinate - Class in com.google.api.services.sheets.v4.model
-
A coordinate in a sheet.
- GridCoordinate() - Constructor for class com.google.api.services.sheets.v4.model.GridCoordinate
-
- GridData - Class in com.google.api.services.sheets.v4.model
-
Data in the grid, as well as metadata about the dimensions.
- GridData() - Constructor for class com.google.api.services.sheets.v4.model.GridData
-
- GridProperties - Class in com.google.api.services.sheets.v4.model
-
Properties of a grid.
- GridProperties() - Constructor for class com.google.api.services.sheets.v4.model.GridProperties
-
- GridRange - Class in com.google.api.services.sheets.v4.model
-
A range on a sheet.
- GridRange() - Constructor for class com.google.api.services.sheets.v4.model.GridRange
-
- ScorecardChartSpec - Class in com.google.api.services.sheets.v4.model
-
A scorecard chart.
- ScorecardChartSpec() - Constructor for class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
- search(String, SearchDeveloperMetadataRequest) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata
-
Returns all developer metadata matching the specified DataFilter.
- Search(String, SearchDeveloperMetadataRequest) - Constructor for class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
Returns all developer metadata matching the specified DataFilter.
- SearchDeveloperMetadataRequest - Class in com.google.api.services.sheets.v4.model
-
A request to retrieve all developer metadata matching the set of specified criteria.
- SearchDeveloperMetadataRequest() - Constructor for class com.google.api.services.sheets.v4.model.SearchDeveloperMetadataRequest
-
- SearchDeveloperMetadataResponse - Class in com.google.api.services.sheets.v4.model
-
A reply to a developer metadata search request.
- SearchDeveloperMetadataResponse() - Constructor for class com.google.api.services.sheets.v4.model.SearchDeveloperMetadataResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddBandingRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddBandingResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddChartRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddChartResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddConditionalFormatRuleRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddDimensionGroupRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddDimensionGroupResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddFilterViewRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddFilterViewResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddNamedRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddNamedRangeResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddProtectedRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddProtectedRangeResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddSheetRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddSheetResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddSlicerRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AddSlicerResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AppendCellsRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AppendDimensionRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AppendValuesResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AutoFillRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.AutoResizeDimensionsRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BandedRange
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BasicChartDomain
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BasicFilter
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BooleanCondition
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BooleanRule
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Border
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Borders
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CandlestickChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CandlestickData
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CandlestickDomain
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CandlestickSeries
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CellData
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ChartAxisViewWindowOptions
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ChartCustomNumberFormatOptions
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ChartData
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ChartSourceRange
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ClearBasicFilterRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ClearValuesRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ClearValuesResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Color
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ColorStyle
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ConditionalFormatRule
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ConditionValue
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CopyPasteRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CopySheetToAnotherSpreadsheetRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CreateDeveloperMetadataRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CreateDeveloperMetadataResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.CutPasteRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DataFilter
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DataFilterValueRange
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DataValidationRule
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DateTimeRule
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteBandingRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteConditionalFormatRuleRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteConditionalFormatRuleResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteDeveloperMetadataRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteDeveloperMetadataResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteDimensionGroupRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteDimensionGroupResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteDimensionRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteDuplicatesRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteDuplicatesResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteEmbeddedObjectRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteFilterViewRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteNamedRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteProtectedRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeleteSheetRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLocation
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DimensionGroup
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DimensionProperties
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DimensionRange
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DuplicateFilterViewRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DuplicateFilterViewResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Editors
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.EmbeddedChart
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.EmbeddedObjectPosition
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ErrorValue
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.FilterView
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.GradientRule
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.GridCoordinate
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.GridData
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.GridRange
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.HistogramRule
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.HistogramSeries
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.InsertDimensionRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.InsertRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.InterpolationPoint
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.IterativeCalculationSettings
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.KeyValueFormat
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.LineStyle
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ManualRule
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ManualRuleGroup
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.MatchedDeveloperMetadata
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.MatchedValueRange
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.MergeCellsRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.MoveDimensionRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.NamedRange
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.NumberFormat
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Padding
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.PivotFilterCriteria
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.PivotGroupRule
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.PivotGroupSortValueBucket
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.PivotGroupValueMetadata
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.RandomizeRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.RepeatCellRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Request
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Response
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.RowData
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SearchDeveloperMetadataRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SearchDeveloperMetadataResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SetBasicFilterRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SetDataValidationRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Slicer
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SortRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SourceAndDestination
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetTheme
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.TextFormatRun
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.TextPosition
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.TextRotation
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.TextToColumnsRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ThemeColorPair
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.TrimWhitespaceRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.TrimWhitespaceResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UnmergeCellsRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateBandingRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateCellsRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateChartSpecRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionGroupRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionPropertiesRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateFilterViewRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateNamedRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateProtectedRangeRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateSheetPropertiesRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateSlicerSpecRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateSpreadsheetPropertiesRequest
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.ValueRange
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartColumnStyle
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartCustomSubtotal
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartDomain
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- set(String, Object) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- set$Xgafv(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
V1 error format.
- setA1Range(String) - Method in class com.google.api.services.sheets.v4.model.DataFilter
-
Selects data that matches the specified A1 range.
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setAccessToken(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
OAuth access token.
- setAddBanding(AddBandingRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a new banded range
- setAddBanding(AddBandingResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a banded range.
- setAddChart(AddChartRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a chart.
- setAddChart(AddChartResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a chart.
- setAddConditionalFormatRule(AddConditionalFormatRuleRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a new conditional format rule.
- setAddDimensionGroup(AddDimensionGroupRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Creates a group over the specified range.
- setAddDimensionGroup(AddDimensionGroupResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a dimension group.
- setAddFilterView(AddFilterViewRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a filter view.
- setAddFilterView(AddFilterViewResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a filter view.
- setAddNamedRange(AddNamedRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a named range.
- setAddNamedRange(AddNamedRangeResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a named range.
- setAddProtectedRange(AddProtectedRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a protected range.
- setAddProtectedRange(AddProtectedRangeResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a protected range.
- setAddSheet(AddSheetRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a sheet.
- setAddSheet(AddSheetResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a sheet.
- setAddSlicer(AddSlicerRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Adds a slicer.
- setAddSlicer(AddSlicerResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from adding a slicer.
- setAggregateType(String) - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
The aggregation type for key and baseline chart data in scorecard chart.
- setAllSheets(Boolean) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True to find/replace over all sheets.
- setAlpha(Float) - Method in class com.google.api.services.sheets.v4.model.Color
-
The fraction of this color that should be applied to the pixel.
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setAlt(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Data format for response.
- setAltText(String) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The alternative text that describes the chart.
- setAnchorCell(GridCoordinate) - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The cell the object is anchored to.
- setAngle(Integer) - Method in class com.google.api.services.sheets.v4.model.TextRotation
-
The angle between the standard orientation and the desired orientation.
- setAppendCells(AppendCellsRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Appends cells after the last row with data in a sheet.
- setAppendDimension(AppendDimensionRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Appends dimensions to the end of a sheet.
- setApplicationName(String) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setApplyToPivotTables(Boolean) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
True if the filter should apply to pivot tables.
- setAutoFill(AutoFillRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Automatically fills in more data based on existing data.
- setAutoRecalc(String) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The amount of time to wait before volatile functions are recalculated.
- setAutoResizeDimensions(AutoResizeDimensionsRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Automatically resizes one or more dimensions based on the contents of the cells in that
dimension.
- setAxis(List<BasicChartAxis>) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The axis on the chart.
- setBackgroundColor(Color) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The background color of the cell.
- setBackgroundColor(Color) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The background color of the entire chart.
- setBackgroundColor(Color) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The background color of the slicer.
- setBackgroundColor(Color) - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The background fill color to sort by; cells with this fill color are sorted to the top.
- setBackgroundColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The background color of the cell.
- setBackgroundColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The background color of the entire chart.
- setBackgroundColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The background color of the slicer.
- setBackgroundColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The background fill color to sort by; cells with this fill color are sorted to the top.
- setBandedRange(BandedRange) - Method in class com.google.api.services.sheets.v4.model.AddBandingRequest
-
The banded range to add.
- setBandedRange(BandedRange) - Method in class com.google.api.services.sheets.v4.model.AddBandingResponse
-
The banded range that was added.
- setBandedRange(BandedRange) - Method in class com.google.api.services.sheets.v4.model.UpdateBandingRequest
-
The banded range to update with the new properties.
- setBandedRangeId(Integer) - Method in class com.google.api.services.sheets.v4.model.BandedRange
-
The id of the banded range.
- setBandedRangeId(Integer) - Method in class com.google.api.services.sheets.v4.model.DeleteBandingRequest
-
The ID of the banded range to delete.
- setBandedRanges(List<BandedRange>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The banded (alternating colors) ranges on this sheet.
- setBarColor(Color) - Method in class com.google.api.services.sheets.v4.model.HistogramSeries
-
The color of the column representing this series in each bucket.
- setBarColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.HistogramSeries
-
The color of the column representing this series in each bucket.
- setBaselineValueData(ChartData) - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
The data for scorecard baseline value.
- setBaselineValueFormat(BaselineValueFormat) - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
Formatting options for baseline value.
- setBasicChart(BasicChartSpec) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A basic chart specification, can be one of many kinds of charts.
- setBasicFilter(BasicFilter) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The filter on this sheet, if any.
- SetBasicFilterRequest - Class in com.google.api.services.sheets.v4.model
-
Sets the basic filter associated with a sheet.
- SetBasicFilterRequest() - Constructor for class com.google.api.services.sheets.v4.model.SetBasicFilterRequest
-
- setBatchPath(String) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setBlue(Float) - Method in class com.google.api.services.sheets.v4.model.Color
-
The amount of blue in the color as a value in the interval [0, 1].
- setBold(Boolean) - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
True if the text is bold.
- setBooleanRule(BooleanRule) - Method in class com.google.api.services.sheets.v4.model.ConditionalFormatRule
-
The formatting is either "on" or "off" according to the rule.
- setBoolValue(Boolean) - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents a boolean value.
- setBorders(Borders) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The borders of the cell.
- setBottom(Border) - Method in class com.google.api.services.sheets.v4.model.Borders
-
The bottom border of the cell.
- setBottom(Integer) - Method in class com.google.api.services.sheets.v4.model.Padding
-
The bottom padding of the cell.
- setBottom(Border) - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The border to put at the bottom of the range.
- setBubbleBorderColor(Color) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The bubble border color.
- setBubbleBorderColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The bubble border color.
- setBubbleChart(BubbleChartSpec) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A bubble chart specification.
- setBubbleLabels(ChartData) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data containing the bubble labels.
- setBubbleMaxRadiusSize(Integer) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The max radius size of the bubbles, in pixels.
- setBubbleMinRadiusSize(Integer) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The minimum radius size of the bubbles, in pixels.
- setBubbleOpacity(Float) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The opacity of the bubbles between 0 and 1.0.
- setBubbleSizes(ChartData) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data contianing the bubble sizes.
- setBubbleTextStyle(TextFormat) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The format of the text inside the bubbles.
- setBuckets(List<ExtendedValue>) - Method in class com.google.api.services.sheets.v4.model.PivotGroupSortValueBucket
-
Determines the bucket from which values are chosen to sort.
- setBucketSize(Double) - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
By default the bucket size (the range of values stacked in a single column) is chosen
automatically, but it may be overridden here.
- setCalculatedDisplayType(String) - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
If specified, indicates that pivot values should be displayed as the result of a calculation
with another pivot value.
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setCallback(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
JSONP
- setCandlestickChart(CandlestickChartSpec) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A candlestick chart specification.
- setCell(CellData) - Method in class com.google.api.services.sheets.v4.model.RepeatCellRequest
-
The data to write.
- setCellsChangedCount(Integer) - Method in class com.google.api.services.sheets.v4.model.TrimWhitespaceResponse
-
The number of cells that were trimmed of whitespace.
- setChart(EmbeddedChart) - Method in class com.google.api.services.sheets.v4.model.AddChartRequest
-
The chart that should be added to the spreadsheet, including the position where it should be
placed.
- setChart(EmbeddedChart) - Method in class com.google.api.services.sheets.v4.model.AddChartResponse
-
The newly added chart.
- setChartId(Integer) - Method in class com.google.api.services.sheets.v4.model.EmbeddedChart
-
The ID of the chart.
- setChartId(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateChartSpecRequest
-
The ID of the chart to update.
- setCharts(List<EmbeddedChart>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The specifications of every chart on this sheet.
- setChartType(String) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The type of the chart.
- setClearBasicFilter(ClearBasicFilterRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Clears the basic filter on a sheet.
- setClearedRange(String) - Method in class com.google.api.services.sheets.v4.model.ClearValuesResponse
-
The range (in A1 notation) that was cleared.
- setClearedRanges(List<String>) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterResponse
-
The ranges that were cleared, in A1 notation.
- setClearedRanges(List<String>) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesResponse
-
The ranges that were cleared, in A1 notation.
- setCloseSeries(CandlestickSeries) - Method in class com.google.api.services.sheets.v4.model.CandlestickData
-
The range data (vertical axis) for the close/final value for each candle.
- setCollapsed(Boolean) - Method in class com.google.api.services.sheets.v4.model.DimensionGroup
-
This field is true if this group is collapsed.
- setCollapsed(Boolean) - Method in class com.google.api.services.sheets.v4.model.PivotGroupValueMetadata
-
True if the data corresponding to the value is collapsed.
- setColor(Color) - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The color for elements (such as bars, lines, and points) associated with this series.
- setColor(Color) - Method in class com.google.api.services.sheets.v4.model.Border
-
The color of the border.
- setColor(Color) - Method in class com.google.api.services.sheets.v4.model.InterpolationPoint
-
The color this interpolation point should use.
- setColor(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.ThemeColorPair
-
The concrete color corresponding to the theme color type.
- setColor(Color) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartColumnStyle
-
The color of the column.
- setColorData(ChartData) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The data that determines the background color of each treemap data cell.
- setColorScale(TreemapChartColorScale) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The color scale for data cells in the treemap chart.
- setColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The color for elements (such as bars, lines, and points) associated with this series.
- setColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.Border
-
The color of the border.
- setColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.InterpolationPoint
-
The color this interpolation point should use.
- setColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartColumnStyle
-
The color of the column.
- setColorType(String) - Method in class com.google.api.services.sheets.v4.model.ThemeColorPair
-
The type of the spreadsheet theme color.
- setColumnCount(Integer) - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
The number of columns in the grid.
- setColumnGroupControlAfter(Boolean) - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
True if the column grouping control toggle is shown after the group.
- setColumnGroups(List<DimensionGroup>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
All column groups on this sheet, ordered by increasing range start index, then by group depth.
- setColumnIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.GridCoordinate
-
The column index of the coordinate.
- setColumnIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The column index in the data table on which the filter is applied to.
- setColumnMetadata(List<DimensionProperties>) - Method in class com.google.api.services.sheets.v4.model.GridData
-
Metadata about the requested columns in the grid, starting with the column in start_column.
- setColumnProperties(BandingProperties) - Method in class com.google.api.services.sheets.v4.model.BandedRange
-
Properties for column bands.
- setColumns(List<PivotGroup>) - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
Each column grouping in the pivot table.
- setCompareMode(String) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The behavior of tooltips and data highlighting when hovering on data and chart area.
- setComparisonColumns(List<DimensionRange>) - Method in class com.google.api.services.sheets.v4.model.DeleteDuplicatesRequest
-
The columns in the range to analyze for duplicate values.
- setComparisonType(String) - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
The comparison type of key value with baseline value.
- setCondition(BooleanCondition) - Method in class com.google.api.services.sheets.v4.model.BooleanRule
-
The condition of the rule.
- setCondition(BooleanCondition) - Method in class com.google.api.services.sheets.v4.model.DataValidationRule
-
The condition that data in the cell must match.
- setCondition(BooleanCondition) - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
A condition that must be true for values to be shown.
- setConditionalFormats(List<ConditionalFormatRule>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The conditional format rules in this sheet.
- setConnectorLineStyle(LineStyle) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
The line style for the connector lines.
- setConvergenceThreshold(Double) - Method in class com.google.api.services.sheets.v4.model.IterativeCalculationSettings
-
When iterative calculation is enabled and successive results differ by less than this threshold
value, the calculation rounds stop.
- setCoordinate(GridCoordinate) - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
The coordinate at which the data should start being inserted.
- setCopyPaste(CopyPasteRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Copies data from one area and pastes it to another.
- setCreateDeveloperMetadata(CreateDeveloperMetadataRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Creates new developer metadata
- setCreateDeveloperMetadata(CreateDeveloperMetadataResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from creating a developer metadata entry.
- setCriteria(Map<String, FilterCriteria>) - Method in class com.google.api.services.sheets.v4.model.BasicFilter
-
The criteria for showing/hiding values per column.
- setCriteria(Map<String, FilterCriteria>) - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The criteria for showing/hiding values per column.
- setCriteria(Map<String, PivotFilterCriteria>) - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
An optional mapping of filters per source column offset.
- setCustomFormatOptions(ChartCustomNumberFormatOptions) - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
Custom formatting options for numeric key/baseline values in scorecard chart.
- setCustomSubtotals(List<WaterfallChartCustomSubtotal>) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
Custom subtotal columns appearing in this series.
- setCutPaste(CutPasteRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Cuts data from one area and pastes it to another.
- setData(List<DataFilterValueRange>) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
The new values to apply to the spreadsheet.
- setData(List<ValueRange>) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
The new values to apply to the spreadsheet.
- setData(List<CandlestickData>) - Method in class com.google.api.services.sheets.v4.model.CandlestickChartSpec
-
The Candlestick chart data.
- setData(ChartData) - Method in class com.google.api.services.sheets.v4.model.CandlestickDomain
-
The data of the CandlestickDomain.
- setData(ChartData) - Method in class com.google.api.services.sheets.v4.model.CandlestickSeries
-
The data of the CandlestickSeries.
- setData(ChartData) - Method in class com.google.api.services.sheets.v4.model.HistogramSeries
-
The data for this histogram series.
- setData(String) - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
The data to insert.
- setData(List<GridData>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
Data in the grid, if this is a grid sheet.
- setData(ChartData) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartDomain
-
The data of the WaterfallChartDomain.
- setData(ChartData) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
The data being visualized in this series.
- setDataFilter(DataFilter) - Method in class com.google.api.services.sheets.v4.model.DataFilterValueRange
-
The data filter describing the location of the values in the spreadsheet.
- setDataFilter(DataFilter) - Method in class com.google.api.services.sheets.v4.model.DeleteDeveloperMetadataRequest
-
The data filter describing the criteria used to select which developer metadata entry to
delete.
- setDataFilter(DataFilter) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The data filter that selected the range that was updated.
- setDataFilters(List<DataFilter>) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterRequest
-
The DataFilters used to determine which ranges to clear.
- setDataFilters(List<DataFilter>) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest
-
The data filters used to match the ranges of values to retrieve.
- setDataFilters(List<DataFilter>) - Method in class com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest
-
The DataFilters used to select which ranges to retrieve from the spreadsheet.
- setDataFilters(List<DataFilter>) - Method in class com.google.api.services.sheets.v4.model.MatchedDeveloperMetadata
-
All filters matching the returned developer metadata.
- setDataFilters(List<DataFilter>) - Method in class com.google.api.services.sheets.v4.model.MatchedValueRange
-
The DataFilters from the request that matched the range of values.
- setDataFilters(List<DataFilter>) - Method in class com.google.api.services.sheets.v4.model.SearchDeveloperMetadataRequest
-
The data filters describing the criteria used to determine which DeveloperMetadata entries to
return.
- setDataFilters(List<DataFilter>) - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataRequest
-
The filters matching the developer metadata entries to update.
- setDataIsSubtotal(Boolean) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartCustomSubtotal
-
True if the data point at subtotal_index is the subtotal.
- setDataRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The data range of the slicer.
- setDataValidation(DataValidationRule) - Method in class com.google.api.services.sheets.v4.model.CellData
-
A data validation rule on the cell, if any.
- SetDataValidationRequest - Class in com.google.api.services.sheets.v4.model
-
Sets a data validation rule to every cell in the range.
- SetDataValidationRequest() - Constructor for class com.google.api.services.sheets.v4.model.SetDataValidationRequest
-
- setDateTimeRenderOption(String) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest
-
How dates, times, and durations should be represented in the output.
- setDateTimeRenderOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
How dates, times, and durations should be represented in the output.
- setDateTimeRenderOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
How dates, times, and durations should be represented in the output.
- setDateTimeRule(DateTimeRule) - Method in class com.google.api.services.sheets.v4.model.PivotGroupRule
-
A DateTimeRule.
- setDefaultFormat(CellFormat) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The default format of all cells in the spreadsheet.
- setDeleteBanding(DeleteBandingRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Removes a banded range
- setDeleteConditionalFormatRule(DeleteConditionalFormatRuleRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes an existing conditional format rule.
- setDeleteConditionalFormatRule(DeleteConditionalFormatRuleResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from deleting a conditional format rule.
- setDeletedDeveloperMetadata(List<DeveloperMetadata>) - Method in class com.google.api.services.sheets.v4.model.DeleteDeveloperMetadataResponse
-
The metadata that was deleted.
- setDeleteDeveloperMetadata(DeleteDeveloperMetadataRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes developer metadata
- setDeleteDeveloperMetadata(DeleteDeveloperMetadataResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from deleting a developer metadata entry.
- setDeleteDimension(DeleteDimensionRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes rows or columns in a sheet.
- setDeleteDimensionGroup(DeleteDimensionGroupRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a group over the specified range.
- setDeleteDimensionGroup(DeleteDimensionGroupResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from deleting a dimension group.
- setDeleteDuplicates(DeleteDuplicatesRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Removes rows containing duplicate values in specified columns of a cell range.
- setDeleteDuplicates(DeleteDuplicatesResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from removing rows containing duplicate values.
- setDeleteEmbeddedObject(DeleteEmbeddedObjectRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes an embedded object (e.g, chart, image) in a sheet.
- setDeleteFilterView(DeleteFilterViewRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a filter view from a sheet.
- setDeleteNamedRange(DeleteNamedRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a named range.
- setDeleteProtectedRange(DeleteProtectedRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a protected range.
- setDeleteRange(DeleteRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a range of cells from a sheet, shifting the remaining cells.
- setDeleteSheet(DeleteSheetRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Deletes a sheet.
- setDelimiter(String) - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
The delimiter in the data.
- setDelimiter(String) - Method in class com.google.api.services.sheets.v4.model.TextToColumnsRequest
-
The delimiter to use.
- setDelimiterType(String) - Method in class com.google.api.services.sheets.v4.model.TextToColumnsRequest
-
The delimiter type to use.
- setDepth(Integer) - Method in class com.google.api.services.sheets.v4.model.DimensionGroup
-
The depth of the group, representing how many groups have a range that wholly contains the
range of this group.
- setDescription(String) - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Description which is appended after the baseline value.
- setDescription(String) - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The description of this protected range.
- setDestination(GridRange) - Method in class com.google.api.services.sheets.v4.model.CopyPasteRequest
-
The location to paste to.
- setDestination(GridCoordinate) - Method in class com.google.api.services.sheets.v4.model.CutPasteRequest
-
The top-left coordinate where the data should be pasted.
- setDestinationIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.MoveDimensionRequest
-
The zero-based start index of where to move the source data to, based on the coordinates
*before* the source data is removed from the grid.
- setDestinationSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.CopySheetToAnotherSpreadsheetRequest
-
The ID of the spreadsheet to copy the sheet to.
- setDeveloperMetadata(DeveloperMetadata) - Method in class com.google.api.services.sheets.v4.model.CreateDeveloperMetadataRequest
-
The developer metadata to create.
- setDeveloperMetadata(DeveloperMetadata) - Method in class com.google.api.services.sheets.v4.model.CreateDeveloperMetadataResponse
-
The developer metadata that was created.
- setDeveloperMetadata(List<DeveloperMetadata>) - Method in class com.google.api.services.sheets.v4.model.DimensionProperties
-
The developer metadata associated with a single row or column.
- setDeveloperMetadata(DeveloperMetadata) - Method in class com.google.api.services.sheets.v4.model.MatchedDeveloperMetadata
-
The developer metadata matching the specified filters.
- setDeveloperMetadata(List<DeveloperMetadata>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The developer metadata associated with a sheet.
- setDeveloperMetadata(List<DeveloperMetadata>) - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The developer metadata associated with a spreadsheet.
- setDeveloperMetadata(DeveloperMetadata) - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataRequest
-
The value that all metadata matched by the data filters will be updated to.
- setDeveloperMetadata(List<DeveloperMetadata>) - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataResponse
-
The updated developer metadata.
- setDeveloperMetadataLookup(DeveloperMetadataLookup) - Method in class com.google.api.services.sheets.v4.model.DataFilter
-
Selects data associated with the developer metadata matching the criteria described by this
DeveloperMetadataLookup.
- setDimension(String) - Method in class com.google.api.services.sheets.v4.model.AppendDimensionRequest
-
Whether rows or columns should be appended.
- setDimension(String) - Method in class com.google.api.services.sheets.v4.model.DimensionRange
-
The dimension of the span.
- setDimension(String) - Method in class com.google.api.services.sheets.v4.model.SourceAndDestination
-
The dimension that data should be filled into.
- setDimensionGroup(DimensionGroup) - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionGroupRequest
-
The group whose state should be updated.
- setDimensionGroups(List<DimensionGroup>) - Method in class com.google.api.services.sheets.v4.model.AddDimensionGroupResponse
-
All groups of a dimension after adding a group to that dimension.
- setDimensionGroups(List<DimensionGroup>) - Method in class com.google.api.services.sheets.v4.model.DeleteDimensionGroupResponse
-
All groups of a dimension after deleting a group from that dimension.
- setDimensionIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The dimension the sort should be applied to.
- setDimensionRange(DimensionRange) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLocation
-
Represents the row or column when metadata is associated with a dimension.
- setDimensions(DimensionRange) - Method in class com.google.api.services.sheets.v4.model.AutoResizeDimensionsRequest
-
The dimensions to automatically resize.
- setDisableGZipContent(boolean) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
- setDomain(ChartData) - Method in class com.google.api.services.sheets.v4.model.BasicChartDomain
-
The data of the domain.
- setDomain(ChartData) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data containing the bubble x-values.
- setDomain(CandlestickDomain) - Method in class com.google.api.services.sheets.v4.model.CandlestickChartSpec
-
The domain data (horizontal axis) for the candlestick chart.
- setDomain(ChartData) - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
The data that covers the domain of the pie chart.
- setDomain(WaterfallChartDomain) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
The domain data (horizontal axis) for the waterfall chart.
- setDomains(List<BasicChartDomain>) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The domain of data this is charting.
- setDomainUsersCanEdit(Boolean) - Method in class com.google.api.services.sheets.v4.model.Editors
-
True if anyone in the document's domain has edit access to the protected range.
- setDuplicateFilterView(DuplicateFilterViewRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Duplicates a filter view.
- setDuplicateFilterView(DuplicateFilterViewResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from duplicating a filter view.
- setDuplicateSheet(DuplicateSheetRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Duplicates a sheet.
- setDuplicateSheet(DuplicateSheetResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from duplicating a sheet.
- setDuplicatesRemovedCount(Integer) - Method in class com.google.api.services.sheets.v4.model.DeleteDuplicatesResponse
-
The number of duplicate rows removed.
- setEditors(Editors) - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The users and groups with edit access to the protected range.
- setEffectiveFormat(CellFormat) - Method in class com.google.api.services.sheets.v4.model.CellData
-
The effective format being used by the cell.
- setEffectiveValue(ExtendedValue) - Method in class com.google.api.services.sheets.v4.model.CellData
-
The effective value of the cell.
- setEnd(Double) - Method in class com.google.api.services.sheets.v4.model.HistogramRule
-
The maximum value at which items are placed into buckets of constant size.
- setEndColumnIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The end column (exclusive) of the range, or not set if unbounded.
- setEndIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.DimensionRange
-
The end (exclusive) of the span, or not set if unbounded.
- setEndRowIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The end row (exclusive) of the range, or not set if unbounded.
- setErrorValue(ErrorValue) - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents an error.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.AppendCellsRequest
-
The fields of CellData that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.RepeatCellRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateBandingRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateCellsRequest
-
The fields of CellData that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateDeveloperMetadataRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionGroupRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionPropertiesRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionRequest
-
The fields of OverlayPosition that should be updated when setting a new position.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateFilterViewRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateNamedRangeRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateProtectedRangeRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateSheetPropertiesRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateSlicerSpecRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.model.UpdateSpreadsheetPropertiesRequest
-
The fields that should be updated.
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setFields(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Selector specifying which fields to include in a partial response.
- setFillLength(Integer) - Method in class com.google.api.services.sheets.v4.model.SourceAndDestination
-
The number of rows or columns that data should be filled into.
- setFilter(FilterView) - Method in class com.google.api.services.sheets.v4.model.AddFilterViewRequest
-
The filter to add.
- setFilter(FilterView) - Method in class com.google.api.services.sheets.v4.model.AddFilterViewResponse
-
The newly added filter view.
- setFilter(FilterView) - Method in class com.google.api.services.sheets.v4.model.DuplicateFilterViewResponse
-
The newly created filter.
- setFilter(BasicFilter) - Method in class com.google.api.services.sheets.v4.model.SetBasicFilterRequest
-
The filter to set.
- setFilter(FilterView) - Method in class com.google.api.services.sheets.v4.model.UpdateFilterViewRequest
-
The new properties of the filter view.
- setFilterCriteria(FilterCriteria) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The filtering criteria of the slicer.
- setFilterId(Integer) - Method in class com.google.api.services.sheets.v4.model.DeleteFilterViewRequest
-
The ID of the filter to delete.
- setFilterId(Integer) - Method in class com.google.api.services.sheets.v4.model.DuplicateFilterViewRequest
-
The ID of the filter being duplicated.
- setFilterViewId(Integer) - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The ID of the filter view.
- setFilterViews(List<FilterView>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The filter views in this sheet.
- setFind(String) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
The value to search.
- setFindReplace(FindReplaceRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Finds and replaces occurrences of some text with other text.
- setFindReplace(FindReplaceResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from doing a find/replace.
- setFirstBandColor(Color) - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The first color that is alternating.
- setFirstBandColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The first color that is alternating.
- setFirstValueIsTotal(Boolean) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
True to interpret the first value as a total.
- setFontFamily(String) - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
The font family.
- setFontName(String) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The name of the font to use by default for all chart text (e.g.
- setFontSize(Integer) - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
The size of the font.
- setFooterColor(Color) - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The color of the last row or column.
- setFooterColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The color of the last row or column.
- setForegroundColor(Color) - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The foreground color to sort by; cells with this foreground color are sorted to the top.
- setForegroundColor(Color) - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
The foreground color of the text.
- setForegroundColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The foreground color to sort by; cells with this foreground color are sorted to the top.
- setForegroundColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
The foreground color of the text.
- setFormat(TextFormat) - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The format of the title.
- setFormat(CellFormat) - Method in class com.google.api.services.sheets.v4.model.BooleanRule
-
The format to apply.
- setFormat(TextFormat) - Method in class com.google.api.services.sheets.v4.model.TextFormatRun
-
The format of this run.
- setFormattedValue(String) - Method in class com.google.api.services.sheets.v4.model.CellData
-
The formatted value of the cell.
- setFormula(String) - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
A custom formula to calculate the value.
- setFormulasChanged(Integer) - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of formula cells changed.
- setFormulaValue(String) - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents a formula.
- setFrozenColumnCount(Integer) - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
The number of columns that are frozen in the grid.
- setFrozenRowCount(Integer) - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
The number of rows that are frozen in the grid.
- setGoogleClientRequestInitializer(GoogleClientRequestInitializer) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setGradientRule(GradientRule) - Method in class com.google.api.services.sheets.v4.model.ConditionalFormatRule
-
The formatting will vary based on the gradients in the rule.
- setGreen(Float) - Method in class com.google.api.services.sheets.v4.model.Color
-
The amount of green in the color as a value in the interval [0, 1].
- setGridProperties(GridProperties) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
Additional properties of the sheet if this sheet is a grid.
- setGridRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.DataFilter
-
Selects data that matches the range described by the GridRange.
- setGroupIds(ChartData) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data containing the bubble group IDs.
- setGroupName(ExtendedValue) - Method in class com.google.api.services.sheets.v4.model.ManualRuleGroup
-
The group name, which must be a string.
- setGroupRule(PivotGroupRule) - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The group rule to apply to this row/column group.
- setGroups(List<String>) - Method in class com.google.api.services.sheets.v4.model.Editors
-
The email addresses of groups with edit access to the protected range.
- setGroups(List<ManualRuleGroup>) - Method in class com.google.api.services.sheets.v4.model.ManualRule
-
The list of group names and the corresponding items from the source data that map to each group
name.
- setHeaderColor(Color) - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The color of the first row or column.
- setHeaderColor(Color) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The background color for header cells.
- setHeaderColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The color of the first row or column.
- setHeaderColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The background color for header cells.
- setHeaderCount(Integer) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The number of rows or columns in the data that are "headers".
- setHeightPixels(Integer) - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The height of the object, in pixels.
- setHidden(Boolean) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
True if the sheet is hidden in the UI, false if it's visible.
- setHiddenByFilter(Boolean) - Method in class com.google.api.services.sheets.v4.model.DimensionProperties
-
True if this dimension is being filtered.
- setHiddenByUser(Boolean) - Method in class com.google.api.services.sheets.v4.model.DimensionProperties
-
True if this dimension is explicitly hidden.
- setHiddenDimensionStrategy(String) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
Determines how the charts will use hidden rows or columns.
- setHiddenValues(List<String>) - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
Values that should be hidden.
- setHideConnectorLines(Boolean) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
True to hide connector lines between columns.
- setHideGridlines(Boolean) - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
True if the grid isn't showing gridlines in the UI.
- setHideTooltips(Boolean) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
True to hide tooltips.
- setHideTrailingSubtotal(Boolean) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
True to hide the subtotal column from the end of the series.
- setHighSeries(CandlestickSeries) - Method in class com.google.api.services.sheets.v4.model.CandlestickData
-
The range data (vertical axis) for the high/maximum value for each candle.
- setHintedLevels(Integer) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The number of additional data levels beyond the labeled levels to be shown on the treemap
chart.
- setHistogramChart(HistogramChartSpec) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A histogram chart specification.
- setHistogramRule(HistogramRule) - Method in class com.google.api.services.sheets.v4.model.PivotGroupRule
-
A HistogramRule.
- setHorizontalAlignment(String) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The horizontal alignment of the value in the cell.
- setHorizontalAlignment(String) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The horizontal alignment of title in the slicer.
- setHorizontalAlignment(String) - Method in class com.google.api.services.sheets.v4.model.TextPosition
-
Horizontal alignment setting for the piece of text.
- setHtml(Boolean) - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
True if the data is HTML.
- setHttpRequestInitializer(HttpRequestInitializer) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setHyperlink(String) - Method in class com.google.api.services.sheets.v4.model.CellData
-
A hyperlink this cell points to, if any.
- setHyperlinkDisplayType(String) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
How a hyperlink, if it exists, should be displayed in the cell.
- setIncludeFormulas(Boolean) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True if the search should include cells with formulas.
- setIncludeGridData(Boolean) - Method in class com.google.api.services.sheets.v4.model.GetSpreadsheetByDataFilterRequest
-
True if grid data should be returned.
- setIncludeGridData(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
True if grid data should be returned.
- setIncludeSpreadsheetInResponse(Boolean) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest
-
Determines if the update response should include the spreadsheet resource.
- setIncludeValuesInResponse(Boolean) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
Determines if the update response should include the values of the cells that were updated.
- setIncludeValuesInResponse(Boolean) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
Determines if the update response should include the values of the cells that were updated.
- setIncludeValuesInResponse(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
Determines if the update response should include the values of the cells that were
appended.
- setIncludeValuesInResponse(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
Determines if the update response should include the values of the cells that were
updated.
- setIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.AddConditionalFormatRuleRequest
-
The zero-based index where the rule should be inserted.
- setIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.DeleteConditionalFormatRuleRequest
-
The zero-based index of the rule to be deleted.
- setIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The index of the sheet within the spreadsheet.
- setIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleRequest
-
The zero-based index of the rule that should be replaced or moved.
- setInheritFromBefore(Boolean) - Method in class com.google.api.services.sheets.v4.model.InsertDimensionRequest
-
Whether dimension properties should be extended from the dimensions before or after the newly
inserted dimensions.
- setInnerHorizontal(Border) - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The horizontal border to put within the range.
- setInnerVertical(Border) - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The vertical border to put within the range.
- setInputMessage(String) - Method in class com.google.api.services.sheets.v4.model.DataValidationRule
-
A message to show the user when adding data to the cell.
- setInsertDataOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
How the input data should be inserted.
- setInsertDimension(InsertDimensionRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Inserts new rows or columns in a sheet.
- setInsertRange(InsertRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Inserts new cells in a sheet, shifting the existing cells.
- setInsertSheetIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetRequest
-
The zero-based index where the new sheet should be inserted.
- setInterpolateNulls(Boolean) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
If some values in a series are missing, gaps may appear in the chart (e.g, segments of lines in
a line chart will be missing).
- setInterval(Double) - Method in class com.google.api.services.sheets.v4.model.HistogramRule
-
The size of the buckets that are created.
- setItalic(Boolean) - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
True if the text is italicized.
- setItems(List<ExtendedValue>) - Method in class com.google.api.services.sheets.v4.model.ManualRuleGroup
-
The items in the source data that should be placed into this group.
- setIterativeCalculationSettings(IterativeCalculationSettings) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
Determines whether and how circular references are resolved with iterative calculation.
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setKey(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
API key.
- setKeyValueData(ChartData) - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
The data for scorecard key value.
- setKeyValueFormat(KeyValueFormat) - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
Formatting options for key value.
- setLabel(String) - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The labels to use for the row/column groups which can be customized.
- setLabel(String) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartColumnStyle
-
The label of the column's legend.
- setLabel(String) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartCustomSubtotal
-
A label for the subtotal column.
- setLabels(ChartData) - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The data containing the labels for all the nodes in the chart.
- setLabels(ChartData) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The data that contains the treemap cell labels.
- setLeft(Border) - Method in class com.google.api.services.sheets.v4.model.Borders
-
The left border of the cell.
- setLeft(Integer) - Method in class com.google.api.services.sheets.v4.model.Padding
-
The left padding of the cell.
- setLeft(Border) - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The border to put at the left of the range.
- setLegendPosition(String) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The position of the chart legend.
- setLegendPosition(String) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
Where the legend of the chart should be drawn.
- setLegendPosition(String) - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
The position of the chart legend.
- setLegendPosition(String) - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
Where the legend of the pie chart should be drawn.
- setLength(Integer) - Method in class com.google.api.services.sheets.v4.model.AppendDimensionRequest
-
The number of rows or columns to append.
- setLevels(Integer) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The number of data levels to show on the treemap chart.
- setLineSmoothing(Boolean) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
Gets whether all lines should be rendered smooth or straight by default.
- setLineStyle(LineStyle) - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The line style of this series.
- setLocale(String) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The locale of the spreadsheet in one of the following formats:
* an ISO 639-1 language code such as `en`
* an ISO 639-2 language code such as `fil`, if no 639-1 code exists
* a combination of the ISO language code and country code, such as `en_US`
Note: when updating this field, not all locales/languages are supported.
- setLocation(DeveloperMetadataLocation) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
The location where the metadata is associated.
- setLocationMatchingStrategy(String) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Determines how this lookup matches the location.
- setLocationType(String) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLocation
-
The type of location this object represents.
- setLocationType(String) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to those entries which are associated with locations of
the specified type.
- setLowSeries(CandlestickSeries) - Method in class com.google.api.services.sheets.v4.model.CandlestickData
-
The range data (vertical axis) for the low/minimum value for each candle.
- setMajorDimension(String) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest
-
The major dimension that results should use.
- setMajorDimension(String) - Method in class com.google.api.services.sheets.v4.model.DataFilterValueRange
-
The major dimension of the values.
- setMajorDimension(String) - Method in class com.google.api.services.sheets.v4.model.ValueRange
-
The major dimension of the values.
- setMajorDimension(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
The major dimension that results should use.
- setMajorDimension(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
The major dimension that results should use.
- setManualRule(ManualRule) - Method in class com.google.api.services.sheets.v4.model.PivotGroupRule
-
A ManualRule.
- setMatchCase(Boolean) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True if the search is case sensitive.
- setMatchedDeveloperMetadata(List<MatchedDeveloperMetadata>) - Method in class com.google.api.services.sheets.v4.model.SearchDeveloperMetadataResponse
-
The metadata matching the criteria of the search request.
- setMatchEntireCell(Boolean) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True if the find value should match the entire cell.
- setMaximized(Boolean) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
True to make a chart fill the entire space in which it's rendered with minimum padding.
- setMaxIterations(Integer) - Method in class com.google.api.services.sheets.v4.model.IterativeCalculationSettings
-
When iterative calculation is enabled, the maximum number of calculation rounds to perform.
- setMaxpoint(InterpolationPoint) - Method in class com.google.api.services.sheets.v4.model.GradientRule
-
The final interpolation point.
- setMaxValue(Double) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The maximum possible data value.
- setMaxValueColor(Color) - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value greater than or equal to maxValue.
- setMaxValueColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value greater than or equal to maxValue.
- setMergeCells(MergeCellsRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Merges cells together.
- setMerges(List<GridRange>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The ranges that are merged together.
- setMergeType(String) - Method in class com.google.api.services.sheets.v4.model.MergeCellsRequest
-
How the cells should be merged.
- setMessage(String) - Method in class com.google.api.services.sheets.v4.model.ErrorValue
-
A message with more information about the error (in the spreadsheet's locale).
- setMetadataId(Integer) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
The spreadsheet-scoped unique ID that identifies the metadata.
- setMetadataId(Integer) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to that which has a matching
DeveloperMetadata.metadata_id.
- setMetadataId(Integer) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
The ID of the developer metadata to retrieve.
- setMetadataKey(String) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
The metadata key.
- setMetadataKey(String) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to that which has a matching
DeveloperMetadata.metadata_key.
- setMetadataLocation(DeveloperMetadataLocation) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to those entries associated with the specified location.
- setMetadataValue(String) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
Data associated with the metadata's key.
- setMetadataValue(String) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to that which has a matching
DeveloperMetadata.metadata_value.
- setMidpoint(InterpolationPoint) - Method in class com.google.api.services.sheets.v4.model.GradientRule
-
An optional midway interpolation point.
- setMidValueColor(Color) - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value at the midpoint between minValue and
maxValue.
- setMidValueColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value at the midpoint between minValue and
maxValue.
- setMinpoint(InterpolationPoint) - Method in class com.google.api.services.sheets.v4.model.GradientRule
-
The starting interpolation point.
- setMinValue(Double) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The minimum possible data value.
- setMinValueColor(Color) - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value less than or equal to minValue.
- setMinValueColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells with a color value less than or equal to minValue.
- setMoveDimension(MoveDimensionRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Moves rows or columns to another location in a sheet.
- setName(String) - Method in class com.google.api.services.sheets.v4.model.NamedRange
-
The name of the named range.
- setName(String) - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
A name to use for the value.
- setNamedRange(NamedRange) - Method in class com.google.api.services.sheets.v4.model.AddNamedRangeRequest
-
The named range to add.
- setNamedRange(NamedRange) - Method in class com.google.api.services.sheets.v4.model.AddNamedRangeResponse
-
The named range to add.
- setNamedRange(NamedRange) - Method in class com.google.api.services.sheets.v4.model.UpdateNamedRangeRequest
-
The named range to update with the new properties.
- setNamedRangeId(String) - Method in class com.google.api.services.sheets.v4.model.DeleteNamedRangeRequest
-
The ID of the named range to delete.
- setNamedRangeId(String) - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The named range this filter view is backed by, if any.
- setNamedRangeId(String) - Method in class com.google.api.services.sheets.v4.model.NamedRange
-
The ID of the named range.
- setNamedRangeId(String) - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The named range this protected range is backed by, if any.
- setNamedRanges(List<NamedRange>) - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The named ranges defined in a spreadsheet.
- setNegativeColor(Color) - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Color to be used, in case baseline value represents a negative change for key value.
- setNegativeColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Color to be used, in case baseline value represents a negative change for key value.
- setNegativeColumnsStyle(WaterfallChartColumnStyle) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
Styles for all columns in this series with negative values.
- setNewIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleRequest
-
The zero-based new index the rule should end up at.
- setNewIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleResponse
-
The index of the new rule.
- setNewPosition(EmbeddedObjectPosition) - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionRequest
-
An explicit position to move the embedded object to.
- setNewRule(ConditionalFormatRule) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleResponse
-
The new rule that replaced the old rule (if replacing), or the rule that was moved (if moved)
- setNewSheet(Boolean) - Method in class com.google.api.services.sheets.v4.model.EmbeddedObjectPosition
-
If true, the embedded object is put on a new sheet whose ID is chosen for you.
- setNewSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetRequest
-
If set, the ID of the new sheet.
- setNewSheetName(String) - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetRequest
-
The name of the new sheet.
- setNoDataColor(Color) - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells that have no color data associated with them.
- setNoDataColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.TreemapChartColorScale
-
The background color for cells that have no color data associated with them.
- setNodeColor(Color) - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The color of the org chart nodes.
- setNodeColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The color of the org chart nodes.
- setNodeSize(String) - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The size of the org chart nodes.
- setNote(String) - Method in class com.google.api.services.sheets.v4.model.CellData
-
Any note on the cell.
- setNumberFormat(NumberFormat) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
A format describing how number values should be represented to the user.
- setNumberFormatSource(String) - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
The number format source used in the scorecard chart.
- setNumberValue(Double) - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents a double value.
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setOauthToken(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
OAuth 2.0 token for the current user.
- setObjectId(Integer) - Method in class com.google.api.services.sheets.v4.model.DeleteEmbeddedObjectRequest
-
The ID of the embedded object to delete.
- setObjectId(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionRequest
-
The ID of the object to moved.
- setOccurrencesChanged(Integer) - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of occurrences (possibly multiple within a cell) changed.
- setOffsetXPixels(Integer) - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The horizontal offset, in pixels, that the object is offset from the anchor cell.
- setOffsetYPixels(Integer) - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The vertical offset, in pixels, that the object is offset from the anchor cell.
- setOldIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleResponse
-
The old index of the rule.
- setOldRule(ConditionalFormatRule) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleResponse
-
The old (deleted) rule.
- setOpenSeries(CandlestickSeries) - Method in class com.google.api.services.sheets.v4.model.CandlestickData
-
The range data (vertical axis) for the open/initial value for each candle.
- setOrgChart(OrgChartSpec) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
An org chart specification.
- setOutlierPercentile(Double) - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
The outlier percentile is used to ensure that outliers do not adversely affect the calculation
of bucket sizes.
- setOverlayPosition(OverlayPosition) - Method in class com.google.api.services.sheets.v4.model.EmbeddedObjectPosition
-
The position at which the object is overlaid on top of a grid.
- setPadding(Padding) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The padding of the cell.
- setParentLabels(ChartData) - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The data containing the label of the parent for the corresponding node.
- setParentLabels(ChartData) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The data the contains the treemap cells' parent labels.
- setPasteData(PasteDataRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Pastes data (HTML or delimited) into a sheet.
- setPasteOrientation(String) - Method in class com.google.api.services.sheets.v4.model.CopyPasteRequest
-
How that data should be oriented when pasting.
- setPasteType(String) - Method in class com.google.api.services.sheets.v4.model.CopyPasteRequest
-
What kind of data to paste.
- setPasteType(String) - Method in class com.google.api.services.sheets.v4.model.CutPasteRequest
-
What kind of data to paste.
- setPattern(String) - Method in class com.google.api.services.sheets.v4.model.NumberFormat
-
Pattern string used for formatting.
- setPieChart(PieChartSpec) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A pie chart specification.
- setPieHole(Double) - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
The size of the hole in the pie chart.
- setPivotTable(PivotTable) - Method in class com.google.api.services.sheets.v4.model.CellData
-
A pivot table anchored at this cell.
- setPixelSize(Integer) - Method in class com.google.api.services.sheets.v4.model.DimensionProperties
-
The height (if a row) or width (if a column) of the dimension in pixels.
- setPosition(TextPosition) - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Specifies the horizontal text positioning of baseline value.
- setPosition(String) - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The position of this axis.
- setPosition(EmbeddedObjectPosition) - Method in class com.google.api.services.sheets.v4.model.EmbeddedChart
-
The position of the chart.
- setPosition(TextPosition) - Method in class com.google.api.services.sheets.v4.model.KeyValueFormat
-
Specifies the horizontal text positioning of key value.
- setPosition(EmbeddedObjectPosition) - Method in class com.google.api.services.sheets.v4.model.Slicer
-
The position of the slicer.
- setPosition(EmbeddedObjectPosition) - Method in class com.google.api.services.sheets.v4.model.UpdateEmbeddedObjectPositionResponse
-
The new position of the embedded object.
- setPositiveColor(Color) - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Color to be used, in case baseline value represents a positive change for key value.
- setPositiveColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Color to be used, in case baseline value represents a positive change for key value.
- setPositiveColumnsStyle(WaterfallChartColumnStyle) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
Styles for all columns in this series with positive values.
- setPrefix(String) - Method in class com.google.api.services.sheets.v4.model.ChartCustomNumberFormatOptions
-
Custom prefix to be prepended to the chart attribute.
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setPrettyPrint(Boolean) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Returns response with indentations and line breaks.
- setPrimaryFontFamily(String) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetTheme
-
/ Name of the primary font family.
- setProperties(SheetProperties) - Method in class com.google.api.services.sheets.v4.model.AddSheetRequest
-
The properties the new sheet should have.
- setProperties(SheetProperties) - Method in class com.google.api.services.sheets.v4.model.AddSheetResponse
-
The properties of the newly added sheet.
- setProperties(SheetProperties) - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetResponse
-
The properties of the duplicate sheet.
- setProperties(SheetProperties) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The properties of the sheet.
- setProperties(SpreadsheetProperties) - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
Overall properties of a spreadsheet.
- setProperties(DimensionProperties) - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionPropertiesRequest
-
Properties to update.
- setProperties(SheetProperties) - Method in class com.google.api.services.sheets.v4.model.UpdateSheetPropertiesRequest
-
The properties to update.
- setProperties(SpreadsheetProperties) - Method in class com.google.api.services.sheets.v4.model.UpdateSpreadsheetPropertiesRequest
-
The properties to update.
- setProtectedRange(ProtectedRange) - Method in class com.google.api.services.sheets.v4.model.AddProtectedRangeRequest
-
The protected range to be added.
- setProtectedRange(ProtectedRange) - Method in class com.google.api.services.sheets.v4.model.AddProtectedRangeResponse
-
The newly added protected range.
- setProtectedRange(ProtectedRange) - Method in class com.google.api.services.sheets.v4.model.UpdateProtectedRangeRequest
-
The protected range to update with the new properties.
- setProtectedRangeId(Integer) - Method in class com.google.api.services.sheets.v4.model.DeleteProtectedRangeRequest
-
The ID of the protected range to delete.
- setProtectedRangeId(Integer) - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The ID of the protected range.
- setProtectedRanges(List<ProtectedRange>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The protected ranges in this sheet.
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setQuotaUser(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Available to use for quota purposes for server-side applications.
- setRandomizeRange(RandomizeRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Randomizes the order of the rows in a range.
- setRange(DimensionRange) - Method in class com.google.api.services.sheets.v4.model.AddDimensionGroupRequest
-
The range over which to create a group.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.AutoFillRequest
-
The range to autofill.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.BandedRange
-
The range over which these properties are applied.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.BasicFilter
-
The range the filter covers.
- setRange(DimensionRange) - Method in class com.google.api.services.sheets.v4.model.DeleteDimensionGroupRequest
-
The range of the group to be deleted.
- setRange(DimensionRange) - Method in class com.google.api.services.sheets.v4.model.DeleteDimensionRequest
-
The dimensions to delete from the sheet.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.DeleteDuplicatesRequest
-
The range to remove duplicates rows from.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.DeleteRangeRequest
-
The range of cells to delete.
- setRange(DimensionRange) - Method in class com.google.api.services.sheets.v4.model.DimensionGroup
-
The range over which this group exists.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The range this filter view covers.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
The range to find/replace over.
- setRange(DimensionRange) - Method in class com.google.api.services.sheets.v4.model.InsertDimensionRequest
-
The dimensions to insert.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.InsertRangeRequest
-
The range to insert new cells into.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.MergeCellsRequest
-
The range of cells to merge.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.NamedRange
-
The range this represents.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The range that is being protected.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.RandomizeRangeRequest
-
The range to randomize.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.RepeatCellRequest
-
The range to repeat the cell in.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.SetDataValidationRequest
-
The range the data validation rule should apply to.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.SortRangeRequest
-
The range to sort.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.TrimWhitespaceRequest
-
The range whose cells to trim.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.UnmergeCellsRequest
-
The range within which all cells should be unmerged.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The range whose borders should be updated.
- setRange(GridRange) - Method in class com.google.api.services.sheets.v4.model.UpdateCellsRequest
-
The range to write data to.
- setRange(DimensionRange) - Method in class com.google.api.services.sheets.v4.model.UpdateDimensionPropertiesRequest
-
The rows or columns to update.
- setRange(String) - Method in class com.google.api.services.sheets.v4.model.ValueRange
-
The range the values cover, in A1 notation.
- setRange(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
The A1 notation of a range to search for a logical table of data.
- setRange(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
The A1 notation of the values to clear.
- setRange(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
The A1 notation of the values to retrieve.
- setRange(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
The A1 notation of the values to update.
- setRanges(List<String>) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesRequest
-
The ranges to clear, in A1 notation.
- setRanges(List<GridRange>) - Method in class com.google.api.services.sheets.v4.model.ConditionalFormatRule
-
The ranges that are formatted if the condition is true.
- setRanges(List<String>) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
The ranges to retrieve from the spreadsheet.
- setRanges(List<String>) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
The A1 notation of the values to retrieve.
- setRed(Float) - Method in class com.google.api.services.sheets.v4.model.Color
-
The amount of red in the color as a value in the interval [0, 1].
- setRelativeDate(String) - Method in class com.google.api.services.sheets.v4.model.ConditionValue
-
A relative date (based on the current date).
- setRepeatCell(RepeatCellRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Repeats a single cell across a range.
- setRepeatHeadings(Boolean) - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
True if the headings in this pivot group should be repeated.
- setReplacement(String) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
The value to use as the replacement.
- setReplies(List<Response>) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetResponse
-
The reply of the updates.
- setRequestHeaders(HttpHeaders) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
- setRequestingUserCanEdit(Boolean) - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
True if the user who requested this protected range can edit the protected area.
- setRequests(List<Request>) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest
-
A list of updates to apply to the spreadsheet.
- setResponseDateTimeRenderOption(String) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
Determines how dates, times, and durations in the response should be rendered.
- setResponseDateTimeRenderOption(String) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
Determines how dates, times, and durations in the response should be rendered.
- setResponseDateTimeRenderOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
Determines how dates, times, and durations in the response should be rendered.
- setResponseDateTimeRenderOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
Determines how dates, times, and durations in the response should be rendered.
- setResponseIncludeGridData(Boolean) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest
-
True if grid data should be returned.
- setResponseRanges(List<String>) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetRequest
-
Limits the ranges included in the response spreadsheet.
- setResponses(List<UpdateValuesByDataFilterResponse>) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The response for each range updated.
- setResponses(List<UpdateValuesResponse>) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
One UpdateValuesResponse per requested range, in the same order as the requests appeared.
- setResponseValueRenderOption(String) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
Determines how values in the response should be rendered.
- setResponseValueRenderOption(String) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
Determines how values in the response should be rendered.
- setResponseValueRenderOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
Determines how values in the response should be rendered.
- setResponseValueRenderOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
Determines how values in the response should be rendered.
- setReversed(Boolean) - Method in class com.google.api.services.sheets.v4.model.BasicChartDomain
-
True to reverse the order of the domain values (horizontal axis).
- setReversed(Boolean) - Method in class com.google.api.services.sheets.v4.model.CandlestickDomain
-
True to reverse the order of the domain values (horizontal axis).
- setReversed(Boolean) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartDomain
-
True to reverse the order of the domain values (horizontal axis).
- setRgbColor(Color) - Method in class com.google.api.services.sheets.v4.model.ColorStyle
-
RGB color.
- setRight(Border) - Method in class com.google.api.services.sheets.v4.model.Borders
-
The right border of the cell.
- setRight(Integer) - Method in class com.google.api.services.sheets.v4.model.Padding
-
The right padding of the cell.
- setRight(Border) - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The border to put at the right of the range.
- setRightToLeft(Boolean) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
True if the sheet is an RTL sheet instead of an LTR sheet.
- setRootUrl(String) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setRowCount(Integer) - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
The number of rows in the grid.
- setRowData(List<RowData>) - Method in class com.google.api.services.sheets.v4.model.GridData
-
The data in the grid, one entry per row, starting with the row in startRow.
- setRowGroupControlAfter(Boolean) - Method in class com.google.api.services.sheets.v4.model.GridProperties
-
True if the row grouping control toggle is shown after the group.
- setRowGroups(List<DimensionGroup>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
All row groups on this sheet, ordered by increasing range start index, then by group depth.
- setRowIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.GridCoordinate
-
The row index of the coordinate.
- setRowMetadata(List<DimensionProperties>) - Method in class com.google.api.services.sheets.v4.model.GridData
-
Metadata about the requested rows in the grid, starting with the row in start_row.
- setRowProperties(BandingProperties) - Method in class com.google.api.services.sheets.v4.model.BandedRange
-
Properties for row bands.
- setRows(List<RowData>) - Method in class com.google.api.services.sheets.v4.model.AppendCellsRequest
-
The data to append.
- setRows(List<PivotGroup>) - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
Each row grouping in the pivot table.
- setRows(List<RowData>) - Method in class com.google.api.services.sheets.v4.model.UpdateCellsRequest
-
The data to write.
- setRowsChanged(Integer) - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of rows changed.
- setRule(ConditionalFormatRule) - Method in class com.google.api.services.sheets.v4.model.AddConditionalFormatRuleRequest
-
The rule to add.
- setRule(ConditionalFormatRule) - Method in class com.google.api.services.sheets.v4.model.DeleteConditionalFormatRuleResponse
-
The rule that was deleted.
- setRule(DataValidationRule) - Method in class com.google.api.services.sheets.v4.model.SetDataValidationRequest
-
The data validation rule to set on each cell in the range, or empty to clear the data
validation in the range.
- setRule(ConditionalFormatRule) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleRequest
-
The rule that should replace the rule at the given index.
- setScaleFactor(Double) - Method in class com.google.api.services.sheets.v4.model.ScorecardChartSpec
-
Value to scale scorecard key and baseline value.
- setScorecardChart(ScorecardChartSpec) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A scorecard chart specification.
- setSearchByRegex(Boolean) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
True if the find value is a regex.
- setSecondBandColor(Color) - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The second color that is alternating.
- setSecondBandColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.BandingProperties
-
The second color that is alternating.
- setSelectedNodeColor(Color) - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The color of the selected org chart nodes.
- setSelectedNodeColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The color of the selected org chart nodes.
- setSeries(ChartData) - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The data being visualized in this chart series.
- setSeries(List<BasicChartSeries>) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The data this chart is visualizing.
- setSeries(ChartData) - Method in class com.google.api.services.sheets.v4.model.BubbleChartSpec
-
The data contianing the bubble y-values.
- setSeries(List<HistogramSeries>) - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
The series for a histogram may be either a single series of values to be bucketed or multiple
series, each of the same length, containing the name of the series followed by the values to be
bucketed for that series.
- setSeries(ChartData) - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
The data that covers the one and only series of the pie chart.
- setSeries(List<WaterfallChartSeries>) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
The data this waterfall chart is visualizing.
- setServicePath(String) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setSetBasicFilter(SetBasicFilterRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Sets the basic filter on a sheet.
- setSetDataValidation(SetDataValidationRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Sets data validation for one or more cells.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.AppendCellsRequest
-
The sheet ID to append the data to.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.AppendDimensionRequest
-
The sheet to append rows or columns to.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.ClearBasicFilterRequest
-
The sheet ID on which the basic filter should be cleared.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.DeleteConditionalFormatRuleRequest
-
The sheet the rule is being deleted from.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.DeleteSheetRequest
-
The ID of the sheet to delete.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLocation
-
The ID of the sheet when metadata is associated with an entire sheet.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.DimensionRange
-
The sheet this span is on.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.EmbeddedObjectPosition
-
The sheet this is on.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.FindReplaceRequest
-
The sheet to find/replace over.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.GridCoordinate
-
The sheet this coordinate is on.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The sheet this range is on.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The ID of the sheet.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateConditionalFormatRuleRequest
-
The sheet of the rule to move.
- setSheetId(Integer) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
The ID of the sheet to copy.
- setSheets(List<Sheet>) - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The sheets that are part of a spreadsheet.
- setSheetsChanged(Integer) - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of sheets changed.
- setSheetsRequestInitializer(SheetsRequestInitializer) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setSheetType(String) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The type of sheet.
- setShiftDimension(String) - Method in class com.google.api.services.sheets.v4.model.DeleteRangeRequest
-
The dimension from which deleted cells will be replaced with.
- setShiftDimension(String) - Method in class com.google.api.services.sheets.v4.model.InsertRangeRequest
-
The dimension which will be shifted when inserting cells.
- setShowCustomUi(Boolean) - Method in class com.google.api.services.sheets.v4.model.DataValidationRule
-
True if the UI should be customized based on the kind of condition.
- setShowItemDividers(Boolean) - Method in class com.google.api.services.sheets.v4.model.HistogramChartSpec
-
Whether horizontal divider lines should be displayed between items in each column.
- setShowTotals(Boolean) - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
True if the pivot table should include the totals for this grouping.
- setSizeData(ChartData) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The data that determines the size of each treemap data cell.
- setSlicer(Slicer) - Method in class com.google.api.services.sheets.v4.model.AddSlicerRequest
-
The slicer that should be added to the spreadsheet, including the position where it should be
placed.
- setSlicer(Slicer) - Method in class com.google.api.services.sheets.v4.model.AddSlicerResponse
-
The newly added slicer.
- setSlicerId(Integer) - Method in class com.google.api.services.sheets.v4.model.Slicer
-
The ID of the slicer.
- setSlicerId(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateSlicerSpecRequest
-
The id of the slicer to update.
- setSlicers(List<Slicer>) - Method in class com.google.api.services.sheets.v4.model.Sheet
-
The slicers on this sheet.
- setSortOrder(String) - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The order the values in this group should be sorted.
- setSortOrder(String) - Method in class com.google.api.services.sheets.v4.model.SortSpec
-
The order data should be sorted.
- setSortRange(SortRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Sorts data in a range.
- setSortSpecs(List<SortSpec>) - Method in class com.google.api.services.sheets.v4.model.BasicFilter
-
The sort order per column.
- setSortSpecs(List<SortSpec>) - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The sort order per column.
- setSortSpecs(List<SortSpec>) - Method in class com.google.api.services.sheets.v4.model.SortRangeRequest
-
The sort order per column.
- setSource(GridRange) - Method in class com.google.api.services.sheets.v4.model.CopyPasteRequest
-
The source range to copy.
- setSource(GridRange) - Method in class com.google.api.services.sheets.v4.model.CutPasteRequest
-
The source data to cut.
- setSource(DimensionRange) - Method in class com.google.api.services.sheets.v4.model.MoveDimensionRequest
-
The source dimensions to move.
- setSource(GridRange) - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
The range the pivot table is reading data from.
- setSource(GridRange) - Method in class com.google.api.services.sheets.v4.model.SourceAndDestination
-
The location of the data to use as the source of the autofill.
- setSource(GridRange) - Method in class com.google.api.services.sheets.v4.model.TextToColumnsRequest
-
The source data range.
- setSourceAndDestination(SourceAndDestination) - Method in class com.google.api.services.sheets.v4.model.AutoFillRequest
-
The source and destination areas to autofill.
- setSourceColumnOffset(Integer) - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The column offset of the source range that this grouping is based on.
- setSourceColumnOffset(Integer) - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
The column offset of the source range that this value reads from.
- setSourceRange(ChartSourceRange) - Method in class com.google.api.services.sheets.v4.model.ChartData
-
The source ranges of the data.
- setSources(List<GridRange>) - Method in class com.google.api.services.sheets.v4.model.ChartSourceRange
-
The ranges of data for a series or domain.
- setSourceSheetId(Integer) - Method in class com.google.api.services.sheets.v4.model.DuplicateSheetRequest
-
The sheet to duplicate.
- setSpec(ChartSpec) - Method in class com.google.api.services.sheets.v4.model.EmbeddedChart
-
The specification of the chart.
- setSpec(SlicerSpec) - Method in class com.google.api.services.sheets.v4.model.Slicer
-
The specification of the slicer.
- setSpec(ChartSpec) - Method in class com.google.api.services.sheets.v4.model.UpdateChartSpecRequest
-
The specification to apply to the chart.
- setSpec(SlicerSpec) - Method in class com.google.api.services.sheets.v4.model.UpdateSlicerSpecRequest
-
The specification to apply to the slicer.
- setSpreadsheet(Boolean) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLocation
-
True when metadata is associated with an entire spreadsheet.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.AppendValuesResponse
-
The spreadsheet the updates were applied to.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesByDataFilterResponse
-
The spreadsheet the updates were applied to.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.BatchClearValuesResponse
-
The spreadsheet the updates were applied to.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterResponse
-
The ID of the spreadsheet the data was retrieved from.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesResponse
-
The ID of the spreadsheet the data was retrieved from.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetResponse
-
The spreadsheet the updates were applied to.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The spreadsheet the updates were applied to.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The spreadsheet the updates were applied to.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.ClearValuesResponse
-
The spreadsheet the updates were applied to.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The ID of the spreadsheet.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The spreadsheet the updates were applied to.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
The spreadsheet to apply the updates to.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
The ID of the spreadsheet to retrieve metadata from.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
The ID of the spreadsheet to retrieve metadata from.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
The spreadsheet to request.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
The spreadsheet to request.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
The ID of the spreadsheet containing the sheet to copy.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
The ID of the spreadsheet to update.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
The ID of the spreadsheet to update.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
The ID of the spreadsheet to update.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
The ID of the spreadsheet to retrieve data from.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
The ID of the spreadsheet to retrieve data from.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
The ID of the spreadsheet to update.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
The ID of the spreadsheet to update.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
The ID of the spreadsheet to update.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
The ID of the spreadsheet to retrieve data from.
- setSpreadsheetId(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
The ID of the spreadsheet to update.
- setSpreadsheetTheme(SpreadsheetTheme) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
Theme applied to the spreadsheet.
- setSpreadsheetUrl(String) - Method in class com.google.api.services.sheets.v4.model.Spreadsheet
-
The url of the spreadsheet.
- setStackedType(String) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
The stacked type for charts that support vertical stacking.
- setStackedType(String) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSpec
-
The stacked type.
- setStart(Double) - Method in class com.google.api.services.sheets.v4.model.HistogramRule
-
The minimum value at which items are placed into buckets of constant size.
- setStart(GridCoordinate) - Method in class com.google.api.services.sheets.v4.model.UpdateCellsRequest
-
The coordinate to start writing data at.
- setStartColumn(Integer) - Method in class com.google.api.services.sheets.v4.model.GridData
-
The first column this GridData refers to, zero-based.
- setStartColumnIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The start column (inclusive) of the range, or not set if unbounded.
- setStartIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.DimensionRange
-
The start (inclusive) of the span, or not set if unbounded.
- setStartIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.TextFormatRun
-
The character index where this run starts.
- setStartRow(Integer) - Method in class com.google.api.services.sheets.v4.model.GridData
-
The first row this GridData refers to, zero-based.
- setStartRowIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.GridRange
-
The start row (inclusive) of the range, or not set if unbounded.
- setStrict(Boolean) - Method in class com.google.api.services.sheets.v4.model.DataValidationRule
-
True if invalid data should be rejected.
- setStrikethrough(Boolean) - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
True if the text has a strikethrough.
- setStringValue(String) - Method in class com.google.api.services.sheets.v4.model.ExtendedValue
-
Represents a string value.
- setStyle(String) - Method in class com.google.api.services.sheets.v4.model.Border
-
The style of the border.
- setSubtitle(String) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The subtitle of the chart.
- setSubtitleTextFormat(TextFormat) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The subtitle text format.
- setSubtitleTextPosition(TextPosition) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The subtitle text position.
- setSubtotalColumnsStyle(WaterfallChartColumnStyle) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartSeries
-
Styles for all subtotal columns in this series.
- setSubtotalIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.WaterfallChartCustomSubtotal
-
The 0-based index of a data point within the series.
- setSuffix(String) - Method in class com.google.api.services.sheets.v4.model.ChartCustomNumberFormatOptions
-
Custom suffix to be appended to the chart attribute.
- setSummarizeFunction(String) - Method in class com.google.api.services.sheets.v4.model.PivotValue
-
A function to summarize the value.
- setSuppressAllChecks(boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setSuppressPatternChecks(boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setSuppressRequiredParameterChecks(boolean) - Method in class com.google.api.services.sheets.v4.Sheets.Builder
-
- setTabColor(Color) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The color of the tab in the UI.
- setTabColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The color of the tab in the UI.
- setTableRange(String) - Method in class com.google.api.services.sheets.v4.model.AppendValuesResponse
-
The range (in A1 notation) of the table that values are being appended to (before the values
were appended).
- setTargetAxis(String) - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The minor axis that will specify the range of values for this series.
- setTextDirection(String) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The direction of the text in the cell.
- setTextFormat(TextFormat) - Method in class com.google.api.services.sheets.v4.model.BaselineValueFormat
-
Text formatting options for baseline value.
- setTextFormat(TextFormat) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The format of the text in the cell (unless overridden by a format run).
- setTextFormat(TextFormat) - Method in class com.google.api.services.sheets.v4.model.KeyValueFormat
-
Text formatting options for key value.
- setTextFormat(TextFormat) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The text format of title in the slicer.
- setTextFormat(TextFormat) - Method in class com.google.api.services.sheets.v4.model.TreemapChartSpec
-
The text format for all labels on the chart.
- setTextFormatRuns(List<TextFormatRun>) - Method in class com.google.api.services.sheets.v4.model.CellData
-
Runs of rich text applied to subsections of the cell.
- setTextRotation(TextRotation) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The rotation applied to text in a cell
- setTextToColumns(TextToColumnsRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Converts a column of text into many columns of text.
- setThemeColor(String) - Method in class com.google.api.services.sheets.v4.model.ColorStyle
-
Theme color.
- setThemeColors(List<ThemeColorPair>) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetTheme
-
The spreadsheet theme color pairs.
- setThreeDimensional(Boolean) - Method in class com.google.api.services.sheets.v4.model.BasicChartSpec
-
True to make the chart 3D.
- setThreeDimensional(Boolean) - Method in class com.google.api.services.sheets.v4.model.PieChartSpec
-
True if the pie is three dimensional.
- setTimeZone(String) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The time zone of the spreadsheet, in CLDR format such as `America/New_York`.
- setTitle(String) - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The title of this axis.
- setTitle(String) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The title of the chart.
- setTitle(String) - Method in class com.google.api.services.sheets.v4.model.FilterView
-
The name of the filter view.
- setTitle(String) - Method in class com.google.api.services.sheets.v4.model.SheetProperties
-
The name of the sheet.
- setTitle(String) - Method in class com.google.api.services.sheets.v4.model.SlicerSpec
-
The title of the slicer.
- setTitle(String) - Method in class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
The title of the spreadsheet.
- setTitleTextFormat(TextFormat) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The title text format.
- setTitleTextPosition(TextPosition) - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The axis title text position.
- setTitleTextPosition(TextPosition) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
The title text position.
- setTooltips(ChartData) - Method in class com.google.api.services.sheets.v4.model.OrgChartSpec
-
The data containing the tooltip for the corresponding node.
- setTop(Border) - Method in class com.google.api.services.sheets.v4.model.Borders
-
The top border of the cell.
- setTop(Integer) - Method in class com.google.api.services.sheets.v4.model.Padding
-
The top padding of the cell.
- setTop(Border) - Method in class com.google.api.services.sheets.v4.model.UpdateBordersRequest
-
The border to put at the top of the range.
- setTotalUpdatedCells(Integer) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The total number of cells updated.
- setTotalUpdatedCells(Integer) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The total number of cells updated.
- setTotalUpdatedColumns(Integer) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The total number of columns where at least one cell in the column was updated.
- setTotalUpdatedColumns(Integer) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The total number of columns where at least one cell in the column was updated.
- setTotalUpdatedRows(Integer) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The total number of rows where at least one cell in the row was updated.
- setTotalUpdatedRows(Integer) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The total number of rows where at least one cell in the row was updated.
- setTotalUpdatedSheets(Integer) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterResponse
-
The total number of sheets where at least one cell in the sheet was updated.
- setTotalUpdatedSheets(Integer) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesResponse
-
The total number of sheets where at least one cell in the sheet was updated.
- setTreemapChart(TreemapChartSpec) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A treemap chart specification.
- setTrimWhitespace(TrimWhitespaceRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Trims cells of whitespace (such as spaces, tabs, or new lines).
- setTrimWhitespace(TrimWhitespaceResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from trimming whitespace.
- setType(String) - Method in class com.google.api.services.sheets.v4.model.BasicChartSeries
-
The type of this series.
- setType(String) - Method in class com.google.api.services.sheets.v4.model.BooleanCondition
-
The type of condition.
- setType(String) - Method in class com.google.api.services.sheets.v4.model.DateTimeRule
-
The type of date-time grouping to apply.
- setType(String) - Method in class com.google.api.services.sheets.v4.model.ErrorValue
-
The type of error.
- setType(String) - Method in class com.google.api.services.sheets.v4.model.InterpolationPoint
-
How the value should be interpreted.
- setType(String) - Method in class com.google.api.services.sheets.v4.model.LineStyle
-
The dash type of the line.
- setType(String) - Method in class com.google.api.services.sheets.v4.model.NumberFormat
-
The type of the number format.
- setType(String) - Method in class com.google.api.services.sheets.v4.model.PasteDataRequest
-
How the data should be pasted.
- setUnderline(Boolean) - Method in class com.google.api.services.sheets.v4.model.TextFormat
-
True if the text is underlined.
- setUnmergeCells(UnmergeCellsRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Unmerges merged cells.
- setUnprotectedRanges(List<GridRange>) - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
The list of unprotected ranges within a protected sheet.
- setUpdateBanding(UpdateBandingRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a banded range
- setUpdateBorders(UpdateBordersRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates the borders in a range of cells.
- setUpdateCells(UpdateCellsRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates many cells at once.
- setUpdateChartSpec(UpdateChartSpecRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a chart's specifications.
- setUpdateConditionalFormatRule(UpdateConditionalFormatRuleRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates an existing conditional format rule.
- setUpdateConditionalFormatRule(UpdateConditionalFormatRuleResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from updating a conditional format rule.
- setUpdatedCells(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The number of cells updated.
- setUpdatedCells(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The number of cells updated.
- setUpdatedColumns(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The number of columns where at least one cell in the column was updated.
- setUpdatedColumns(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The number of columns where at least one cell in the column was updated.
- setUpdatedData(ValueRange) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The values of the cells in the range matched by the dataFilter after all updates were applied.
- setUpdatedData(ValueRange) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The values of the cells after updates were applied.
- setUpdateDeveloperMetadata(UpdateDeveloperMetadataRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates an existing developer metadata entry
- setUpdateDeveloperMetadata(UpdateDeveloperMetadataResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from updating a developer metadata entry.
- setUpdateDimensionGroup(UpdateDimensionGroupRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates the state of the specified group.
- setUpdateDimensionProperties(UpdateDimensionPropertiesRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates dimensions' properties.
- setUpdatedRange(String) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The range (in A1 notation) that updates were applied to.
- setUpdatedRange(String) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The range (in A1 notation) that updates were applied to.
- setUpdatedRows(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesByDataFilterResponse
-
The number of rows where at least one cell in the row was updated.
- setUpdatedRows(Integer) - Method in class com.google.api.services.sheets.v4.model.UpdateValuesResponse
-
The number of rows where at least one cell in the row was updated.
- setUpdatedSpreadsheet(Spreadsheet) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateSpreadsheetResponse
-
The spreadsheet after updates were applied.
- setUpdateEmbeddedObjectPosition(UpdateEmbeddedObjectPositionRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates an embedded object's (e.g.
- setUpdateEmbeddedObjectPosition(UpdateEmbeddedObjectPositionResponse) - Method in class com.google.api.services.sheets.v4.model.Response
-
A reply from updating an embedded object's position.
- setUpdateFilterView(UpdateFilterViewRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates the properties of a filter view.
- setUpdateNamedRange(UpdateNamedRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a named range.
- setUpdateProtectedRange(UpdateProtectedRangeRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a protected range.
- setUpdates(UpdateValuesResponse) - Method in class com.google.api.services.sheets.v4.model.AppendValuesResponse
-
Information about the updates that were applied.
- setUpdateSheetProperties(UpdateSheetPropertiesRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a sheet's properties.
- setUpdateSlicerSpec(UpdateSlicerSpecRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates a slicer's specifications.
- setUpdateSpreadsheetProperties(UpdateSpreadsheetPropertiesRequest) - Method in class com.google.api.services.sheets.v4.model.Request
-
Updates the spreadsheet's properties.
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setUploadProtocol(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Upload protocol for media (e.g.
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.BatchUpdate
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Create
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Get
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.DeveloperMetadata.Search
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Get
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.GetByDataFilter
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations.CopyTo
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClear
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchClearByDataFilter
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGetByDataFilter
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdate
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchUpdateByDataFilter
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Clear
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
- setUploadType(String) - Method in class com.google.api.services.sheets.v4.SheetsRequest
-
Legacy upload protocol for media (e.g.
- setUseAlternateSeries(Boolean) - Method in class com.google.api.services.sheets.v4.model.AutoFillRequest
-
True if we should generate data with the "alternate" series.
- setUserEnteredFormat(CellFormat) - Method in class com.google.api.services.sheets.v4.model.CellData
-
The format the user entered for the cell.
- setUserEnteredValue(ExtendedValue) - Method in class com.google.api.services.sheets.v4.model.CellData
-
The value the user entered in the cell.
- setUserEnteredValue(String) - Method in class com.google.api.services.sheets.v4.model.ConditionValue
-
A value the condition is based on.
- setUsers(List<String>) - Method in class com.google.api.services.sheets.v4.model.Editors
-
The email addresses of users with edit access to the protected range.
- setValue(String) - Method in class com.google.api.services.sheets.v4.model.InterpolationPoint
-
The value this interpolation point uses.
- setValue(ExtendedValue) - Method in class com.google.api.services.sheets.v4.model.PivotGroupValueMetadata
-
The calculated value the metadata corresponds to.
- setValueBucket(PivotGroupSortValueBucket) - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
The bucket of the opposite pivot group to sort by.
- setValueInputOption(String) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesByDataFilterRequest
-
How the input data should be interpreted.
- setValueInputOption(String) - Method in class com.google.api.services.sheets.v4.model.BatchUpdateValuesRequest
-
How the input data should be interpreted.
- setValueInputOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Append
-
How the input data should be interpreted.
- setValueInputOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Update
-
How the input data should be interpreted.
- setValueLayout(String) - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
Whether values should be listed horizontally (as columns) or vertically (as rows).
- setValueMetadata(List<PivotGroupValueMetadata>) - Method in class com.google.api.services.sheets.v4.model.PivotGroup
-
Metadata about values in the grouping.
- setValueRange(ValueRange) - Method in class com.google.api.services.sheets.v4.model.MatchedValueRange
-
The values matched by the DataFilter.
- setValueRanges(List<MatchedValueRange>) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterResponse
-
The requested values with the list of data filters that matched them.
- setValueRanges(List<ValueRange>) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesResponse
-
The requested values.
- setValueRenderOption(String) - Method in class com.google.api.services.sheets.v4.model.BatchGetValuesByDataFilterRequest
-
How values should be represented in the output.
- setValueRenderOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.BatchGet
-
How values should be represented in the output.
- setValueRenderOption(String) - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets.Values.Get
-
How values should be represented in the output.
- setValues(List<ConditionValue>) - Method in class com.google.api.services.sheets.v4.model.BooleanCondition
-
The values of the condition.
- setValues(List<List<Object>>) - Method in class com.google.api.services.sheets.v4.model.DataFilterValueRange
-
The data to be written.
- setValues(List<PivotValue>) - Method in class com.google.api.services.sheets.v4.model.PivotTable
-
A list of values to include in the pivot table.
- setValues(List<CellData>) - Method in class com.google.api.services.sheets.v4.model.RowData
-
The values in the row, one per column.
- setValues(List<List<Object>>) - Method in class com.google.api.services.sheets.v4.model.ValueRange
-
The data that was read or to be written.
- setValuesChanged(Integer) - Method in class com.google.api.services.sheets.v4.model.FindReplaceResponse
-
The number of non-formula cells changed.
- setValuesIndex(Integer) - Method in class com.google.api.services.sheets.v4.model.PivotGroupSortValueBucket
-
The offset in the PivotTable.values list which the values in this grouping should be sorted by.
- setVertical(Boolean) - Method in class com.google.api.services.sheets.v4.model.TextRotation
-
If true, text reads top to bottom, but the orientation of individual characters is unchanged.
- setVerticalAlignment(String) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The vertical alignment of the value in the cell.
- setViewWindowMax(Double) - Method in class com.google.api.services.sheets.v4.model.ChartAxisViewWindowOptions
-
The maximum numeric value to be shown in this view window.
- setViewWindowMin(Double) - Method in class com.google.api.services.sheets.v4.model.ChartAxisViewWindowOptions
-
The minimum numeric value to be shown in this view window.
- setViewWindowMode(String) - Method in class com.google.api.services.sheets.v4.model.ChartAxisViewWindowOptions
-
The view window's mode.
- setViewWindowOptions(ChartAxisViewWindowOptions) - Method in class com.google.api.services.sheets.v4.model.BasicChartAxis
-
The view window options for this axis.
- setVisibility(String) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadata
-
The metadata visibility.
- setVisibility(String) - Method in class com.google.api.services.sheets.v4.model.DeveloperMetadataLookup
-
Limits the selected developer metadata to that which has a matching
DeveloperMetadata.visibility.
- setVisibleBackgroundColor(Color) - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
The background fill color to filter by; only cells with this fill color are shown.
- setVisibleBackgroundColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
The background fill color to filter by; only cells with this fill color are shown.
- setVisibleForegroundColor(Color) - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
The foreground color to filter by; only cells with this foreground color are shown.
- setVisibleForegroundColorStyle(ColorStyle) - Method in class com.google.api.services.sheets.v4.model.FilterCriteria
-
The foreground color to filter by; only cells with this foreground color are shown.
- setVisibleValues(List<String>) - Method in class com.google.api.services.sheets.v4.model.PivotFilterCriteria
-
Values that should be included.
- setWarningOnly(Boolean) - Method in class com.google.api.services.sheets.v4.model.ProtectedRange
-
True if this protected range will show a warning when editing.
- setWaterfallChart(WaterfallChartSpec) - Method in class com.google.api.services.sheets.v4.model.ChartSpec
-
A waterfall chart specification.
- setWidth(Integer) - Method in class com.google.api.services.sheets.v4.model.Border
-
The width of the border, in pixels.
- setWidth(Integer) - Method in class com.google.api.services.sheets.v4.model.LineStyle
-
The thickness of the line, in px.
- setWidthPixels(Integer) - Method in class com.google.api.services.sheets.v4.model.OverlayPosition
-
The width of the object, in pixels.
- setWrapStrategy(String) - Method in class com.google.api.services.sheets.v4.model.CellFormat
-
The wrap strategy for the value in the cell.
- Sheet - Class in com.google.api.services.sheets.v4.model
-
A sheet in a spreadsheet.
- Sheet() - Constructor for class com.google.api.services.sheets.v4.model.Sheet
-
- SheetProperties - Class in com.google.api.services.sheets.v4.model
-
Properties of a sheet.
- SheetProperties() - Constructor for class com.google.api.services.sheets.v4.model.SheetProperties
-
- Sheets - Class in com.google.api.services.sheets.v4
-
Service definition for Sheets (v4).
- Sheets(HttpTransport, JsonFactory, HttpRequestInitializer) - Constructor for class com.google.api.services.sheets.v4.Sheets
-
Constructor.
- sheets() - Method in class com.google.api.services.sheets.v4.Sheets.Spreadsheets
-
An accessor for creating requests from the SheetsOperations collection.
- Sheets.Builder - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets - Class in com.google.api.services.sheets.v4
-
The "spreadsheets" collection of methods.
- Sheets.Spreadsheets.BatchUpdate - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Create - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.DeveloperMetadata - Class in com.google.api.services.sheets.v4
-
The "developerMetadata" collection of methods.
- Sheets.Spreadsheets.DeveloperMetadata.Get - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.DeveloperMetadata.Search - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Get - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.GetByDataFilter - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.SheetsOperations - Class in com.google.api.services.sheets.v4
-
The "sheets" collection of methods.
- Sheets.Spreadsheets.SheetsOperations.CopyTo - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values - Class in com.google.api.services.sheets.v4
-
The "values" collection of methods.
- Sheets.Spreadsheets.Values.Append - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values.BatchClear - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values.BatchClearByDataFilter - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values.BatchGet - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values.BatchGetByDataFilter - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values.BatchUpdate - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values.BatchUpdateByDataFilter - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values.Clear - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values.Get - Class in com.google.api.services.sheets.v4
-
- Sheets.Spreadsheets.Values.Update - Class in com.google.api.services.sheets.v4
-
- SheetsOperations() - Constructor for class com.google.api.services.sheets.v4.Sheets.Spreadsheets.SheetsOperations
-
- SheetsRequest<T> - Class in com.google.api.services.sheets.v4
-
Sheets request.
- SheetsRequest(Sheets, String, String, Object, Class<T>) - Constructor for class com.google.api.services.sheets.v4.SheetsRequest
-
- SheetsRequestInitializer - Class in com.google.api.services.sheets.v4
-
Sheets request initializer for setting properties like key and userIp.
- SheetsRequestInitializer() - Constructor for class com.google.api.services.sheets.v4.SheetsRequestInitializer
-
- SheetsRequestInitializer(String) - Constructor for class com.google.api.services.sheets.v4.SheetsRequestInitializer
-
- SheetsRequestInitializer(String, String) - Constructor for class com.google.api.services.sheets.v4.SheetsRequestInitializer
-
- SheetsScopes - Class in com.google.api.services.sheets.v4
-
Available OAuth 2.0 scopes for use with the Google Sheets API.
- Slicer - Class in com.google.api.services.sheets.v4.model
-
A slicer in a sheet.
- Slicer() - Constructor for class com.google.api.services.sheets.v4.model.Slicer
-
- SlicerSpec - Class in com.google.api.services.sheets.v4.model
-
The specifications of a slicer.
- SlicerSpec() - Constructor for class com.google.api.services.sheets.v4.model.SlicerSpec
-
- SortRangeRequest - Class in com.google.api.services.sheets.v4.model
-
Sorts data in rows based on a sort order per column.
- SortRangeRequest() - Constructor for class com.google.api.services.sheets.v4.model.SortRangeRequest
-
- SortSpec - Class in com.google.api.services.sheets.v4.model
-
A sort order associated with a specific column or row.
- SortSpec() - Constructor for class com.google.api.services.sheets.v4.model.SortSpec
-
- SourceAndDestination - Class in com.google.api.services.sheets.v4.model
-
A combination of a source range and how to extend that source.
- SourceAndDestination() - Constructor for class com.google.api.services.sheets.v4.model.SourceAndDestination
-
- Spreadsheet - Class in com.google.api.services.sheets.v4.model
-
Resource that represents a spreadsheet.
- Spreadsheet() - Constructor for class com.google.api.services.sheets.v4.model.Spreadsheet
-
- SpreadsheetProperties - Class in com.google.api.services.sheets.v4.model
-
Properties of a spreadsheet.
- SpreadsheetProperties() - Constructor for class com.google.api.services.sheets.v4.model.SpreadsheetProperties
-
- spreadsheets() - Method in class com.google.api.services.sheets.v4.Sheets
-
An accessor for creating requests from the Spreadsheets collection.
- Spreadsheets() - Constructor for class com.google.api.services.sheets.v4.Sheets.Spreadsheets
-
- SPREADSHEETS - Static variable in class com.google.api.services.sheets.v4.SheetsScopes
-
See, edit, create, and delete your spreadsheets in Google Drive.
- SPREADSHEETS_READONLY - Static variable in class com.google.api.services.sheets.v4.SheetsScopes
-
View your Google Spreadsheets.
- SpreadsheetTheme - Class in com.google.api.services.sheets.v4.model
-
Represents spreadsheet theme
- SpreadsheetTheme() - Constructor for class com.google.api.services.sheets.v4.model.SpreadsheetTheme
-
