Module fill 

Fill: copy, AutoFill series (numbers, dates, weekdays, months, text with numbers, custom lists), Series dialog and Flash Fill.

Structs

SeriesOptions

Options for filling a numeric or date series.

Enums

DateUnit

The step of a FillMode::Dates fill.

FillMode

Constants

MAX_FILL_CELLS

The most cells one fill may write: the size cap the fill commands put on their ranges.

Functions

fill

Fills target (which contains src at one edge) from the pattern in src.

flash_fill

Flash Fill: learns a transformation from the examples typed in the column of at (rows above it with values) from the column(s) to the left, and fills the remaining rows. Supported transformations: a token (word) of the source by index, concatenations of tokens with literal separators, upper/lower/proper case, and fixed-position substrings.

holds_source_in_corner

Whether target is a shape Excel’s AutoFill accepts for src: it contains the source and the source sits in one of its corners. Excel refuses a target that doesn’t contain the source (2:3 into A:A, H4:H9 into D:F) or holds it away from every corner (H4:H9 into H:H).

series

Home › Fill › Series.

starts_with_date

Whether the first cell of src holds a date, so a fill from it can step by days, weekdays, months or years: a number (not a formula) shown in a date format.