Returns and sets formatting information on a range of cells.
Constructors
Section titled "Constructors"SpreadsheetCellRangeFormat
new SpreadsheetCellRangeFormat(a: RangeWorksheetCellFormatBase): SpreadsheetCellRangeFormatReturns SpreadsheetCellRangeFormat
Properties
Section titled "Properties"propertyChanged
Section titled "propertyChanged"Inherited from: PropertyChangeNotifierExtended
propertyChanged: object$t: Typealignment
Section titled "alignment"alignment: HorizontalCellAlignmentfill: CellFillformatString
Section titled "formatString"formatString: stringhidden
Section titled "hidden"hidden: booleanindent
Section titled "indent"indent: numberlocked
Section titled "locked"locked: booleanrotation
Section titled "rotation"rotation: numbershrinkToFit
Section titled "shrinkToFit"shrinkToFit: booleanstyle
Section titled "style"style: WorkbookStyleverticalAlignment
Section titled "verticalAlignment"verticalAlignment: VerticalCellAlignmentwrapText
Section titled "wrapText"wrapText: booleanAccessors
Section titled "Accessors"Gets or sets the default font formatting.
get font(): IWorkbookFontReturns IWorkbookFont
Methods
Section titled "Methods"addListener
Section titled "addListener"Inherited from: PropertyChangeNotifierExtended
addListener(a: ITypedPropertyChangeListener$2<any, string>, b: boolean): voidParameters
- a:
ITypedPropertyChangeListener$2<any, string> - b:
boolean
Returns void
Inherited from: PropertyChangeNotifierExtended
d(a: any, b: string, c: any): voidParameters
- a:
any - b:
string - c:
any
Returns void
onPropertyValueChanged
Section titled "onPropertyValueChanged"Inherited from: PropertyChangeNotifierExtended
onPropertyValueChanged(a: any, b: string, c: any): voidParameters
- a:
any - b:
string - c:
any
Returns void
removeListener
Section titled "removeListener"Inherited from: PropertyChangeNotifierExtended
removeListener(a: ITypedPropertyChangeListener$2<any, string>): voidParameters
- a:
ITypedPropertyChangeListener$2<any, string>
Returns void
setBorders
Section titled "setBorders"Sets the specified borders for the associated range to the specified style and color.
setBorders(borders: SpreadsheetCellRangeBorders, borderColor: WorkbookColorInfo, borderStyle: CellBorderLineStyle): voidParameters
- borders:
SpreadsheetCellRangeBordersIdentifies the borders to be changed
- borderColor:
WorkbookColorInfoThe color for the borders
- borderStyle:
CellBorderLineStyleThe style for the borders