FillDirection Enumeration

Represents the type of drag fill direction.

Members

Member	Description
down	Fills from the top to the bottom.
left	Fills from the right to the left.
right	Fills from the left to the right.
up	Fills from the bottom to the top.

Example

This example uses the FillDirection type.

Javascript

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.

Javascript

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

Object
GC.Spread.Sheets.Fill.FillDirection

Reference

GC.Spread.Sheets.Fill Namespace