Spread Windows Forms 15.0
FarPoint.Excel Assembly / FarPoint.Excel Namespace / IExcelXml2 Interface / ExcelGetBasedIndexPosition Method
sheet index specifies a sheetView in sheetViews collection
Row or column index
Offset value that measured in pixel
A bool value specifies whether it is for row index


In This Topic
    ExcelGetBasedIndexPosition Method
    In This Topic
    Calculate position based on column/row index from offset
    Syntax
    'Declaration
     
    
    Function ExcelGetBasedIndexPosition( _
       ByVal sheet As Short, _
       ByVal index As Integer, _
       ByVal offsetIndex As Integer, _
       ByVal isRowOffset As Boolean _
    ) As Double
    'Usage
     
    
    Dim instance As IExcelXml2
    Dim sheet As Short
    Dim index As Integer
    Dim offsetIndex As Integer
    Dim isRowOffset As Boolean
    Dim value As Double
     
    value = instance.ExcelGetBasedIndexPosition(sheet, index, offsetIndex, isRowOffset)
    double ExcelGetBasedIndexPosition( 
       short sheet,
       int index,
       int offsetIndex,
       bool isRowOffset
    )

    Parameters

    sheet
    sheet index specifies a sheetView in sheetViews collection
    index
    Row or column index
    offsetIndex
    Offset value that measured in pixel
    isRowOffset
    A bool value specifies whether it is for row index

    Return Value

    A double value represents for a index based position
    See Also