Excel.Interfaces.RangeFormatLoadOptions interface

A format object encapsulating the range's font, fill, borders, alignment, and other properties.

Remarks

[ API set: ExcelApi 1.1 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

borders

Collection of border objects that apply to the overall range.

columnWidth

Specifies the width of all columns within the range. If the column widths are not uniform, null will be returned.

fill

Returns the fill object defined on the overall range.

font

Returns the font object defined on the overall range.

horizontalAlignment

Represents the horizontal alignment for the specified object. See Excel.HorizontalAlignment for details.

protection

Returns the format protection object for a range.

rowHeight

The height of all rows in the range. If the row heights are not uniform, null will be returned.

textOrientation

The text orientation of all the cells within the range. The text orientation should be an integer either from -90 to 90, or 180 for vertically-oriented text. If the orientation within a range are not uniform, then null will be returned.

useStandardHeight

Determines if the row height of the Range object equals the standard height of the sheet. Returns true if the row height of the Range object equals the standard height of the sheet. Returns null if the range contains more than one row and the rows aren't all the same height. Returns false otherwise. Note: This property is only intended to be set to true. Setting it to false has no effect.

useStandardWidth

Specifies if the column width of the Range object equals the standard width of the sheet. Returns true if the column width of the Range object equals the standard width of the sheet. Returns null if the range contains more than one column and the columns aren't all the same height. Returns false otherwise. Note: This property is only intended to be set to true. Setting it to false has no effect.

verticalAlignment

Represents the vertical alignment for the specified object. See Excel.VerticalAlignment for details.

wrapText

Specifies if Excel wraps the text in the object. A null value indicates that the entire range doesn't have a uniform wrap setting

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

borders

Collection of border objects that apply to the overall range.

borders?: Excel.Interfaces.RangeBorderCollectionLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

columnWidth

Specifies the width of all columns within the range. If the column widths are not uniform, null will be returned.

columnWidth?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

fill

Returns the fill object defined on the overall range.

fill?: Excel.Interfaces.RangeFillLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

font

Returns the font object defined on the overall range.

font?: Excel.Interfaces.RangeFontLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.1 ]

horizontalAlignment

Represents the horizontal alignment for the specified object. See Excel.HorizontalAlignment for details.

horizontalAlignment?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

protection

Returns the format protection object for a range.

protection?: Excel.Interfaces.FormatProtectionLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.2 ]

rowHeight

The height of all rows in the range. If the row heights are not uniform, null will be returned.

rowHeight?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

textOrientation

The text orientation of all the cells within the range. The text orientation should be an integer either from -90 to 90, or 180 for vertically-oriented text. If the orientation within a range are not uniform, then null will be returned.

textOrientation?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

useStandardHeight

Determines if the row height of the Range object equals the standard height of the sheet. Returns true if the row height of the Range object equals the standard height of the sheet. Returns null if the range contains more than one row and the rows aren't all the same height. Returns false otherwise. Note: This property is only intended to be set to true. Setting it to false has no effect.

useStandardHeight?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

useStandardWidth

Specifies if the column width of the Range object equals the standard width of the sheet. Returns true if the column width of the Range object equals the standard width of the sheet. Returns null if the range contains more than one column and the columns aren't all the same height. Returns false otherwise. Note: This property is only intended to be set to true. Setting it to false has no effect.

useStandardWidth?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

verticalAlignment

Represents the vertical alignment for the specified object. See Excel.VerticalAlignment for details.

verticalAlignment?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]

wrapText

Specifies if Excel wraps the text in the object. A null value indicates that the entire range doesn't have a uniform wrap setting

wrapText?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]