Gets the formula associated with the data area of the column. Syntax Property Value A Formula instance representing the formula for the data area of the column or null if no formula is applied. Remarks When the column formula is set and the table is resized to give it more rows, the new cells in the column will ha...
Gets the WorksheetRegion which represents the region of cells in the data area of the column. Syntax
Gets the filter applied to the column. Syntax Property Value A Filter-derived instance if a filter is applied or null if the column is not filtered. Remarks Filters are not constantly evaluated as data within the table changes. Filters are applied to the table only when they are added or removed on a column in the...
Gets the WorksheetCell which represents the header cell for the column. Syntax Property Value A WorksheetCell which represents the header cell for the column or null if the header row is not visible in the table.
Gets the 0-based index of the column in the owning WorksheetTable.Columns collection. Syntax Property Value The 0-based index of the column in its collection or -1 if the column has been removed from the table.
Gets or sets the name of the column. Syntax Property Value The unique name of the column within the owning WorksheetTable. Exceptions Exception Description System.InvalidOperationException From the setter if column was removed from the table. Remarks If the header row is visible in the WorksheetTable, the name of ...
Sets the formula to use in the data cells in the column. Syntax Parameters formula The formula for the data cells of the column or null to remove the current column formula.overwriteExistingValues True to overwrite the existing cells values and apply the formula to all data cells in the column. False to only apply...
Sets the formula to use in the data cells in the column. Overload List
Gets or sets the sort condition used to sort the column in the table. Syntax Property Value The SortCondition-derived instance used to sort the column or null of the column is not sorted. Exceptions Exception Description System.InvalidOperationException From the setter if column was removed from the table. Remarks...
Gets the WorksheetTable to which the column belongs. Syntax Property Value The WorksheetTable to which the column belongs or null if the column has been removed from the table.