AutoFillType Enumeration

In This Topic

Specifies how the target range is to be filled, based on the contents of the source range.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum AutoFillType 
   Inherits System.Enum

'Usage
 
Dim instance As AutoFillType

public enum AutoFillType : System.Enum

Members

Member	Description
FillCopy	Copy the values and formats from the source range to the target range, repeating if necessary.
FillDays	Extend the names of the days of the week in the source range into the target range. Formats are copied from the source range to the target range, repeating if necessary.
FillFormats	Copy only the formats from the source range to the target range, repeating if necessary.
FillMonths	Extend the names of the months in the source range into the target range. Formats are copied from the source range to the target range, repeating if necessary.
FillSeries	Extend the values in the source range into the target range as a series (for example, '1, 2' is extended as '3, 4, 5'). Formats are copied from the source range to the target range, repeating if necessary.
FillValues	Copy only the values from the source range to the target range, repeating if necessary.
FillValueSeries	Extend the values only in the source range into the target range as a series (for example, '1, 2' is extended as '3, 4, 5').
FillWeekdays	Extend the names of the days of the workweek in the source range into the target range. Formats are copied from the source range to the target range, repeating if necessary.
FillYears	Extend the years in the source range into the target range. Formats are copied from the source range to the target range, repeating if necessary.
GrowthTrend	Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers in the source range are multiplicative (for example, '1, 2,' is extended as '4, 8, 16', assuming that each number is a result of multiplying the previous number by some value). Formats are copied from the source range to the target range, repeating if necessary.
LinearTrend	Extend the numeric values from the source range into the target range, assuming that the relationships between the numbers is additive (for example, '1, 2,' is extended as '3, 4, 5', assuming that each number is a result of adding some value to the previous number). Formats are copied from the source range to the target range, repeating if necessary.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Spreadsheet.AutoFillType

Reference

GrapeCity.Spreadsheet Namespace