Excel::Template::Container::Format(3pm) 		User Contributed Perl Documentation		   Excel::Template::Container::Format(3pm)

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

       o   align

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

       o   bg_color

	   Set to a color value. Default is none.

       o   bold

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

       o   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

       o   border_color

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

       o   bottom

	   See border.

       o   bottom_color

	   See border_color

       o   color

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

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

       o   font

	   This will sent the font face. Default is Arial.

       o   font_outline

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

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

       o   font_strikeout

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

       o   hidden

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

       o   indent

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

       o   italic

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

       o   left

	   See border.

       o   left_color

	   See border_color.

       o   num_format

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

       o   pattern

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

       o   right

	   See border.

       o   right_color

	   See border color.

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

       o   shrink

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

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

       o   text_justlast

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

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

       o   top

	   See border.

       o   top_color

	   See border_color

       o   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.14.2							    2012-04-29				   Excel::Template::Container::Format(3pm)