Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
Excel::Template::ContaUser:Contributed PeExcel::Template::Container::Format(3)

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.32.1			  2012-04Excel::Template::Container::Format(3)

NAME | PURPOSE | NODE NAME | INHERITANCE | ATTRIBUTES | CHILDREN | EFFECTS | DEPENDENCIES | USAGE | AUTHOR | SEE ALSO

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=Excel::Template::Container::Format&sektion=3&manpath=FreeBSD+13.0-RELEASE+and+Ports>

home | help