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).