SpreadJS Documentation
fillGrowth Method
The fill start range.
The range to fill.
The fill series.
The fill step value.
The fill stop value.
Fills the specified range 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.
Syntax
var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.fillGrowth(startRange, wholeRange, series, step, stop);
function fillGrowth( 
   startRange : Range,
   wholeRange : Range,
   series : FillSeries,
   step : number,
   stop : number
) : any;

Parameters

startRange
The fill start range.
wholeRange
The range to fill.
series
The fill series.
step
The fill step value.
stop
The fill stop value.
Example
This example uses the fillGrowth method.
sheet.setValue(0, 0, new Date(2011, 1, 1));
sheet.setValue(0, 1, new Date(2011, 2, 9));
sheet.setValue(0, 2, 5);
sheet.setValue(0, 3, 10);
sheet.setValue(0, 4, 1);
var start = new GcSpread.Sheets.Range(0, 0, 1, 1);
var r = new GcSpread.Sheets.Range(0, 0, 4, 1);
sheet.fillDate(start,r, GcSpread.Sheets.FillSeries.Column,GcSpread.Sheets.FillDateUnit.Day, 2);
start = new GcSpread.Sheets.Range(0, 1, 1, 1);
var r2 = new GcSpread.Sheets.Range(0, 1, 4, 1);
sheet.fillDate(start,r2, GcSpread.Sheets.FillSeries.Column, GcSpread.Sheets.FillDateUnit.Day, 1, new Date(2011, 2, 11));
start = new GcSpread.Sheets.Range(0, 2, 1, 1);
var r3 = new GcSpread.Sheets.Range(0, 2, 4, 1);
sheet.fillAuto(start,r3, GcSpread.Sheets.FillSeries.Column);
start = new GcSpread.Sheets.Range(0, 3, 1, 1);
var r4 = new GcSpread.Sheets.Range(0, 3, 4, 1);
sheet.fillGrowth(start,r4, GcSpread.Sheets.FillSeries.Column, 2, 55);
start = new GcSpread.Sheets.Range(0, 4, 1, 1);
var r5 = new GcSpread.Sheets.Range(0, 4, 4, 1);
sheet.fillLinear(start,r5, GcSpread.Sheets.FillSeries.Column, 3, 20);
See Also

Reference

Sheet type

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.