Spreadsheet::Gnumeric::StyleRegion

Helper class for storing style information extracted from a Gnumeric spreadsheet. The style information is already mostly converted in the style_attributes slot, and the other slots record which cells the styles pertain to. According to the file format documentation, the regions describe disjoint rectangles that cover the entire spreadsheet, and in practice extend far beyond the region that is actually in use.

See the Spreadsheet::ReadGnumeric class for further information.

Accessors and methods

end_col

Returns or sets the maximum column (zero based).

end_row

Returns or sets the maximum row (zero based).

start_col

Returns or sets the minimim column (zero based).

start_row

Returns or sets the minimim row (zero based).

style_attributes

Contains a hashref of attributes extracted from the <Style> and <Font> element XML attributes. These are mapped from the original Gnumeric attribute names to hash key names compatible with Spreadsheet::Read according to the following table:

       Gnumeric         Spreadsheet::Read
       =============    =================
       Back             bgcolor
       Bold             bold   
       Fore             fgcolor
       Format           format 
       HAlign           halign 
       Hidden           hidden 
       Indent           indent
       Italic           italic
       Locked           locked
       PatternColor     pattern_color
       Rotation         rotation
       Script           script
       Shade            shade
       ShrinkToFit      shrink_to_fit
       Unit             size
       StrikeThrough    strike_through
       Underline        uline
       VAlign           valign
       WrapText         wrap

The values for the three names that end in "Color" may be converted according to the convert_colors flag of Spreadsheet::ReadGnumeric. The values with "_" in the Spreadsheet::Read names don't actually have a Spreadsheet::Read equivalent (which probably means they don't have an Excel equivalent).