'Declaration
 
Public Overloads Shared Function GetEditCommands( _
   ByVal worksheet As IWorksheet, _
   ByVal editingRow As Integer, _
   ByVal editingColumn As Integer, _
   ByVal isSetMultipleCells As Boolean, _
   ByVal autoCreateCalculatedColumns As Boolean, _
   ByVal autoExpandTable As Boolean, _
   ByVal cellValue As CellValue, _
   ByVal isQuoted As Boolean, _
   ByVal formula As String, _
   ByVal isArrayFormula As Boolean, _
   ByVal numFmt As Integer, _
   Optional ByVal allowRichTextEdit As Boolean, _
   Optional ByVal activeCellLocation As Direction _
) As Command()

'Usage
 
Dim worksheet As IWorksheet
Dim editingRow As Integer
Dim editingColumn As Integer
Dim isSetMultipleCells As Boolean
Dim autoCreateCalculatedColumns As Boolean
Dim autoExpandTable As Boolean
Dim cellValue As CellValue
Dim isQuoted As Boolean
Dim formula As String
Dim isArrayFormula As Boolean
Dim numFmt As Integer
Dim allowRichTextEdit As Boolean
Dim activeCellLocation As Direction
Dim value() As Command
 
value = UIHelper.GetEditCommands(worksheet, editingRow, editingColumn, isSetMultipleCells, autoCreateCalculatedColumns, autoExpandTable, cellValue, isQuoted, formula, isArrayFormula, numFmt, allowRichTextEdit, activeCellLocation)

public static Command[] GetEditCommands( 
   IWorksheet worksheet,
   int editingRow,
   int editingColumn,
   bool isSetMultipleCells,
   bool autoCreateCalculatedColumns,
   bool autoExpandTable,
   CellValue cellValue,
   bool isQuoted,
   string formula,
   bool isArrayFormula,
   int numFmt,
   bool allowRichTextEdit,
   Direction activeCellLocation
)

Parameters

worksheet

the worksheet that current editing.

editingRow

the row position that current editing.

editingColumn

the column position that current editing.

isSetMultipleCells

autoCreateCalculatedColumns

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.

isQuoted

formula

editing formula.

isArrayFormula

A boolean value indicates is setting array formula.

numFmt

allowRichTextEdit

activeCellLocation

Return Value

Reference

UIHelper Class
UIHelper Members
Overload List