'Declaration
 
Public Shared Function GetEditCommands( _
   ByVal worksheet As IWorksheet, _
   ByVal editingRow As Integer, _
   ByVal editingColumn As Integer, _
   ByVal isSetMultipleCells As Boolean, _
   ByVal autoCreateCalcuatedColumns As Boolean, _
   ByVal autoExpandTable As Boolean, _
   ByVal cellValue As CellValue, _
   ByVal formula As String, _
   ByVal isArrayFormula As Boolean _
) As Command()

'Usage
 
Dim worksheet As IWorksheet
Dim editingRow As Integer
Dim editingColumn As Integer
Dim isSetMultipleCells As Boolean
Dim autoCreateCalcuatedColumns As Boolean
Dim autoExpandTable As Boolean
Dim cellValue As CellValue
Dim formula As String
Dim isArrayFormula As Boolean
Dim value() As Command
 
value = UIHelper.GetEditCommands(worksheet, editingRow, editingColumn, isSetMultipleCells, autoCreateCalcuatedColumns, autoExpandTable, cellValue, formula, isArrayFormula)

public static Command[] GetEditCommands( 
   IWorksheet worksheet,
   int editingRow,
   int editingColumn,
   bool isSetMultipleCells,
   bool autoCreateCalcuatedColumns,
   bool autoExpandTable,
   CellValue cellValue,
   string formula,
   bool isArrayFormula
)

Parameters

worksheet

the worksheet that current editing.

editingRow

the row postion that current editing.

editingColumn

the column position that current editing.

isSetMultipleCells

autoCreateCalcuatedColumns

A boolean value indicates the calculated columns will be created when enter formula

autoExpandTable

A boolean value indicates affected table will be expand

cellValue

editing cell value.

formula

editing formula.

isArrayFormula

A boolean value indicates is setting array formula.

Return Value

Reference

UIHelper Class
UIHelper Members