Class RangeColumn
A class that represents a single column of cells.
Inherited Members
Namespace: IronXL
Assembly: IronXL.dll
Syntax
public class RangeColumn : Range, IEnumerable<Cell>, IEnumerableProperties
Hidden
Gets or sets a value indicating whether this column is hidden.
Declaration
public bool Hidden { get; set; }Property Value
| Type | Description |
|---|---|
| System.Boolean |
RangeAddress
Address of the column.
Declaration
public RangeAddress RangeAddress { get; }Property Value
| Type | Description |
|---|---|
| RangeAddress |
Width
Gets or sets the width of the column.
Declaration
public int Width { get; set; }Property Value
| Type | Description |
|---|---|
| System.Int32 |
Methods
AddRange(Range)
Add range to the current column if they can be combined.
Declaration
public override Range AddRange(Range range)Parameters
| Type | Name | Description |
|---|---|---|
| Range | range | The range to add to the current working range. |
Returns
| Type | Description |
|---|---|
| Range | This Range allowing a fluent coding style. |
Overrides
Exceptions
| Type | Condition |
|---|---|
| System.InvalidOperationException | This range cannot be added to the current column because they are not on the same line or cannot be combined in one column |
AutoSizeColumn()
Changes width of the column to fit the content. NOTE: This method measures the text in the cell based on the font that is used for the cell. If the exact font is not found on the machine it will try to measure it with a defalt font. If the default could not be found, it will try to use any font available. Finally if there are no fonts found the exception will be thrown.
Declaration
public void AutoSizeColumn()Exceptions
| Type | Condition |
|---|---|
| System.ArgumentException | |
| FontException | Trown when no fonts found istalled on the machine. |
AutoSizeColumn(Boolean)
Changes width of the column to fit the content. NOTE: This method measures the text in the cell based on the font that is used for the cell. If the exact font is not found on the machine it will try to measure it with a defalt font. If the default could not be found, it will try to use any font available. Finally if there are no fonts found the exception will be thrown.
Declaration
public void AutoSizeColumn(bool useMergedCells)Parameters
| Type | Name | Description |
|---|---|---|
| System.Boolean | useMergedCells | If true, the width of merged cells will be taken into account. |
Exceptions
| Type | Condition |
|---|---|
| System.ArgumentException | |
| FontException | Trown when no fonts found istalled on the machine. |
SubtractRange(Range)
Subtract range from the current column if it can be subtracted.
Declaration
public override Range SubtractRange(Range range)Parameters
| Type | Name | Description |
|---|---|---|
| Range | range | The range to remove from the current working range. |
Returns
| Type | Description |
|---|---|
| Range | This Range allowing a fluent coding style. |
Overrides
Exceptions
| Type | Condition |
|---|---|
| System.InvalidOperationException | This range cannot be subtracted from the current column because result column isn't continuous |