ExcelAutoFillType Class

Specifies the options for autofill

Inheritance

System.Object

ExcelAutoFillType

Namespace: Syncfusion.XlsIO

Assembly: Syncfusion.XlsIO.Base.dll

Syntax

public sealed class ExcelAutoFillType : Enum

Fields

FillCopy

Copies values and formatting from the source range to the destination range without modification.

Declaration

public const ExcelAutoFillType FillCopy

Field Value

Type
ExcelAutoFillType

FillDays

Uses a sequence of dates based on the source range to fill the destination range, incrementing by days.

Declaration

public const ExcelAutoFillType FillDays

Field Value

Type
ExcelAutoFillType

FillDefault

Uses default values based on the content and formatting of the source range to fill the destination range.

Declaration

public const ExcelAutoFillType FillDefault

Field Value

Type
ExcelAutoFillType

FillFormats

Copies only formatting from the source range to fill the destination range.

Declaration

public const ExcelAutoFillType FillFormats

Field Value

Type
ExcelAutoFillType

FillMonths

Uses a sequence of dates based on the source range to fill the destination range, incrementing by months.

Declaration

public const ExcelAutoFillType FillMonths

Field Value

Type
ExcelAutoFillType

FillSeries

Uses a sequence of values from the source range to populate the destination range.

Declaration

public const ExcelAutoFillType FillSeries

Field Value

Type
ExcelAutoFillType

FillValues

Copies only values from the source range to fill the destination range.

Declaration

public const ExcelAutoFillType FillValues

Field Value

Type
ExcelAutoFillType

FillWeekdays

Uses a sequence of dates based on the source range to fill the destination range, incrementing by weekdays (Monday-Friday).

Declaration

public const ExcelAutoFillType FillWeekdays

Field Value

Type
ExcelAutoFillType

FillYears

Uses a sequence of dates based on the source range to fill the destination range, incrementing by years.

Declaration

public const ExcelAutoFillType FillYears

Field Value

Type
ExcelAutoFillType

GrowthTrend

Specifies that the destination range is filled with values following an exponential growth pattern derived from the source data.

Declaration

public const ExcelAutoFillType GrowthTrend

Field Value

Type
ExcelAutoFillType

LinearTrend

Specifies that the destination range is filled with values following a linear progression based on the source data.

Declaration

public const ExcelAutoFillType LinearTrend

Field Value

Type
ExcelAutoFillType