- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
-
FarPoint.Win.Spread Assembly
- FarPoint.Win.Spread
- FarPoint.Win.Spread.CellType
- FarPoint.Win.Spread.Chart
- FarPoint.Win.Spread.Data
- FarPoint.Win.Spread.Dialogs
- FarPoint.Win.Spread.DrawingSpace
-
FarPoint.Win.Spread.Model
-
Classes
- AggregateArgs
- AggregationDataModel
- BaseSheetAxisModel
- BaseSheetDataModel
- BaseSheetSelectionModel
- BaseSheetSpanModel
- BaseSheetStyleModel
- CellRange
- CellRangeConverter
- ConvertTableToRangeEventArgs
- DefaultSheetAxisModel
-
DefaultSheetDataModel
- Constructors
- Properties
-
Methods
- AddColumn
- AddColumns
- AddCustomName
- AddModelScopeCustomName
- AddRow
- AddRowToDataSource
- AddRows
- AddUnboundRows
- CheckModelScopeName
- CheckName
- Clear
- ClearCustomFunctions
- ClearCustomNames
- ClearData
- ClearFormulas
- ClearModelScopeCustomName
- CompareExpression
- Copy
- Deserialize
- EvaluateExpression
- FireChanged
- GetArray
- GetCellErrorText
- GetChildDataModel
- GetChildRelation
- GetColumnIndex
- GetCustomName
- GetCustomNameComment
- GetCustomNameEnumerator
- GetDataColumnCaption
- GetDataColumnFromModelColumn
- GetDataColumnName
- GetDataColumnType
- GetDataRow
- GetDataRowFromModelRow
- GetDataTable
- GetDataView
- GetFormula
- GetItem
- GetListSource
- GetModelColumnFromDataColumn
- GetModelRowFromDataRow
- GetModelScopeCustomName
- GetModelScopeCustomNameComment
- GetModelScopeNameEnumerator
- GetNonEmptyErrorTextsColumnCount
- GetNonEmptyErrorTextsRowCount
- GetNonEmptyNotesColumnCount
- GetNonEmptyNotesRowCount
- GetNote
- GetObjectData
- GetRowErrorText
- GetTag
- GetUnboundValue
- GetValue
- GoalSeek
- IsColumnBound
- IsEditable
- IsEmpty
- IsRowBound
- IsRowUsed
- LoadFormulas
- ModifyCustomName
- ModifyModelScopeCustomName
- Move
- NextNonEmptyColumnFormula
- NextNonEmptyColumnInRow
- NextNonEmptyRow
- OnAggregate
- OnChanged
- ParseFormula
- PreviousNonEmptyColumnInRow
- PreviousNonEmptyRow
- Recalculate
- RecalculateAll
- RemoveColumn
- RemoveColumns
- RemoveCustomName
- RemoveModelScopeCustomName
- RemoveRow
- RemoveRows
- ResumeFormulaParsing
- Serialize
- SetArray
- SetCellErrorText
- SetCustomNameComment
- SetFormula
- SetModelDataColumn
- SetModelScopeCustomNameComment
- SetNote
- SetRowErrorText
- SetTag
- SetValue
- SuspendFormulaParsing
- Swap
- UnparseFormula
- Events
- DefaultSheetDataModel.CellEventArgs
- DefaultSheetDataModel.DefaultSheetDataModelEnumerator
- DefaultSheetDataModel.RowEventArgs
- DefaultSheetSelectionModel
- DefaultSheetSpanModel
- DefaultSheetStyleModel
- FormulaDependentInfos
- GeneralFormatter
- Group
- GroupDataModel
- GroupFooter
- InvalidExternalReferenceParseException
- InvalidNameException
- MapperUpdatingEventArgs
- ParseException
- PropertyChangingEventArgs
- SheetAxisModelChangingEventArgs
- SheetAxisModelEventArgs
- SheetAxisProperty
- SheetDataModelEventArgs
- SheetGroupDataModelEventArgs
- SheetSelectionModelEventArgs
- SheetSpanModelChangingEventArgs
- SheetSpanModelEventArgs
- SheetStyleModelEventArgs
- SpreadSerializer
- TableChangedEventArgs
- TableItemChangedEventArgs
- TableItemChangingEventArgs
- TableItemNameChangedEventArgs
- TableItemNameChangingEventArgs
- TableNameChangedEventArgs
- TableNameChangingEventArgs
- TableRangeChangedEventArgs
- TableRangeChangingEventArgs
- Structs
- Enums
- Interfaces
- Delegates
-
Classes
- FarPoint.Win.Spread.UndoRedo
- FarPoint.Win.Spread.Visualization
- GrapeCity.CalcEngine Assembly
- GrapeCity.Spreadsheet Assembly
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
FarPoint.Win.Spread.Model.DefaultSheetDataModel.SetArray
SetArray Method
SetArray(int, int, object[,])
Sets an object array into a specified range of cells.
Declaration
public void SetArray(int row, int column, object[,] value)Public Sub SetArray(row As Integer, column As Integer, value As Object(,))Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index of the start of the range of cells |
| int | column | Column index of the start of the range of cells |
| object[,] | value | Two-dimensional object array[row,column] that contains the values |
Implements
SetArray(int, int, object[,], bool)
Sets an object array into a specified range of cells.
Declaration
public void SetArray(int row, int column, object[,] value, bool formula)Public Sub SetArray(row As Integer, column As Integer, value As Object(,), formula As Boolean)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index of the start of the range of cells |
| int | column | Column index of the start of the range of cells |
| object[,] | value | Two-dimensional object array[row,column] that contains the values |
| bool | formula | If true, set formulas; otherwise, set values. |
SetArray(int, int, object[,], bool, ReferenceStyle)
Sets an object array into a specified range of cells.
Declaration
public void SetArray(int row, int column, object[,] value, bool formula, ReferenceStyle referenceStyle)Public Sub SetArray(row As Integer, column As Integer, value As Object(,), formula As Boolean, referenceStyle As ReferenceStyle)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index of the start of the range of cells |
| int | column | Column index of the start of the range of cells |
| object[,] | value | Two-dimensional object array[row,column] that contains the values |
| bool | formula | If true, set formulas; otherwise, set values. |
| ReferenceStyle | referenceStyle | The reference style of formulas |