Class Spreadsheet::Format
In: lib/spreadsheet/format.rb
Parent: Object

Formatting data

Methods

Included Modules

Spreadsheet::Datatypes Spreadsheet::Encodings

External Aliases

text_direction -> reading_order
text_direction= -> reading_order=
indent_level -> indent
indent_level= -> indent=

Attributes

font  [RW] 
name  [RW] 
number_format  [RW] 
pattern  [RW] 
rotation  [R]  Text rotation
used_merge  [RW] 

Public Class methods

Public Instance methods

Combined method for both horizontal and vertical alignment. Sets the first valid value (e.g. Format#align = :justify only sets the horizontal alignment. Use one of the aliases prefixed with :v if you need to disambiguate.)

This is essentially a backward-compatibility method and may be removed at some point in the future.

Returns an Array containing the status of the four borders: bottom, top, right, left

Activate or deactivate all four borders (left, right, top, bottom)

Returns an Array containing the colors of the four borders: bottom, top, right, left

Set all four border colors to color (left, right, top, bottom)

Backward compatibility method. May disappear at some point in the future.

Is the cell formatted as a Date?

Is the cell formatted as a Date or Time?

Is the cell formatted as a DateTime?

merge!()

Alias for center_across!

Set the Text rotation Valid values: Integers from -90 to 90, or :stacked (sets rotation_stacked to true)

Is the cell formatted as a Time?

[Validate]