Class ColumnSelection

A selection of one or more worksheet columns for applying properties, formatting, and operations in batch.

Inheritance
System.Object
SelectionBase
RowColumnSelectionBase
ColumnSelection
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Telerik.Windows.Documents.Spreadsheet.Model
Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public class ColumnSelection : RowColumnSelectionBase

Methods

AutoFitWidth()

Calculates and applies the optimal width for selected columns based on their content.

Declaration
public void AutoFitWidth()

ClearHidden()

Makes the selected columns visible if they are currently hidden.

Declaration
public void ClearHidden()

ClearWidth()

Resets the width of selected columns to the default worksheet column width.

Declaration
public void ClearWidth()

ExpandToFitNumberValuesWidth()

Expands column widths to accommodate numeric values without truncation, preserving custom widths.

Declaration
public void ExpandToFitNumberValuesWidth()

GetFromToIndexFromRange(CellRange, out Int32, out Int32)

Extracts the start and end column indices from a cell range.

Declaration
protected override void GetFromToIndexFromRange(CellRange cellRange, out int fromIndex, out int toIndex)
Parameters
CellRange cellRange

The cell range.
System.Int32 fromIndex

From index.
System.Int32 toIndex

To index.
Overrides

GetHidden()

Retrieves whether the selected columns are hidden in the worksheet view.

Declaration
public RangePropertyValue<bool> GetHidden()
Returns
RangePropertyValue<System.Boolean>

The value of the hidden property

GetOutlineLevel()

Retrieves the outline grouping level for the selected columns.

Declaration
public override RangePropertyValue<int> GetOutlineLevel()
Returns
RangePropertyValue<System.Int32>

The outline level.
Overrides

GetWidth()

Retrieves the width value for the selected columns, indicating whether the value is uniform or varies.

Declaration
public RangePropertyValue<ColumnWidth> GetWidth()
Returns
RangePropertyValue<ColumnWidth>

The width for the selection.

Insert()

Inserts new columns at the position of the selected columns, shifting existing columns to the right.

Declaration
public bool Insert()
Returns
System.Boolean

The value indicating whether the insert was successful.

Remove()

Deletes the selected columns from the worksheet, shifting remaining columns to the left.

Declaration
public void Remove()

SetBorders(CellBorders)

Applies border styling to all cells in the selected columns.

Declaration
public override void SetBorders(CellBorders value)
Parameters
CellBorders value

The value.
Overrides

SetHidden(Boolean)

Hides or shows the selected columns in the worksheet view.

Declaration
public void SetHidden(bool value)
Parameters
System.Boolean value

The value indicating whether the selected columns are hidden.

SetWidth(ColumnWidth)

Applies the specified width to all selected columns.

Declaration
public void SetWidth(ColumnWidth value)
Parameters
ColumnWidth value

The value.