Excel.Interfaces.RangeFormatData interface

Package:

excel

An interface describing the data returned by calling rangeFormat.toJSON().

Properties

autoIndent	Specifies if text is automatically indented when text alignment is set to equal distribution.
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.
indentLevel	An integer from 0 to 250 that indicates the indent level.
protection	Returns the format protection object for a range.
readingOrder	The reading order for the range.
rowHeight	The height of all rows in the range. If the row heights are not uniform, null will be returned.
shrinkToFit	Specifies if text automatically shrinks to fit in the available column width.
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

autoIndent

Specifies if text is automatically indented when text alignment is set to equal distribution.

TypeScript

autoIndent?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

borders

Collection of border objects that apply to the overall range.

TypeScript

borders?: Excel.Interfaces.RangeBorderData[];

Property Value

Excel.Interfaces.RangeBorderData[]

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.

TypeScript

columnWidth?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.2 ]

fill

Returns the fill object defined on the overall range.

TypeScript

fill?: Excel.Interfaces.RangeFillData;

Property Value

Excel.Interfaces.RangeFillData

Remarks

[ API set: ExcelApi 1.1 ]

font

Returns the font object defined on the overall range.

TypeScript

font?: Excel.Interfaces.RangeFontData;

Property Value

Excel.Interfaces.RangeFontData

Remarks

[ API set: ExcelApi 1.1 ]

horizontalAlignment

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

TypeScript

horizontalAlignment?: Excel.HorizontalAlignment | "General" | "Left" | "Center" | "Right" | "Fill" | "Justify" | "CenterAcrossSelection" | "Distributed";

Property Value

Excel.HorizontalAlignment | "General" | "Left" | "Center" | "Right" | "Fill" | "Justify" | "CenterAcrossSelection" | "Distributed"

Remarks

[ API set: ExcelApi 1.1 ]

indentLevel

An integer from 0 to 250 that indicates the indent level.

TypeScript

indentLevel?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.9 ]

protection

Returns the format protection object for a range.

TypeScript

protection?: Excel.Interfaces.FormatProtectionData;

Property Value

Excel.Interfaces.FormatProtectionData

Remarks

[ API set: ExcelApi 1.2 ]

readingOrder

The reading order for the range.

TypeScript

readingOrder?: Excel.ReadingOrder | "Context" | "LeftToRight" | "RightToLeft";

Property Value

Excel.ReadingOrder | "Context" | "LeftToRight" | "RightToLeft"

Remarks

[ API set: ExcelApi 1.9 ]

rowHeight

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

TypeScript

rowHeight?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.2 ]

shrinkToFit

Specifies if text automatically shrinks to fit in the available column width.

TypeScript

shrinkToFit?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

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.

TypeScript

textOrientation?: number;

Property Value

number

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.

TypeScript

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.

TypeScript

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.

TypeScript

verticalAlignment?: Excel.VerticalAlignment | "Top" | "Center" | "Bottom" | "Justify" | "Distributed";

Property Value

Excel.VerticalAlignment | "Top" | "Center" | "Bottom" | "Justify" | "Distributed"

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

TypeScript

wrapText?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.1 ]