fillAutobyDirection Method

Fills the specified range in the specified direction.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.fillAutobyDirection(startRange, wholeRange, direction);

function fillAutobyDirection( 
   startRange : Range,
   wholeRange : Range,
   direction : FillDirection
) : any;

Parameters

startRange: The fill start range.
wholeRange: The entire range to fill.
direction: The fill direction.

Example

This example uses the fillAutobyDirection method.

Javascript

var start = new GcSpread.Sheets.Range(0, 2, 1, 1);
activeSheet.setValue(0, 2, 5);
var r3 = new GcSpread.Sheets.Range(0, 2, 4, 1);
activeSheet.fillAutobyDirection(start, r3, GcSpread.Sheets.FillDirection.Down);

Reference

Sheet type