Stay organized with collections
Save and categorize content based on your preferences.
AutoFillSeries
An enumeration of the types of series used to calculate auto-filled values. The manner in which
these series affect calculated values differs depending on the type and amount of source data.
To call an enum, you call its parent class, name, and property. For example,
SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES.
Properties
Property
Type
Description
DEFAULT_SERIES
Enum
Default. Auto-filling with this setting results in the empty cells in the expanded range being
filled with increments of the existing values.
ALTERNATE_SERIES
Enum
Auto-filling with this setting results in the empty cells in the expanded range being filled
with copies of the existing values.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-10-31 UTC."],[[["`AutoFillSeries` is used to determine how values are automatically filled in Google Sheets."],["It offers two options: `DEFAULT_SERIES` which fills cells with incremental values based on existing data, and `ALTERNATE_SERIES` which copies existing values to fill the range."],["To use `AutoFillSeries`, call its parent class, name, and property, such as `SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES`."]]],[]]