Spread Windows Forms 15.0
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / AutoFillType Enumeration


In This Topic
    AutoFillType Enumeration
    In This Topic
    Specifies how the target range is to be filled, based on the contents of the source range.
    Syntax
    'Declaration
     
    
    Public Enum AutoFillType 
       Inherits System.Enum
    'Usage
     
    
    Dim instance As AutoFillType
    public enum AutoFillType : System.Enum 
    Members
    MemberDescription
    FillCopyCopy the values and formats from the source range to the target range, repeating if necessary.
    FillDaysExtend 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.
    FillFormatsCopy only the formats from the source range to the target range, repeating if necessary.
    FillMonthsExtend 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.
    FillSeriesExtend 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.
    FillValuesCopy only the values from the source range to the target range, repeating if necessary.
    FillValueSeriesExtend the values only in the source range into the target range as a series (for example, '1, 2' is extended as '3, 4, 5').
    FillWeekdaysExtend 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.
    FillYearsExtend the years in the source range into the target range. Formats are copied from the source range to the target range, repeating if necessary.
    GrowthTrendExtend 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.
    LinearTrendExtend 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

    See Also