GetAutoFillValue Method

In This Topic

Get the autoFill value.

Syntax

Visual Basic
C#

'Declaration
 
Public Shared Function GetAutoFillValue( _
   ByVal worksheet As IWorksheet, _
   ByVal sourceRange As Reference, _
   ByVal targetRange As Reference, _
   ByRef fillType As AutoFillType, _
   ByRef numberFormat As NumberFormat _
) As Object

'Usage
 
Dim worksheet As IWorksheet
Dim sourceRange As Reference
Dim targetRange As Reference
Dim fillType As AutoFillType
Dim numberFormat As NumberFormat
Dim value As Object
 
value = UIHelper.GetAutoFillValue(worksheet, sourceRange, targetRange, fillType, numberFormat)

public static object GetAutoFillValue( 
   IWorksheet worksheet,
   Reference sourceRange,
   Reference targetRange,
   out AutoFillType fillType,
   out NumberFormat numberFormat
)

Parameters

worksheet: The GrapeCity.Spreadsheet.IWorksheet object which is using autofill.
sourceRange: The selected cell range to create fill.
targetRange: The target cell range addres.s
fillType: Specifies the fill type.
numberFormat: The number format of auto fill cell

Return Value

The value of autofill cell

Reference

UIHelper Class
UIHelper Members