'Declaration Public Enum AutoFillType Inherits System.Enum
'Usage Dim instance As AutoFillType
public enum AutoFillType : System.Enum
'Declaration Public Enum AutoFillType Inherits System.Enum
'Usage Dim instance As AutoFillType
public enum AutoFillType : System.Enum
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. |
System.Object
System.ValueType
System.Enum
GrapeCity.Spreadsheet.AutoFillType