Enumeration: AutoFillType

Sheets.Fill.AutoFillType

Represents the type of drag fill.

example

//This example uses the AutoFillType enumeration.
console.log(spread.options.defaultDragFillType); // equals to GC.Spread.Sheets.Fill.AutoFillType.auto
spread.options.defaultDragFillType = GC.Spread.Sheets.Fill.AutoFillType.copyCells;

Table of contents

Enumeration members

• auto
• clearValues
• copyCells
• fillFormattingOnly
• fillSeries
• fillWithoutFormatting

Enumeration members

auto

• auto = 5

Automatically fills cells.

clearValues

• clearValues = 4

Clears cell values.

copyCells

• copyCells = 0

Fills cells with all data objects, including values, formatting, and formulas.

fillFormattingOnly

• fillFormattingOnly = 2

Fills cells only with formatting.

fillSeries

• fillSeries = 1

Fills cells with series.

fillWithoutFormatting

• fillWithoutFormatting = 3

Fills cells with values and not formatting.