SpreadJS 14
GC.Spread.Sheets.Fill Namespace / FillDirection Enumeration
In This Topic
    FillDirection Enumeration
    In This Topic
    Represents the type of drag fill direction.
    downFills from the top to the bottom.
    leftFills from the right to the left.
    rightFills from the left to the right.
    upFills from the bottom to the top.
    This example uses the FillDirection type.
    var start = new GC.Spread.Sheets.Range(0, 2, 1, 1);
    activeSheet.setValue(0, 2, 5);
    var r3 = new GC.Spread.Sheets.Range(0, 2, 4, 1);
    activeSheet.fillAuto(start, r3, {fillType: GC.Spread.Sheets.Fill.FillType.auto, fillDirection:GC.Spread.Sheets.Fill.FillDirection.down, series: GC.Spread.Sheets.Fill.FillSeries.column});
    This example automatically fills the data in an area of the sheet.
    activeSheet.setValue(0, 0, 5);
    var start = new GC.Spread.Sheets.Range(0, 0, 1, 1);
    var r3 = new GC.Spread.Sheets.Range(0, 0, 4, 1);
    activeSheet.fillAuto(start,r3, {fillType:GC.Spread.Sheets.Fill.FillType.auto, series:GC.Spread.Sheets.Fill.FillSeries.column, fillDirection:GC.Spread.Sheets.Fill.FillDirection.down});
    Inheritance Hierarchy


    See Also