Excel.Interfaces.ConditionalRangeFormatLoadOptions interface
A format object encapsulating the conditional formats range's font, fill, borders, and other properties.
Remarks
Properties
$all | Specifying |
borders | Collection of border objects that apply to the overall conditional format range. |
fill | Returns the fill object defined on the overall conditional format range. |
font | Returns the font object defined on the overall conditional format range. |
number |
Represents Excel's number format code for the given range. For more information about Excel number formatting, see Number format codes. Cleared if |
Property Details
$all
Warning
This API is now deprecated.
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
Warning
This API is now deprecated.
Collection of border objects that apply to the overall conditional format range.
borders?: Excel.Interfaces.ConditionalRangeBorderCollectionLoadOptions;
Property Value
Remarks
fill
Warning
This API is now deprecated.
Returns the fill object defined on the overall conditional format range.
fill?: Excel.Interfaces.ConditionalRangeFillLoadOptions;
Property Value
Remarks
font
Warning
This API is now deprecated.
Returns the font object defined on the overall conditional format range.
font?: Excel.Interfaces.ConditionalRangeFontLoadOptions;
Property Value
Remarks
numberFormat
Warning
This API is now deprecated.
Represents Excel's number format code for the given range. For more information about Excel number formatting, see Number format codes. Cleared if null
is passed in.
numberFormat?: boolean;
Property Value
boolean
Remarks
Office Add-ins