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 http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.11/lib/Spreadsheet/WriteExcel.pm#COLOURS_IN_EXCEL
* 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.
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.11/lib/Spreadsheet/WriteExcel.pm#set_border()
* 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 http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.11/lib/Spreadsheet/WriteExcel.pm#set_num_format()
* 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 accomodate 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
2 POD Errors
The following errors were encountered while parsing the POD:
- Around line 55:
You can't have =items (as at line 62) unless the first thing after the =over is an =item
- Around line 196:
=back doesn't take any parameters, but you said =back 4