- 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
- CellValueCommitErrorArgs
- 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
- 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
- HeaderHitTestInformation
- HideRowFilter
- HighlightConditionalFormattingRule
- HighlightConditionalFormattingStyle
- HitTestInformation
- HyperLinkClickedEventArgs
- HyperlinkForm
- IconFilterItem
- IconNotify
- IconSetConditionalFormattingRule
- ImageFocusIndicatorRenderer
- IncludeListValidator
- InputMap
- 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
- SheetView.DocumentModels
- SheetView.MultipleColumnMovingException
- SheetView.MultipleRowMovingException
- SheetView.SaveAutoSortColumns
- SheetViewCollection
- SheetViewEventArgs
- SheetViewPropertyChangeEventArgs
- 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
- StyleRowFilter
- SubEditorClosedEventArgs
- SubEditorOpeningEventArgs
- SurrogateCharValidator
- TabStrip
- TabStripButtonClickEventArgs
- TabStripHitTestInformation
- TableBorder
- TableElementStyle
- TablePropertyChangedEventArgs
- TablePropertyChangingEventArgs
- TableStyle
- TableStyleCollection
- TableStyleCollectionChangedEventArgs
- 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.Cells.Get
Get Method
Get(int, int)
Gets a new Cell object for the specified row and column.
Declaration
public Cell Get(int row, int column)Public Function [Get](row As Integer, column As Integer) As CellParameters
| Type | Name | Description |
|---|---|---|
| int | row | Row index of cell |
| int | column | Column index of cell |
Returns
| Type | Description |
|---|---|
| Cell | A Cell at the special row, column. |
Exceptions
| Type | Condition |
|---|---|
| IndexOutOfRangeException | Specified row index is not valid; must be between zero and the total number of rows |
| IndexOutOfRangeException | Specified column index is not valid; must be between zero and the total number of columns |
| IndexOutOfRangeException | Specified row index is not valid; must be between zero and the total number of column header rows |
| IndexOutOfRangeException | Specified column index is not valid; must be between zero and the total number of row header columns |
Get(int, int, int, int)
Gets a new Cell object for the range of cells of the specified rows and columns.
Declaration
public Cell Get(int row, int column, int row2, int column2)Public Function [Get](row As Integer, column As Integer, row2 As Integer, column2 As Integer) As CellParameters
| Type | Name | Description |
|---|---|---|
| int | row | Starting row index of range of cells |
| int | column | Starting column index of range of cells |
| int | row2 | Ending row index of range of cells |
| int | column2 | Ending column index of range of cells |
Returns
| Type | Description |
|---|---|
| Cell | A range of cells at the special rows, columns |
Exceptions
| Type | Condition |
|---|---|
| IndexOutOfRangeException | Specified row or column index is less than 0 or greater than or equal to the row count or column count. |
| IndexOutOfRangeException | Specified starting row index is not valid; must be between zero and the total number of rows |
| IndexOutOfRangeException | Specified starting column index is not valid; must be between zero and the total number of columns |
| IndexOutOfRangeException | Specified starting row index is not valid; must be between zero and the total number of column header rows |
| IndexOutOfRangeException | Specified starting column index is not valid; must be between zero and the total number of row header columns |
| IndexOutOfRangeException | Specified ending row index is not valid; must be between zero and the total number of rows |
| IndexOutOfRangeException | Specified ending column index is not valid; must be between zero and the total number of columns |
| IndexOutOfRangeException | Specified ending row index is not valid; must be between zero and the total number of column header rows |
| IndexOutOfRangeException | Specified ending column index is not valid; must be between zero and the total number of row header columns |