fillAuto Method

The range fill information.
options.fillType {GC.Spread.Sheets.Fill.FillType} fillType Specifies how to fill the specified range.
GC.Spread.Sheets.Fill.FillType.direction:
Fills the specified range in the specified direction.
GC.Spread.Sheets.Fill.FillType.linear:
Fills the specified range using a linear trend when the source value type is number.
The next value is generated by the step and stop values.
The next value is computed by adding the step value to the current cell value.
GC.Spread.Sheets.Fill.FillType.growth:
Fills the specified range using a growth trend when the source value type is number.
The next value is generated by the step and stop values.
The next value is computed by multiplying the step value with the current cell.
GC.Spread.Sheets.Fill.FillType.date:
Fills the specified range when the source value type is date.
The next value is generated by adding the step value to the current value.
The step value is affected by the fill date unit.
GC.Spread.Sheets.Fill.FillType.auto:
Fills the specified range automatically.
When the value is a string, the value is copied to other cells.
When the value is a number, the new value is generated by the TREND formula.
options.series {GC.Spread.Sheets.Fill.FillSeries} series The fill series.
options.direction {GC.Spread.Sheets.Fill.FillDirection} direction The fill direction.
options.step {number} step The fill step value.
options.stop {number|Date} stop The fill stop value.
options.unit {GC.Spread.Sheets.Fill.FillDateUnit} unit The fill date unit.

Fills the specified range automatically.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GC.Spread.Sheets.Worksheet(name);
var value; // Type: any
value = instance.fillAuto(startRange, wholeRange, options);

function fillAuto( 
   startRange : Range,
   wholeRange : Range,
   options : object
) : any;

Parameters

startRange: The fill start range.
wholeRange: The entire range to fill.
options: The range fill information.
options.fillType {GC.Spread.Sheets.Fill.FillType} fillType Specifies how to fill the specified range.
GC.Spread.Sheets.Fill.FillType.direction:
Fills the specified range in the specified direction.
GC.Spread.Sheets.Fill.FillType.linear:
Fills the specified range using a linear trend when the source value type is number.
The next value is generated by the step and stop values.
The next value is computed by adding the step value to the current cell value.
GC.Spread.Sheets.Fill.FillType.growth:
Fills the specified range using a growth trend when the source value type is number.
The next value is generated by the step and stop values.
The next value is computed by multiplying the step value with the current cell.
GC.Spread.Sheets.Fill.FillType.date:
Fills the specified range when the source value type is date.
The next value is generated by adding the step value to the current value.
The step value is affected by the fill date unit.
GC.Spread.Sheets.Fill.FillType.auto:
Fills the specified range automatically.
When the value is a string, the value is copied to other cells.
When the value is a number, the new value is generated by the TREND formula.
options.series {GC.Spread.Sheets.Fill.FillSeries} series The fill series.
options.direction {GC.Spread.Sheets.Fill.FillDirection} direction The fill direction.
options.step {number} step The fill step value.
options.stop {number|Date} stop The fill stop value.
options.unit {GC.Spread.Sheets.Fill.FillDateUnit} unit The fill date unit.

Example

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});

This example automatically fills ranges.

Javascript

spread.options.allowUserDragFill = true;

activeSheet.setValue(0, 0, new Date(2011, 1, 1));
activeSheet.setValue(0, 1, new Date(2011, 2, 9));
activeSheet.setValue(0, 2, 5);
activeSheet.setValue(0, 3, 10);
activeSheet.setValue(0, 4, 1);

var start = new GC.Spread.Sheets.Range(0, 0, 1, 1);
var r = new GC.Spread.Sheets.Range(0, 0, 4, 1);
activeSheet.fillAuto(start, r, {
    fillType: GC.Spread.Sheets.Fill.FillType.date,
    series: GC.Spread.Sheets.Fill.FillSeries.column,
    fillDirection: GC.Spread.Sheets.Fill.FillDirection.down,
    unit: GC.Spread.Sheets.Fill.FillDateUnit.day,
    step: 1,
    stop: new Date(2011, 2, 11)
});

start = new GC.Spread.Sheets.Range(0, 1, 1, 1);
var r2 = new GC.Spread.Sheets.Range(0, 1, 4, 1);
activeSheet.fillAuto(start, r2, {
fillType: GC.Spread.Sheets.Fill.FillType.date,
series: GC.Spread.Sheets.Fill.FillSeries.column,
fillDirection:GC.Spread.Sheets.Fill.FillDirection.down,
unit: GC.Spread.Sheets.Fill.FillDateUnit.day,
step: 1,
stop: new Date(2011, 2, 11)
});

start = new GC.Spread.Sheets.Range(0, 2, 1, 1);
var r3 = new GC.Spread.Sheets.Range(0, 2, 4, 1);
activeSheet.fillAuto(start, r3, {
    fillType: GC.Spread.Sheets.Fill.FillType.auto,
    series: GC.Spread.Sheets.Fill.FillSeries.column,
});

start = new GC.Spread.Sheets.Range(0, 3, 1, 1);
var r4 = new GC.Spread.Sheets.Range(0, 3, 4, 1);
activeSheet.fillAuto(start, r4, {
    fillType: GC.Spread.Sheets.Fill.FillType.growth,
    series: GC.Spread.Sheets.Fill.FillSeries.column,
    step:2,
    stop:55
});

start = new GC.Spread.Sheets.Range(0, 4, 1, 1);
var r5 = new GC.Spread.Sheets.Range(0, 4, 4, 1);
activeSheet.fillAuto(start, r5, {
    fillType: GC.Spread.Sheets.Fill.FillType.linear,
    series: GC.Spread.Sheets.Fill.FillSeries.column,
    step:3,
    stop:20
});

activeSheet.setValue(0, 5, 123);
var r6 = new GC.Spread.Sheets.Range(0, 5, 4, 1);
activeSheet.fillAuto(new GC.Spread.Sheets.Range(0, 5, 1, 1), r6, {
    fillType: GC.Spread.Sheets.Fill.FillType.auto,
    series: GC.Spread.Sheets.Fill.FillSeries.column,
});

Reference

Worksheet type