- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.PDF Assembly
- FarPoint.Win Assembly
- FarPoint.Win.Chart Assembly
-
FarPoint.Win.Spread Assembly
-
FarPoint.Win.Spread
-
Classes
- Action
- ActionMap
- ActiveSheetChangingEventArgs
- AdvanceEventArgs
- AdvancedSearchDialog
- AlternatingRow
- AlternatingRows
- AnimatedDefaultFocusIndicatorRenderer
- AnnotationModeEventArgs
- Appearance
- AppearanceActionBase
- AppearanceStyleCollection
- AppearanceStyleInfo
- ApplyEventArgs
- AutoFilteredColumnEventArgs
- AutoFilteringColumnEventArgs
- AutoSortedColumnEventArgs
- AutoSortingColumnEventArgs
- AverageConditionalFormattingRule
- BaseDataValidator
- BaseFilterItem
- BaseSparkline
- BeforeRightClickEventArgs
- BeforeSettingPropertyValueEventArgs
- BeforeShowContextMenuEventArgs
- BestFitColumnRule
- BetweenValuesConditionalFormattingRule
- BlankConditionalFormattingRule
- CalculateExceptionEventArgs
- Cell
- CellClickEventArgs
- CellErrorTextChangedEventArgs
- CellFooter
- CellInfo
- CellInfoRange
- CellPadding
- CellStyleNotify
- CellTouchStrip
- CellValidateInfoNeededEventArgs
- Cells
- CellsEditorForm
- ChangeEventArgs
- CharFormatValidator
- ChartTouchStrip
- ChildControlEventArgs
- ChildViewCreatedEventArgs
- ChildWorkbookCreatedEventArgs
- CircularCellChangedEventArgs
- CircularFormulaEventArgs
- CircularFormulaEventInfo
- ClipboardPastedEventArgs
- ClipboardPastingEventArgs
- ColorFilterItem
- Column
- ColumnClipInfo
- ColumnClipInfoRange
- ColumnFooter
- ColumnHeader
- ColumnSparklineRenderer
- ColumnTouchStrip
- ColumnViewportWidthChangedEventArgs
- ColumnWidthChangeExtents
- ColumnWidthChangedEventArgs
- ColumnWidthChangingEventArgs
- Columns
- Columns.DefaultColumn
- CombinedStyleInfo
- CompareCellValidator
- CompareStringValidator
- CompareValueBaseValidator
- CompareValueValidator
- ComplexSortInfo
- ConditionalFormat
- ConditionalFormatting
- ConditionalFormattingChangedEventArgs
- ConditionalFormattingColorValue
- ConditionalFormattingColorValueCollection
- ConditionalFormattingIconRuleSet
- ConditionalFormattingIconSetIndex
- ConditionalFormattingIconValue
- ConditionalFormattingModel
- ConditionalFormattingModelEventArgs
- ConditionalFormattingRule
- ConditionalFormattingRulePropertyChangedEventArgs
- ConditionalFormattingValue
- ConditionalFormattingValueCollection
- ConditionalStyleInfo
- ConditionalStyleItem
- ConditionalStyleItemCollection
- CustomFillSeriesList
- CustomFilterItem
- CustomFocusIndicatorRenderer
- CustomIconContainer
- CustomImageInfo
- CustomNameChangedEventArgs
- DataAddNewException
- DataColumnConfigureEventArgs
- DataFieldConverter
- DataValidationManager
- DatabarConditionalFormattingRule
- DefaultErrorIconRenderer
- DefaultFilterItem
- DefaultFocusIndicatorRenderer
- DefaultGroupFooter
- DefaultGroupFooterCollection
- DefaultNoteIndicatorRenderer
- DefaultRangeGroupModel
- DefaultRowFilter
- DefaultScrollBarRenderer
- DefaultSelectionRenderer
- DefaultSkins
- DefaultSparklineContainer
- DefaultSpreadSkins
- DefaultStyleCollection
- DelegateResolveEventArgs
- DialogCharEventArgs
- DialogKeyEventArgs
- DocumentPropertiesForm
- DragDropBlockCompletedEventArgs
- DragDropBlockEventArgs
- DragFillBlockCompletedEventArgs
- DragFillBlockEventArgs
- DragMoveCompletedEventArgs
- DragMoveCompletingEventArgs
- DragMoveEventArgs
- DropDownControl
- DynamicFilterItem
- DynamicStyleInfo
- DynamicStyleInfoContext
- EditErrorEventArgs
- EditModeStartingEventArgs
- EditingFocusIndicatorRenderer
- EditorNotifyEventArgs
- EncodingValidator
- EnhancedFocusIndicatorRenderer
- EnhancedInterfaceRenderer
- EnhancedScrollBarRenderer
- EnterCellEventArgs
- ErrorConditionalFormattingRule
- ErrorEventArgs
- EventNameConverter
- ExcelBaseSparkLineRenderer
- ExcelSparkline
- ExcelSparklineGroup
- ExcelSparklineSetting
- ExcludeListValidator
- ExpandEventArgs
- ExtraRendererSettings
- FilterBar
- FilterBarEventArgs
- FilterBarHitTestInformation
- FilterColumnDefinition
- FilterColumnDefinitionCollection
- FilterCondition
- FilterItemCollection
- FilterItemValue
- FilterItemValueCollection
- FlatFocusIndicatorRenderer
- FlatInterfaceRenderer
- FlatScrollBarRenderer
- FlatSelectionRenderer
- FocusProcess
- FormatCells
- FormulaConditionalFormattingRule
- FormulaTextBox
- FpBaseStatusBarElement
- FpHorizontalScrollBar
- FpScrollBar
- FpScrollBarButton
- FpScrollBarButtonBackwardHome
- FpScrollBarButtonBackwardLine
- FpScrollBarButtonBackwardPage
- FpScrollBarButtonClickEventArgs
- FpScrollBarButtonCollection
- FpScrollBarButtonForwardEnd
- FpScrollBarButtonForwardLine
- FpScrollBarButtonForwardPage
- FpScrollBarComboThumb
- FpScrollBarGripper
- FpScrollBarThumb
- FpScrollBarTrack
- FpScrollBarTrackBackward
- FpScrollBarTrackForward
- FpSpread
- FpStatusBarAverageElement
- FpStatusBarCountElement
- FpStatusBarElementCollection
- FpStatusBarMaxElement
- FpStatusBarMinElement
- FpStatusBarNumericalCountElement
- FpStatusBarRangeStatusElement
- FpStatusBarRangeStatusFormatElement
- FpStatusBarSumElement
- FpStatusBarTextElement
- FpVerticalScrollBar
- GetCustomIconEventArgs
- GradientInterfaceRenderer
- GradientSelectionRenderer
- GridLine
- GroupBarInfo
- GroupInfo
- GroupInfoCollection
- GroupingEventArgs
- HeaderEditForm
- HeaderHitTestInformation
- HideRowFilter
- HighlightConditionalFormattingRule
- HighlightConditionalFormattingStyle
- HitTestInformation
- HyperLinkClickedEventArgs
- HyperlinkForm
- IconFilterItem
- IconNotify
- IconSetConditionalFormattingRule
- ImageFocusIndicatorRenderer
- IncludeListValidator
- InputMap
- InputScreenTipDialog
- InputTextDialog
- InvalidFileFormatException
- ItemEventArgs
- ItemTrackedEventArgs
- KeystrokeFactory
- LandscapeRule
- LeaveCellEventArgs
- LeftChangeEventArgs
- LineNotify
- LineSparklineRenderer
- MarqueeFocusIndicatorRenderer
- MessageBoxNotify
- ModelessForm
- MultiValuesFilterItem
- NameBox
- NamedAppearanceStyleInfo
- NamedObjectCollection<T>
- NamedStyle
- NamedStyleCollection
- NamedStyleCollectionEventArgs
- NoteEventArgs
- OwnerPrintInfo
- PaintGrayAreaEventArgs
- PaintGroupBarBackgroundEventArgs
- PaintTabStripButtonEventArgs
- PaintTabStripEventArgs
- PaintTabStripTabEventArgs
- PairChar
- PairCharValidator
- ParentStyleNameConverter
- PrePaintConditionalFormattingRule
- PrePaintResult
- PrePaintTextConditionalFormattingRule
- PrePaintTextResult
- PreviewRowFetchEventArgs
- PreviewRowInfo
- PrintAbortEventArgs
- PrintBackgroundEventArgs
- PrintCancelledEventArgs
- PrintDocumentEventArgs
- PrintHeaderFooterAreaEventArgs
- PrintInfo
- PrintMargin
- PrintMessageBoxEventArgs
- PrintPreviewShowingEventArgs
- PropertyTrackChangedEventArgs
- QueryAccessibleObjectValueEventArgs
- QueryValueEventArgs
- RangeElement<T>
- RangeGroupHitTestInformation
- RangeGroupInfo
- RangeGroupInfoEventArgs
- RangeGroupModelEventArgs
- RangeGroupStateChangedEventArgs
- RangeGroupStateChangingEventArgs
- RangeValidator
- RecentItemsEventArgs<T>
- RegularExpressionValidator
- ReloadSheetCellRangeFormulaEventArgs
- RequiredFieldValidator
- RequiredTypeValidator
- ResolveActionEventArgs
- ResolveCustomControlEventArgs
- Row
- RowClipInfo
- RowClipInfoRange
- RowErrorTextChangedEventArgs
- RowHeader
- RowHeightChangeExtents
- RowHeightChangedEventArgs
- RowHeightChangingEventArgs
- RowTouchStrip
- RowViewportHeightChangedEventArgs
- Rows
- Rows.DefaultRow
- SaveNamedStyleCollection
- ScaleRule
- ScrollTipFetchEventArgs
- ScrollingContentInfo
- SearchDialog
- SelectionChangedEventArgs
- SelectionChangingEventArgs
- ShapeTouchStrip
- SheetCorner
- SheetDragMovedEventArgs
- SheetDragMovingEventArgs
- SheetSkin
- SheetSkinsForm
- SheetStyleProperty
- SheetTab
- SheetTabClickEventArgs
- SheetTabDoubleClickEventArgs
-
SheetView
- Constructors
- Fields
- Properties
-
Methods
- AddChart
- AddColumnFooterSpanCell
- AddColumnHeaderSpanCell
- AddColumns
- AddControl
- AddCustomName
- AddRangeGroup
- AddRowHeaderSpanCell
- AddRowToDataSource
- AddRows
- AddSelection
- AddShape
- AddSpanCell
- AddSparkline
- AddSquareSparkline
- AddTable
- AddUnboundRows
- AddValidators
- AsWorksheet
- AutoFilterColumn
- AutoFilterReset
- AutoSortColumn
- BindDataColumn
- ClearColumnFooterSpanCells
- ClearColumnHeaderSpanCells
- ClearConditionalFormating
- ClearConditionalFormatings
- ClearControls
- ClearCustomFunctions
- ClearCustomNames
- ClearRange
- ClearRangeGroup
- ClearRowFilter
- ClearRowHeaderSpanCells
- ClearSelection
- ClearShapes
- ClearSpanCells
- ClearSparklineGroupsInRange
- ClearSparklines
- ClearValidators
- ClipboardCopy
- ClipboardCopyShape
- ClipboardCut
- ClipboardCutShape
- ClipboardPaste
- ClipboardPasteShape
- Clone
- ConvertTableToRange
- CopyRange
- DisableProtect
- Dispose
- EvaluateExpression
- ExpandRangeGroup
- ExpandRow
- FillRange
- FindChildView
- FirePropertyChanged
- GetArray
- GetCellErrorText
- GetCellFromTag
- GetCellReference
- GetCellType
- GetChildRelation
- GetChildSheets
- GetChildView
- GetChildVisible
- GetClip
- GetClipDataObject
- GetClipValue
- GetColumnAllowAutoSort
- GetColumnAllowFilter
- GetColumnAutoFilterIndex
- GetColumnAutoSortIndex
- GetColumnAutoText
- GetColumnFooterText
- GetColumnFromTag
- GetColumnHeaderSpanCell
- GetColumnLabel
- GetColumnMerge
- GetColumnPageBreak
- GetColumnShowSortIndicator
- GetColumnSizeable
- GetColumnSortIndicator
- GetColumnVisible
- GetColumnVisibleCount
- GetColumnWidth
- GetConditionalFormatting
- GetControl
- GetControlContainer
- GetCustomFunctionEnumerator
- GetCustomName
- GetCustomNameComment
- GetCustomNameEnumerator
- GetDataView
- GetDropDownFilterItems
- GetEditor
- GetFilterBarCellType
- GetFormula
- GetLastNonEmptyColumn
- GetLastNonEmptyRow
- GetModelColumnFromViewColumn
- GetModelRowFromViewRow
- GetNote
- GetNoteBounds
- GetObjectData
- GetPreferredCellSize
- GetPreferredColumnWidth
- GetPreferredPrintColumnWidth
- GetPreferredPrintRowHeight
- GetPreferredRowHeight
- GetRangeGroupInfo
- GetRangeGroupLevels
- GetRenderer
- GetRootSheet
- GetRowAutoText
- GetRowErrorText
- GetRowExpandable
- GetRowFromTag
- GetRowHeaderSpanCell
- GetRowHeight
- GetRowLabel
- GetRowMerge
- GetRowPageBreak
- GetRowSizeable
- GetRowVisible
- GetRowVisibleCount
- GetSelection
- GetSelections
- GetShape
- GetSpanCell
- GetSparkline
- GetStickyNoteStyleInfo
- GetStyleInfo
- GetTable
- GetTableEnumerator
- GetTag
- GetText
- GetUnboundValue
- GetValidConditionalFormat
- GetValidators
- GetValue
- GetViewColumnFromModelColumn
- GetViewRowFromModelRow
- GroupSparkline
- InitPropArray
- IsAnyCellInColumnSelected
- IsAnyCellInRowSelected
- IsColumnBound
- IsLockObject
- IsRowBound
- IsRowExpanded
- IsSelected
- JoinShapes
- LoadFormulas
- LoadTextFile
- LoadTextFileRange
- ModifyCustomName
- MoveColumn
- MoveRange
- MoveRow
- OnAddColumnFooterRows
- OnAddColumnHeaderRows
- OnAddColumns
- OnAddRowHeaderColumns
- OnAddRows
- OnCellChanged
- OnCopyCells
- OnCopyColumns
- OnCopyRows
- OnDataModelChanged
- OnDisposing
- OnMoveCells
- OnMoveColumns
- OnMoveRows
- OnNoteCreated
- OnNoteMoved
- OnNoteSized
- OnRemoveColumnFooterRows
- OnRemoveColumnHeaderRows
- OnRemoveColumns
- OnRemoveRowHeaderColumns
- OnRemoveRows
- OnSheetColumnAxisModelChanged
- OnSheetRangeGroupModelChanged
- OnSheetRowAxisModelChanged
- OnSpanModelChanged
- OnStickyNoteCreated
- OnStickyNoteMoved
- OnStickyNoteSized
- OnStyleModelChanged
- OnSwapCells
- OnSwapColumns
- OnSwapRows
- Open
- OpenExcel
- OpenSpreadFile
- RaiseCellChanged
- RaisePropertyChanged
- Recalculate
- RecalculateAll
- RemoveColumnFooterSpanCell
- RemoveColumnHeaderSpanCell
- RemoveColumns
- RemoveControl
- RemoveCustomFunction
- RemoveCustomName
- RemoveRangeGroup
- RemoveRowHeaderSpanCell
- RemoveRows
- RemoveSelection
- RemoveShape
- RemoveSpanCell
- RemoveTable
- Reset
- RestoreProtect
- ResumeAutoUpdateChartData
- ResumeFormulaParsing
- Save
- SaveHtml
- SaveHtmlRange
- SaveImage
- SaveTextFile
- SaveTextFileRange
- SaveXml
- SetActiveCell
- SetArray
- SetCellErrorText
- SetChildVisible
- SetClip
- SetClipSpecial
- SetClipValue
- SetColumnAllowAutoSort
- SetColumnAllowFilter
- SetColumnAutoFilterIndex
- SetColumnAutoSortIndex
- SetColumnLabel
- SetColumnMerge
- SetColumnPageBreak
- SetColumnShowSortIndicator
- SetColumnSizeable
- SetColumnSortIndicator
- SetColumnVisible
- SetColumnWidth
- SetConditionalFormatting
- SetCustomNameComment
- SetErrorValue
- SetFilteredColumn
- SetFormula
- SetInsideBorder
- SetModelColumnForViewColumn
- SetModelRowForViewRow
- SetMultipleColumnWidths
- SetMultipleRowHeights
- SetNote
- SetNoteBounds
- SetOutlineBorder
- SetRowErrorText
- SetRowExpandable
- SetRowHeight
- SetRowLabel
- SetRowMerge
- SetRowPageBreak
- SetRowSizeable
- SetRowVisible
- SetStickyNoteStyleInfo
- SetStyleInfo
- SetTag
- SetText
- SetValue
- ShouldSerializeAlternatingRows
- ShouldSerializeBackgroundImage
- ShouldSerializeCells
- ShouldSerializeColumnFooterSheetCornerHorizontalGridLine
- ShouldSerializeColumnFooterSheetCornerStyle
- ShouldSerializeColumnFooterSheetCornerVerticalGridLine
- ShouldSerializeColumns
- ShouldSerializeDefaultStyle
- ShouldSerializeFilterBarHeaderStyle
- ShouldSerializeGrayAreaBackColor
- ShouldSerializeHorizontalGridLine
- ShouldSerializeIsBackgroundImageTiled
- ShouldSerializeLockFont
- ShouldSerializeModels
- ShouldSerializeNullBackColor
- ShouldSerializeNullFont
- ShouldSerializeNullForeColor
- ShouldSerializePrintInfo
- ShouldSerializeRows
- ShouldSerializeSaveNamedStyles
- ShouldSerializeSelectionBackColor
- ShouldSerializeSelectionFont
- ShouldSerializeSelectionForeColor
- ShouldSerializeSheetCornerHorizontalGridLine
- ShouldSerializeSheetCornerStyle
- ShouldSerializeSheetCornerVerticalGridLine
- ShouldSerializeVerticalGridLine
- ShouldSerializeZoomFactor
- ShowNotes
- SortColumns
- SortRange
- SortRows
- SuspendAutoUpdateChartData
- SuspendFormulaParsing
- SwapRange
- UngroupSparkline
- UpdateNotes
- UpdatePropArray
- Validate
- Events
- SheetView.DocumentModels
- SheetView.MultipleColumnMovingException
- SheetView.MultipleRowMovingException
- SheetView.SaveAutoSortColumns
- SheetViewCollection
- SheetViewEventArgs
- SheetViewPropertyChangeEventArgs
- SlicerInsertForm
- SlicerSettingsForm
- SmartPaperRule
- SmartPrintRule
- SmartPrintRulesCollection
- SolidFocusIndicatorRenderer
- SortArgs
- SortInfo
- SortedEventArgs
- SortingEventArgs
- SoundNotify
- Sparkline
- SparklineInfo
- SparklineModelUpdateEventArgs
- SpreadActions
- SpreadContextMenuStrip
- SpreadFontStyle
- SpreadHScrollBar
- SpreadSkin
- SpreadSkinsForm
- SpreadSparklineRenderes
- SpreadTouchStrip
- SpreadVScrollBar
- SpreadView
- StatusBarDefaultSkin
- StatusBarElementChangeArgs
- StatusBarSkin
- StickyNoteEventArgs
- StyleInfo
- StyleNameConverter
- StyleRowFilter
- SubEditorClosedEventArgs
- SubEditorOpeningEventArgs
- SurrogateCharValidator
- TabStrip
- TabStripButtonClickEventArgs
- TabStripHitTestInformation
- TableBorder
- TableElementStyle
- TablePropertyChangedEventArgs
- TablePropertyChangingEventArgs
- TableStyle
- TableStyleCollection
- TableStyleCollectionChangedEventArgs
- TableUtils
- TableView
- TableViewClipboardInfo
- TableViewColumn
- TableViewColumnCollection
- TextConditionalFormattingRule
- TextLengthValidator
- TextTipFetchEventArgs
- ThreeColorScaleConditionalFormattingRule
- ThreeStateIconNotify
- TimePeriodConditionalFormattingRule
- TipAppearance
- TipNotify
- TitleInfo
- TitlebarHitTestInformation
- Top10FilterItem
- TopChangeEventArgs
- TopRankedValuesConditionalFormattingRule
- TouchStripButton
- TouchStripOpeningEventArgs
- TriangleNoteIndicatorRenderer
- TwoColorScaleConditionalFormattingRule
- UnaryComparisonConditionalFormattingRule
- UniqueOrDuplicatedConditionalFormattingRule
- UserFormulaEnteredEventArgs
- UserSpecifiedFilterItem
- ValidateActionBase
- ValidateActionCollection
- ValidateActionContext
- ValueProcess
- ViewportHitTestInformation
- WinLossSparklineRenderer
- ZoomEventArgs
- ZoomSliderStatusBarElement
- ZoomStatusBarElement
- Structs
- Enums
- Interfaces
- Delegates
-
Classes
- FarPoint.Win.Spread.CellType
- FarPoint.Win.Spread.Chart
- FarPoint.Win.Spread.Data
- FarPoint.Win.Spread.Dialogs
- FarPoint.Win.Spread.DrawingSpace
- FarPoint.Win.Spread.Model
- FarPoint.Win.Spread.UndoRedo
- FarPoint.Win.Spread.Visualization
-
FarPoint.Win.Spread
- GrapeCity.CalcEngine Assembly
- GrapeCity.Spreadsheet Assembly
- GrapeCity.Spreadsheet.WinForms.Ribbon Assembly
- GrapeCity.Win.PluginInputMan Assembly
FarPoint.Win.Spread.SheetView.SetText
SetText Method
SetText(int, int, string)
Sets the formatted text in the cell on this sheet using the IFormatter object for the cell.
Declaration
public void SetText(int row, int column, string value)Public Sub SetText(row As Integer, column As Integer, value As String)Parameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index |
| int | column | Column index |
| string | value | Text for the specified cell |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row index is out of range; must be between 0 and the total number of rows |
| ArgumentOutOfRangeException | Specified column index is out of range; must be between 0 and the total number of columns |