template-out-generate-clean

pebblestream:template-out-generate-clean

Use it when the pebble generates the whole worksheet itself (a report built from
scratch) rather than writing into an existing template layout.

Syntax

pebblestream:template-out-generate-clean

• No arguments.
• Placed on any cell of the output worksheet.
• Requires template-name on the same worksheet — the name
  still identifies which worksheet to (re)create and fill.

Consequences

• Because the recreated worksheet has no headers to locate,
  template-out-header cannot be used on such a sheet
  — combining them fails with template-out-clean-conflict. Anchor every column
  with template-out-cell instead.
• The template worksheet may be missing from the user's workbook entirely;
  the fill tolerates that and simply creates it.
• Since the worksheet starts blank, the stored styles from
  template-out-style are applied without first
  clearing existing formatting (there is none).

Example

Output worksheet Generated that rebuilds the Report worksheet from scratch:

plus, on any cell of the sheet:

pebblestream:template-name:Report
pebblestream:template-out-generate-clean

Errors

Related

• Template directives — the output fill flow
• template-out-cell — the only anchor usable on a clean sheet
• template-out-style — styling the generated cells