FsTable Type
Creates an FsTable from the given name and FsRangeAddres, with totals row shown and header row shown or not, accordingly.
Constructors
Constructor | Description |
Full Usage:
FsTable(name, rangeAddress, ?showTotalsRow, ?showHeaderRow)
Parameters:
string
rangeAddress : FsRangeAddress
?showTotalsRow : bool
?showHeaderRow : bool
Returns: FsTable
|
|
Instance members
Instance member | Description | ||
|
|
||
|
|||
Full Usage:
this.Field
Parameters:
string
cellsCollection : FsCellsCollection
Returns: FsTableField
|
|||
Full Usage:
this.GetColumns
Parameters:
FsCellsCollection
-
The FsCellsCollection associated with this FsTable.
Returns: FsColumn seq
|
|
||
Full Usage:
this.GetDataCellsOfColumnAt
Parameters:
FsCellsCollection
colIndex : int32
Returns: FsCell seq
|
Column index must fit the FsCellsCollection, not the FsTable!
|
||
Full Usage:
this.GetField
Parameters:
string
cellsCollection : FsCellsCollection
Returns: FsTableField
|
|
||
Full Usage:
this.GetFieldAt
Parameters:
int
cellsCollection : FsCellsCollection
Returns: FsTableField
|
|
||
Full Usage:
this.GetFieldIndex
Parameters:
string
cellsCollection : FsCellsCollection
Returns: int
|
|
||
Full Usage:
this.GetFieldNames
Parameters:
FsCellsCollection
Returns: Dictionary<string, FsTableField>
|
|||
Full Usage:
this.GetFields
Parameters:
FsCellsCollection
Returns: FsTableField seq
|
|||
Full Usage:
this.GetHeaderCellOfColumn
Parameters:
FsCellsCollection
column : FsRangeColumn
Returns: FsCell
|
|
||
Full Usage:
this.GetHeaderCellOfColumnAt
Parameters:
FsCellsCollection
colIndex : int
Returns: FsCell
|
|
||
Full Usage:
this.GetHeaderCellOfTableField
Parameters:
FsCellsCollection
tableField : FsTableField
Returns: FsCell
|
|||
Full Usage:
this.GetHeaderCellOfTableFieldAt
Parameters:
FsCellsCollection
tableFieldIndex : int
Returns: FsCell
|
|
||
|
|
||
Full Usage:
this.GetRows
Parameters:
FsCellsCollection
-
The FsCellsCollection associated with this FsTable.
Returns: FsRow seq
|
|
||
Full Usage:
this.GetUniqueName
Parameters:
string
-
Header name that was tried to be used.
initialOffset : int32
-
First number that together with the originalName, leads to a unique column header.
enforceOffset : bool
-
If true, the initial offset is always applied.
Returns: string
|
|
||
Full Usage:
this.InitFields
Parameters:
string seq
|
|||
Full Usage:
this.Name
Returns: string
|
|||
Full Usage:
this.RenameField
Parameters:
string
newName : string
|
|
||
|
Updates the TableFields according to the range of the table and the underlying cellcollection. For this, maps over the range of the table and sets the header of the table fields to the value of the cell. If no cell value is set, the header value and the underlying cell value are set to a default value.
|
||
Full Usage:
this.RescanRange
|
|||
Full Usage:
this.ShowHeaderRow
|
|||
Full Usage:
this.TryGetHeaderCellByFieldName
Parameters:
FsCellsCollection
fieldName : string
Returns: FsCell option
|
|||
Full Usage:
this.TryGetHeaderCellOfColumn
Parameters:
FsCellsCollection
column : FsRangeColumn
Returns: FsCell option
|
|||
Full Usage:
this.TryGetHeaderCellOfColumnAt
Parameters:
FsCellsCollection
colIndex : int
Returns: FsCell option
|
|||
Full Usage:
this.TryGetHeaderCellOfTableFieldAt
Parameters:
FsCellsCollection
tableFieldIndex : int
Returns: FsCell option
|
|||
Full Usage:
this.TryGetHeaderRow
Parameters:
FsCellsCollection
Returns: FsRow option
|
|
Static members
Static member | Description | ||
Full Usage:
FsTable.addFields tableFields table
Parameters:
FsTableField seq
table : FsTable
Returns: FsTable
|
|||
|
|||
Full Usage:
FsTable.getDataCellsOfColumnIndexAt cellsCollection colIndex table
Parameters:
FsCellsCollection
colIndex : int
table : FsTable
Returns: FsCell seq
|
Column index must fit the FsCellsCollection, not the FsTable!
|
||
Full Usage:
FsTable.getField name cellsCollection table
Parameters:
string
cellsCollection : FsCellsCollection
table : FsTable
Returns: FsTableField
|
|
||
Full Usage:
FsTable.getHeaderCellOfColumn cellsCollection column table
Parameters:
FsCellsCollection
column : FsRangeColumn
table : FsTable
Returns: FsCell
|
|
||
Full Usage:
FsTable.getHeaderCellOfColumnIndexAt cellsCollection colIndex table
Parameters:
FsCellsCollection
colIndex : int
table : FsTable
Returns: FsCell
|
|
||
Full Usage:
FsTable.getHeaderCellOfTableField cellsCollection tableField table
Parameters:
FsCellsCollection
tableField : FsTableField
table : FsTable
Returns: FsCell
|
|||
Full Usage:
FsTable.getHeaderCellOfTableFieldIndexAt cellsCollection tableFieldIndex table
Parameters:
FsCellsCollection
tableFieldIndex : int
table : FsTable
Returns: FsCell
|
|
||
Full Usage:
FsTable.getUniqueNames originalName initialOffset enforceOffset table
Parameters:
string
-
Header name that was tried to be used.
initialOffset : int32
-
First number that together with the originalName, leads to a unique column header.
enforceOffset : bool
-
If true, the initial offset is always applied.
table : FsTable
-
The FsTable on which this function is called.
Returns: string
|
|
||
|
|||
|
|
||
|
|||
Full Usage:
FsTable.tryGetHeaderCellByFieldName cellsCollection fieldName table
Parameters:
FsCellsCollection
fieldName : string
table : FsTable
Returns: FsCell option
|
|||
Full Usage:
FsTable.tryGetHeaderCellOfColumn cellsCollection column table
Parameters:
FsCellsCollection
column : FsRangeColumn
table : FsTable
Returns: FsCell option
|
|||
Full Usage:
FsTable.tryGetHeaderCellOfColumnIndexAt cellsCollection colIndex table
Parameters:
FsCellsCollection
colIndex : int
table : FsTable
Returns: FsCell option
|
|||
Full Usage:
FsTable.tryGetHeaderCellOfTableFieldIndexAt cellsCollection tableFieldIndex table
Parameters:
FsCellsCollection
tableFieldIndex : int
table : FsTable
Returns: FsCell option
|