- 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
- Structs
- Enums
-
Interfaces
- IAggregationSupport
- IArraySupport
- IAutoFilterIndexSupport
- IAutoSortIndexSupport
- ICalculationSupport
- IChartSupport
- IChildModelSupport
- IClearDataSupport
- IClearFormulasSupport
- ICustomFunctionSupport
- ICustomFunctionSupport2
- ICustomNameSupport
- ICustomNameSupport2
- ICustomNameSupport3
- IDataSourceSupport
- IDataSourceSupport1
- IDisjointSelections
- IEditableObjectSupport
- IEnhancedCustomNameSupport
- IEnhancedCustomNameSupport2
- IErrorTextSupport
- IExpressionSupport
- IExpressionSupport2
- IGroupFooterStyleSupport
- IGroupFooterSupport
- IGroupSupport
- IGroupSupport2
- IItemTypeSupport
- IIterationSupport
- IMapper
- IMapperSupport
- IMovable
- INameSupport
- INameSupport2
- INamedStyleSupport
- INonEmptyCells
- INotifySelectionChanged
- INotifySheetAxisModelChanging
- IObjectExpressionSupport
- IOptimizedEnumerationSupport
- IOptimizedEnumerationSupport2
- IOptimizedEnumerationSupport3
- IOptimizedEnumerationSupport5
- IOptimizedEnumerationSupport6
- IOptimizedEnumerationSupport7
- IOptimizedSheetAxisModelSupport
- IOptimizedSheetAxisModelSupport2
- IOptimizedSheetAxisModelSupport3
- IOptimizedSheetAxisModelSupport4
- IParentStyleModelSupport
- IParseFormatSupport
- IQuerySelection
- IRangeSupport
- ISheetAxisModel
- ISheetDataModel
- ISheetSelectionModel
- ISheetSpanModel
- ISheetSpanModelChangingEventSupport
- ISheetStyleModel
- ISuspendFormulaParsing
- ITableColumn
- ITableColumnCollection
- ITableDataColumn
- ITableModelSupport
- ITableRange
- ITableRangeManager
- IUnboundRowAddNewRowSupport
- IUnboundRowSupport
- Delegates
- 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.ITableRange
ITableRange Interface
Represents an ITableRange interface.
Namespace: FarPoint.Win.Spread.Model
Assembly: FarPoint.Win.Spread.dll
Syntax
public interface ITableRange : ISerializeData, ISerializePresentation, ISerializablePublic Interface ITableRange
Inherits ISerializeData, ISerializePresentation, ISerializableProperties
| Name | Description |
|---|---|
| Columns | Gets a collection of ITableColumn objects. |
| Comment | Gets or sets the table comment. |
| DataRange | Gets the data range of the ITableRange. |
| DataSource | Gets the IRange table source. |
| FirstColumnIndex | Gets the first column index. |
| FirstRowIndex | Gets the first row index. |
| HeaderRowIndex | Gets the row index of the header row. |
| HeaderRowVisible | Gets or sets whether the header is visible. |
| LastColumnIndex | Get the last column index. |
| LastRowIndex | Gets the last row index. |
| Name | Gets or sets the ITableRange name. |
| TotalRowIndex | Gets the total row index. |
| TotalRowVisible | Gets or sets whether the total row is visible. |
Methods
| Name | Description |
|---|---|
| GetColumnIndex(string) | Gets the column index by name. |
| GetColumnName(int) | Gets the name of the column |
| GetDataColumnFormula(int) | Gets data fomula from a special column. |
| GetUniqueColumnName(string, int) | Gets a unique name for a table column. |
| SetDataColumnFormula(int, string) | Sets data formula to a special column. |
| SyncDataInRange(int, int, int, int) | Synchronizes table data in a specific range. |
Events
| Name | Description |
|---|---|
| NameChanged | Occurs when the table name is changed. |
| NameChanging | Occurs when the table name is about to change. |
| TableRangeChanged | Occurs when the table range is changed. |
| TableRangeChanging | Occurs when the table range is about to change. |