Spread WinForms 15
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelBiffRead2 Interface / ExcelGetSharedFormula Method
First row specifies a cell range applied the shared formula
First column specifies a cell range applied the shared formula
Row index specifies a cell
Column index specifies a cell


In This Topic
ExcelGetSharedFormula Method (IExcelBiffRead2)
In This Topic
Gets out An ArrayList that contains 2 parts of a shared formula
Syntax
'Declaration
 
Function ExcelGetSharedFormula( _
   ByVal firstRowOfShare As Integer, _
   ByVal firstColOfShare As Integer, _
   ByVal rowPos As Integer, _
   ByVal colPos As Integer _
) As ArrayList
 
'Usage
 
Dim instance As IExcelBiffRead2
Dim firstRowOfShare As Integer
Dim firstColOfShare As Integer
Dim rowPos As Integer
Dim colPos As Integer
Dim value As ArrayList
 
value = instance.ExcelGetSharedFormula(firstRowOfShare, firstColOfShare, rowPos, colPos)

Parameters

firstRowOfShare
First row specifies a cell range applied the shared formula
firstColOfShare
First column specifies a cell range applied the shared formula
rowPos
Row index specifies a cell
colPos
Column index specifies a cell

Return Value

ArrayList that contains 2 parts of a shared formula
See Also