NAME

Excel::Template::Element::Cell::AutoSize

PURPOSE

To provide a cell that is correctly sized for inserted text

NODE NAME

CELLAUTOSIZE

INHERITANCE

Excel::Template::Element::Cell

CHILDREN

Excel::Template::Element::Formula

EFFECTS

This will consume one column on the current row.

DEPENDENCIES

Font::TTFMetrics

USAGE

  <cellautosize text="Some Text Here"/>
  <cellautosize>Some other text here</cellautosize>

  <cellautosize text="$Param2"/>
  <cellautosize>Some <var name="Param"> text here</cellautosize>

In the above example, four cells are written out. The first two have text hard- coded. The second two have variables. The third and fourth items have another thing that should be noted. If you have text where you want a variable in the middle, you have to use the latter form. Variables within parameters are the entire parameter's value.

Please see Spreadsheet::WriteExcel for what constitutes a legal formula.

AUTHOR

Tim Howell (tim@fefcful.org) Based on Excel::Template::Element::Cell by Rob Kinyon

SEE ALSO

CELL, ROW, VAR, FORMULA