To provide a cell that is correctly sized for inserted text
This will consume one column on the current row.
<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.
Tim Howell (firstname.lastname@example.org) Based on Excel::Template::Element::Cell by Rob Kinyon
CELL, ROW, VAR, FORMULA