- FarPoint.CalcEngine Assembly
- FarPoint.Excel Assembly
- FarPoint.Web.Chart Assembly
-
FarPoint.Web.Spread Assembly
-
FarPoint.Web.Spread
-
Classes
- AlternatingRow
- AlternatingRows
- Appearance
- AppearanceProperty
- AutoFilter
- AutoFilteredColumnEventArgs
- AutoFilteringColumnEventArgs
- AverageConditionalFormattingRule
- Background
- BaseCellType
- BaseDropDownCellType
- BaseFilterItem
- BaseSparkline
- BestFitColumnRule
- BetweenValuesConditionalFormattingRule
- BlankConditionalFormattingRule
- Border
- BorderProperty
- ButtonCellType
- CalendarDropDownStyleInfo
- Cell
- CellTypeConverter
- Cells
- CheckBoxCellType
- ColorFilterItem
- Column
- ColumnFooter
- ColumnHeader
- ColumnHeaderFilterCellType
- ColumnSparklineRenderer
- Columns
- Columns.DefaultColumn
- ComboBoxCellType
- CommandBarInfo
- ConditionalFormat
- ConditionalFormatCollection
- ConditionalFormatInfo
- ConditionalFormatting
- ConditionalFormattingColorValue
- ConditionalFormattingColorValueCollection
- ConditionalFormattingIconRuleSet
- ConditionalFormattingIconValue
- ConditionalFormattingModel
- ConditionalFormattingModelEventArgs
- ConditionalFormattingRule
- ConditionalFormattingRulePropertyChangedEventArgs
- ConditionalFormattingValue
- ConditionalFormattingValueCollection
- ContextMenu
- ContextMenuCollection
- ContextMenuStyle
- CreateButtonEventArgs
- CreateChildViewEventArgs
- CurrencyCellType
- CurrencyCellType.EditModeSettings
- CustomFilterItem
- DataFieldConverter
- DatabarConditionalFormattingRule
- DateTimeCellType
- DateTimeCellType.EditModeSettings
- DefaultFilterItem
- DefaultRowFilter
- DefaultSkins
- DefaultSparklineContainer
- DefaultStyleCollection
- DesignTimeCellTypeConverter
- DoubleCellType
- DoubleCellType.EditModeSettings
- DynamicFilterItem
- EmptyCellType
- ErrorConditionalFormattingRule
- ErrorForm
- ExcelBaseSparkLineRenderer
- ExcelSparkline
- ExcelSparklineGroup
- ExcelSparklineSetting
- ExpressionConsumerFormulaInfo
- ExtraRendererSettings
- FetchGroupTextEventArgs
- FilterBar
- FilterBarCellType
- FilterColumnDefinition
- FilterColumnDefinitionCollection
- FilterCondition
- FilterItemCollection
- FilterItemValue
- FilterItemValueCollection
- FloatingObject
- FormulaConditionalFormattingRule
- FormulaEntry
- FormulaEntryCollection
- FormulaExtender
- FormulaRestrictedException
- FpSpread
- FpSpreadTemplateReplacement
- GeneralCellType
- GroupInfo
- GroupInfoCollection
- GroupingEventArgs
- HideRowFilter
- HierBarInfo
- HighlightConditionalFormattingRule
- HighlightConditionalFormattingStyle
- HyperLinkCellType
- IconFilterItem
- IconSetConditionalFormattingRule
- ImageCellType
- Inset
- IntegerCellType
- IntegerCellType.EditModeSettings
- ItemEventArgs
- ItemEventArgs<T>
- ItemPropertyEventArgs<T>
- ItemTrackedEventArgs
- LabelCellType
- LandscapeRule
- LayoutCell
- LayoutCells
- LayoutColumn
- LayoutColumns
- LayoutRow
- LayoutRows
- LayoutTemplate
- LineSparklineRenderer
- ListBoxCellType
- ListItem
- MeasureIconSizeEventArgs
- MenuItem
- MenuItemClickEventArgs
- MenuItemCollection
- MultiColumnComboBoxCellType
- MultiValuesFilterItem
- NamedStyle
- NamedStyleCollection
- NamedStyleCollectionEventArgs
- PagerInfo
- ParentStyleNameConverter
- PercentCellType
- PrePaintConditionalFormattingRule
- PrePaintResult
- PrePaintTextConditionalFormattingRule
- PrePaintTextResult
- PreviewRowInfo
- PreviewRowTemplateContainer
- PrintAbortEventArgs
- PrintBackgroundEventArgs
- PrintEventArgs
- PrintExternalImageEventArgs
- PrintInfo
- PrintMargin
- PrintPDFEventArgs
- PropertyTrackChangedEventArgs
- RadioButtonListCellType
- RangeElement<T>
- RegExpCellType
- ReloadSheetCellRangeFormulaEventArgs
- Row
- RowEditTemplateContainer
- RowHeader
- Rows
- Rows.DefaultRow
- SaveExcelEventArgs
- ScaleRule
- SheetCorner
- SheetSkin
- SheetStyleProperty
-
SheetView
- Constructors
- Fields
- Properties
-
Methods
- AddChart
- AddColumns
- AddImage
- AddRowToDataSource
- AddRows
- AddSpanCell
- AddSparkline
- AddSquareSparkline
- AddUnboundRows
- AutoFilterColumn
- AutoFilterReset
- ClearConditionalFormating
- ClearConditionalFormatings
- ClearRange
- ClearRowFilter
- ClearSparklineGroupsInRange
- ClearSparklines
- CreateColumnAxisModel
- CreateDataModel
- CreateRowAxisModel
- CreateSelectionModel
- CreateSpanModel
- CreateStyleModel
- ExpandAll
- ExpandRow
- FindChildView
- FirePropertyChanged
- FlushData
- GetCellFromTag
- GetCellType
- GetChildRelation
- GetChildView
- GetChildViewName
- GetChildVisible
- GetClip
- GetClipValue
- GetColumnAllowFilter
- GetColumnAutoText
- GetColumnFromTag
- GetColumnLabel
- GetColumnMerge
- GetColumnSizeable
- GetColumnSortIndicator
- GetColumnVisible
- GetColumnWidth
- GetConditionalFormatting
- GetCustomName
- GetDataKey
- GetDefaultEditor
- GetDefaultRenderer
- GetDropDownFilterItems
- GetEditor
- GetExpression
- GetFormatter
- GetFormula
- GetGroupFooterInfo
- GetGroupInfo
- GetModelColumnFromViewColumn
- GetModelRowFromViewRow
- GetNote
- GetRenderer
- GetRowAutoText
- GetRowExpandable
- GetRowFromTag
- GetRowHeight
- GetRowLabel
- GetRowMerge
- GetRowSizeable
- GetRowVisible
- GetSelections
- GetSpanCell
- GetSparkline
- GetStyleInfo
- GetTag
- GetText
- GetUnboundValue
- GetValidConditionalFormat
- GetValue
- GetViewColumnFromModelColumn
- GetViewRowFromModelRow
- GroupSparkline
- InitPropArray
- InitStyle
- InvalidateRowFilter
- IsColumnBound
- IsRowBound
- IsRowExpanded
- LoadFormulas
- LoadTextFile
- LoadViewState
- MoveColumn
- MoveRow
- OnAddColumnFooterRows
- OnAddColumnHeaderRows
- OnAddColumns
- OnAddRowHeaderColumns
- OnAddRows
- OnDataModelChanged
- OnRemoveColumnFooterRows
- OnRemoveColumnHeaderRows
- OnRemoveColumns
- OnRemoveRowHeaderColumns
- OnRemoveRows
- Open
- OpenExcel
- Recalculate
- RecalculateAll
- RemoveColumns
- RemoveRows
- RemoveSpanCell
- Reset
- ResetViewColumnIndexes
- ResetViewRowIndexes
- Save
- SaveHtml
- SaveTextFile
- SaveTextFileRange
- SaveViewState
- SetChildVisible
- SetClip
- SetClipValue
- SetColumnLabel
- SetColumnMerge
- SetColumnSizeable
- SetColumnSortIndicator
- SetColumnVisible
- SetColumnWidth
- SetConditionalFormatting
- SetExpression
- SetFormula
- SetModelDataColumn
- SetNote
- SetRowExpandable
- SetRowHeight
- SetRowLabel
- SetRowMerge
- SetRowSizeable
- SetRowVisible
- SetStyleInfo
- SetTag
- SetText
- SetValue
- ShouldSerializePrintInfo
- Sort
- SortColumns
- SortRows
- ToString
- UngroupSparkline
- SheetViewCollection
- SheetViewStateEventArgs
- SmartPaperRule
- SmartPrintRule
- SmartPrintRulesCollection
- SortInfo
- Sparkline
- SparklineModelUpdateEventArgs
- SpreadCommandEventArgs
- SpreadControlBuilder
- SpreadDataSource
- SpreadDataSourceView
- SpreadFontStyle
- SpreadImage
- SpreadImageCollection
- SpreadImageCollectionEditor
- SpreadImageRender
- SpreadSparklineRenderes
- StateList<T>
- StateManaged
- StyleInfo
- StyleNameConverter
- StyleRowFilter
- TabInfo
- TagCloudCellType
- TextCellType
- TextConditionalFormattingRule
- ThreeColorScaleConditionalFormattingRule
- TimePeriodConditionalFormattingRule
- TitleInfo
- Top10FilterItem
- TopRankedValuesConditionalFormattingRule
- TouchInfo
- TouchStrip
- TouchStripCollection
- TouchStripItem
- TouchStripItemClickEventArgs
- TouchStripItemCollection
- TwoColorScaleConditionalFormattingRule
- UnaryComparisonConditionalFormattingRule
- UniqueOrDuplicatedConditionalFormattingRule
- ValidatorCollection
- WinLossSparklineRenderer
- WorksheetLayoutCell
- WorksheetLayoutCells
- WorksheetTemplate
- YearMonthFormat
- Structs
- Enums
- Interfaces
- Delegates
-
Classes
- FarPoint.Web.Spread.Chart
- FarPoint.Web.Spread.Data
- FarPoint.Web.Spread.Editor
- FarPoint.Web.Spread.Model
- FarPoint.Web.Spread.Renderer
-
FarPoint.Web.Spread
- FarPoint.Web.Spread.Extender Assembly
FarPoint.Web.Spread.SheetView.GetClip
GetClip Method
GetClip(int, int, int, int)
Gets a tab-delimited string that contains the formatted text in a specified range.
Declaration
public string GetClip(int row, int column, int rowCount, int columnCount)Public Function GetClip(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer) As StringParameters
| Type | Name | Description |
|---|---|---|
| int | row | Starting row index, or -1 for all rows |
| int | column | Starting column index, or -1 for all columns |
| int | rowCount | Number of rows, or -1 for all rows |
| int | columnCount | Number of columns, or -1 for all columns |
Returns
| Type | Description |
|---|---|
| string | Tab-delimited string containing the formatted data in the range |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row is out of range; index must be between -1 (for all) and the number of rows |
| ArgumentOutOfRangeException | Specified column is out of range; index must be between -1 (for all) and the number of columns |
GetClip(int, int, int, int, bool)
Gets a tab-delimited string that contains the formatted text in a specified range.
Declaration
public string GetClip(int row, int column, int rowCount, int columnCount, bool unformatted)Public Function GetClip(row As Integer, column As Integer, rowCount As Integer, columnCount As Integer, unformatted As Boolean) As StringParameters
| Type | Name | Description |
|---|---|---|
| int | row | Starting row index, or -1 for all rows |
| int | column | Starting column index, or -1 for all columns |
| int | rowCount | Number of rows, or -1 for all rows |
| int | columnCount | Number of columns, or -1 for all columns |
| bool | unformatted | Specifies data in the clip is unformatted |
Returns
| Type | Description |
|---|---|
| string | Tab-delimited string containing the formatted data in the range |
Exceptions
| Type | Condition |
|---|---|
| ArgumentOutOfRangeException | Specified row is out of range; index must be between -1 (for all) and the number of rows |
| ArgumentOutOfRangeException | Specified column is out of range; index must be between -1 (for all) and the number of columns |