SpreadsheetGear 2017
DataSeries Method (IRange)






SpreadsheetGear Namespace > IRange Interface : DataSeries Method
Specifies that this method should fill down if true or fill across if false.
Specifies the type of fill to perform.
Specifies the type of date operation to be performed when DataSeriesType.Chronological is used.
Specifies the amount to increment by.
Specifies the value to stop at; use double.PositiveInfinity to fill the entire range.
Specifies that the existing data should be analysed and new data generated from the resulting curve if true, or that a standard fill should be performed if false.
Fill this range with a data series based on the specified type and options.
Syntax
'Declaration
 
Sub DataSeries( _
   ByVal fillDown As System.Boolean, _
   ByVal type As DataSeriesType, _
   ByVal date As DataSeriesDate, _
   ByVal step As System.Double, _
   ByVal stop As System.Double, _
   ByVal trend As System.Boolean _
) 
'Usage
 
Dim instance As IRange
Dim fillDown As System.Boolean
Dim type As DataSeriesType
Dim date As DataSeriesDate
Dim step As System.Double
Dim stop As System.Double
Dim trend As System.Boolean
 
instance.DataSeries(fillDown, type, date, step, stop, trend)
void DataSeries( 
   System.bool fillDown,
   DataSeriesType type,
   DataSeriesDate date,
   System.double step,
   System.double stop,
   System.bool trend
)
procedure DataSeries( 
    fillDown: System.Boolean;
    type: DataSeriesType;
    date: DataSeriesDate;
    step: System.Double;
    stop: System.Double;
    trend: System.Boolean
); 
function DataSeries( 
   fillDown : System.boolean,
   type : DataSeriesType,
   date : DataSeriesDate,
   step : System.double,
   stop : System.double,
   trend : System.boolean
);
void DataSeries( 
   System.bool fillDown,
   DataSeriesType type,
   DataSeriesDate date,
   System.double step,
   System.double stop,
   System.bool trend
) 
void DataSeries( 
   System.bool fillDown,
   DataSeriesType type,
   DataSeriesDate date,
   System.double step,
   System.double stop,
   System.bool trend
) 

Parameters

fillDown
Specifies that this method should fill down if true or fill across if false.
type
Specifies the type of fill to perform.
date
Specifies the type of date operation to be performed when DataSeriesType.Chronological is used.
step
Specifies the amount to increment by.
stop
Specifies the value to stop at; use double.PositiveInfinity to fill the entire range.
trend
Specifies that the existing data should be analysed and new data generated from the resulting curve if true, or that a standard fill should be performed if false.
Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

Reference

IRange Interface
IRange Members