excel.interfaces.rangeformatloadoptions.yml

### YamlMime:TSType
name: Excel.Interfaces.RangeFormatLoadOptions
uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions:interface'
package: excel!
fullName: Excel.Interfaces.RangeFormatLoadOptions
summary: 'A format object encapsulating the range''s font, fill, borders, alignment, and other properties.'
remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: $all
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#$all:member'
    package: excel!
    fullName: $all
    summary: >-
      Specifying `$all` for the LoadOptions loads all the scalar properties (e.g.: `Range.address`<!-- -->) but not the
      navigational properties (e.g.: `Range.format.fill.color`<!-- -->).
    remarks: ''
    isPreview: false
    isDeprecated: false
    syntax:
      content: '$all?: boolean;'
      return:
        type: boolean
  - name: borders
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#borders:member'
    package: excel!
    fullName: borders
    summary: Collection of border objects that apply to the overall range.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'borders?: Excel.Interfaces.RangeBorderCollectionLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.RangeBorderCollectionLoadOptions:interface" />'
  - name: columnWidth
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#columnWidth:member'
    package: excel!
    fullName: columnWidth
    summary: >-
      Specifies the width of all columns within the range. If the column widths are not uniform, `null` will be
      returned.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'columnWidth?: boolean;'
      return:
        type: boolean
  - name: fill
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#fill:member'
    package: excel!
    fullName: fill
    summary: Returns the fill object defined on the overall range.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'fill?: Excel.Interfaces.RangeFillLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.RangeFillLoadOptions:interface" />'
  - name: font
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#font:member'
    package: excel!
    fullName: font
    summary: Returns the font object defined on the overall range.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'font?: Excel.Interfaces.RangeFontLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.RangeFontLoadOptions:interface" />'
  - name: horizontalAlignment
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#horizontalAlignment:member'
    package: excel!
    fullName: horizontalAlignment
    summary: Represents the horizontal alignment for the specified object. See `Excel.HorizontalAlignment` for details.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'horizontalAlignment?: boolean;'
      return:
        type: boolean
  - name: protection
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#protection:member'
    package: excel!
    fullName: protection
    summary: Returns the format protection object for a range.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'protection?: Excel.Interfaces.FormatProtectionLoadOptions;'
      return:
        type: '<xref uid="excel!Excel.Interfaces.FormatProtectionLoadOptions:interface" />'
  - name: rowHeight
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#rowHeight:member'
    package: excel!
    fullName: rowHeight
    summary: 'The height of all rows in the range. If the row heights are not uniform, `null` will be returned.'
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'rowHeight?: boolean;'
      return:
        type: boolean
  - name: verticalAlignment
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#verticalAlignment:member'
    package: excel!
    fullName: verticalAlignment
    summary: Represents the vertical alignment for the specified object. See `Excel.VerticalAlignment` for details.
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'verticalAlignment?: boolean;'
      return:
        type: boolean
  - name: wrapText
    uid: 'excel!Excel.Interfaces.RangeFormatLoadOptions#wrapText:member'
    package: excel!
    fullName: wrapText
    summary: >-
      Specifies if Excel wraps the text in the object. A `null` value indicates that the entire range doesn't have a
      uniform wrap setting
    remarks: '\[ [API set: ExcelApi 1.1](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'wrapText?: boolean;'
      return:
        type: boolean