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>, IEnumerable
Properties
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 |