NAME

       Excel::Template::Container::Format - Excel::Template::Container::Format

PURPOSE

       To format all children according to the parameters

NODE NAME

       FORMAT

INHERITANCE

       Excel::Template::Container

ATTRIBUTES

       Boolean attributes should be set to 1, 0, true, or false.

       Color values can be the color name or the color index. See "COLOURS IN EXCEL" in Spreadsheet::WriteExcel

       •   align

           Set to either left, center, right, fill, or justify. Default is left.  See also valign.

       •   bg_color

           Set to a color value. Default is none.

       •   bold

           This will set bold to on or off, depending on the boolean value.

       •   border

           Set  the border for all for edges of a cell. Also see bottom, top, left, and right.  Valid values are
           0 - 7.

           See "set_border()" in Spreadsheet::WriteExcel

       •   border_color

           Sets the color value for the  border.  See  also  border,  top_color,  bottom_color,  left_color  and
           right_color.

       •   bottom

           See border.

       •   bottom_color

           See border_color

       •   color

           This will set the color of the text, depending on color value. Default is black.

       •   fg_color

           Set to a color value. This color will be used in foreground of some patterns. See color to change the
           color of text. Also see bg_color and pattern.

       •   font

           This will sent the font face. Default is Arial.

       •   font_outline

           This will set font_outline to on or off, depending on the boolean value. (q.v.  OUTLINE tag)

       •   font_shadow

           This will set font_shadow to on or off, depending on the boolean value. (q.v.  SHADOW tag). This only
           applies to Excel for Macintosh.

       •   font_strikeout

           This will set font_strikeout to on or off, depending on the boolean value. (q.v.  STRIKEOUT tag)

       •   hidden

           This will set whether the cell is hidden to on or off, depending on the boolean value.

       •   indent

           Set the indentation level for a cell. Positive integers are allowed.

       •   italic

           This will set italic to on or off, depending on the boolean value. (q.v. ITALIC tag)

       •   left

           See border.

       •   left_color

           See border_color.

       •   num_format

           Set   to   the   index  of  one  of  Excel's  built-in  number  formats.  See  "set_num_format()"  in
           Spreadsheet::WriteExcel

       •   pattern

           Set to an integer, 0 - 18. Sets the background fill pattern of a ell. Default is 1, solid.

       •   right

           See border.

       •   right_color

           See border color.

       •   rotation

           Set the rotation of the text in a cell. The rotation can be any angle in the range -90 to 90 degrees.
           The angle 270 is also supported. This indicates text where the letters run from top to bottom.

       •   shrink

           A boolean value. If true, text will shrink to fit a cell.

       •   size

           This will set the size of the font. Default is 10. Unless a row height is specifically set,  the  row
           will grow taller as necessary.

       •   text_justlast

           A boolean value to justify the last line. Only applies to Far Eastern versions of Excel.

       •   text_wrap

           A  boolean  value.  When  set  to  true, text will wrap in a cell instead of crossing over into empty
           cells. If the row height is not set, the row will grow taller to accommodate the wrapping text.

       •   top

           See border.

       •   top_color

           See border_color

       •   valign

           Set to top, vcenter, bottom, or vjustify. Default is vcenter. See also align.

CHILDREN

       None

EFFECTS

       None

DEPENDENCIES

       None

USAGE

         <format bold="1">
           ... Children here
         </format>

       In the above example, the children will be displayed (if they are displaying elements) in a bold  format.
       All other formatting will remain the same and the "bold"-ness will end at the end tag.

AUTHOR

       Rob Kinyon (rob.kinyon@gmail.com)

SEE ALSO

       BOLD, HIDDEN, ITALIC, OUTLINE, SHADOW, STRIKEOUT

perl v5.24.1                                       2017-07-13             Excel::Template...ntainer::Format(3pm)