AdjustFormulaOnClipboardPaste Method
Adjusts formulas when pasting from the Clipboard.
'Declaration
Function AdjustFormulaOnClipboardPaste( _
ByVal As String, _
ByVal As Dictionary(Of String,ITableRange), _
ByVal As Dictionary(Of String,ITableRange), _
ByVal As Integer, _
ByVal column As Integer, _
ByVal As ReferenceStyle _
) As String
'Usage
Dim instance As ITableModelSupport
Dim formula As String
Dim addTables As Dictionary(Of String,ITableRange)
Dim removeTables As Dictionary(Of String,ITableRange)
Dim row As Integer
Dim column As Integer
Dim referenceStyle As ReferenceStyle
Dim value As String
value = instance.AdjustFormulaOnClipboardPaste(formula, addTables, removeTables, row, column, referenceStyle)
Parameters
- formula
- The formula that is being adjusted
- addTables
- The added tables list.
- removeTables
- Dictionary of removed tables.
- row
- Row index.
- column
- Column index.
- referenceStyle
- Reference style of the formula.
Return Value