To create a template for an OpenDocument spreadsheet or Microsoft Excel spreadsheet

  1. Open OpenOffice.org Calc or Microsoft Excel.
  2. Add the code to the template file.
  3. Save the template file.
  4. Add the template to Report Wizard.

All multiline directives such as #if, #else, #elseif, #foreach, and #macro must be used under the following conditions:

  1. The beginning and end of a statement must be declared within a single cell. A #macro statement must be declared in a single cell.



  2. You can use #foreach in a single cell record only. To create data for multiple rows, use the #forrow directive instead, see figure below.



  3. You can use #forcol to create data for multiple columns, see figure below. You can use the statement in conjunction with #forrow.