fillDate Method

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.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance = new GcSpread.Sheets.Sheet(name);
var value; // Type: any
value = instance.fillDate(startRange, wholeRange, series, unit, step, stop);

function fillDate( 
   startRange : Range,
   wholeRange : Range,
   series : FillSeries,
   unit : FillDateUnit,
   step : number,
   stop : Date
) : any;

Parameters

startRange: The fill start range.
wholeRange: The fill range.
series: The fill series.
unit: The fill date unit.
step: The fill date step value.
stop: Stops when the fill value exceeds the stop value.

Example

This example uses the fillDate method.

Javascript

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

Reference

Sheet type