Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / WorksheetFunction Class
Methods


In This Topic
    WorksheetFunction Class Members
    In This Topic

    The following tables list the members exposed by WorksheetFunction.

    Public Methods
     NameDescription
    Public Methodstatic (Shared in Visual Basic)CreateExpressionCreates an expression from the specified primitive value.  
    Public MethodGrowthCalculates predicted exponential growth by using existing data. GROWTH returns the y-values for a series of new x-values that you specify by using existing x-values and y-values. You can also use the GROWTH worksheet function to fit an exponential curve to existing x-values and y-values.  
    Public MethodIndexGets a value or the reference to a value from within a table or range.  
    Public MethodTrendGets values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y's and known_x's. Gets the y-values along that line for the array of new_x's that you specify.  
    Top
    See Also

    Reference

    WorksheetFunction Class
    GrapeCity.Spreadsheet Namespace