template-out-cell
An output fill anchor for fixed report layouts: the column's header text is an A1 cell address (e.g. J12), and Zen starts filling that column's values at that cell (inclusive), in the column's direction.
pebblestream:template-out-cell
Use it when the template has no header text to locate — a fixed report cell, a
summary box, a form field — or when the value must land at an exact position.
Multiple columns may share the same address.
Syntax
pebblestream:template-out-cell- No arguments.
- Placed on the header cell of the output column; the header text itself must
parse as a cell address (J12,B4, …). - Requires
template-nameon the same (output) worksheet.
Example
Output worksheet Results (template Template):
| column | header | comment |
|---|---|---|
| A | Grand total | pebblestream:template-name:Partners |
| A | J12 | pebblestream:template-out-cell |
| B | J13 | pebblestream:template-out-cell |
The first record's Grand total value is written to J12 of the template
worksheet, the next record's below it (default direction down), and the first
record's B value to J13.
Errors
| Error | Cause |
|---|---|
dir-too-many-args | Arguments were supplied. |
template-out-bad-cell-address | The column's header does not parse as a cell address. |
template-out-conflict | The same column also has template-out-header, a styling directive, or template-out-group. |
template-out-has-dependents | The output worksheet is used as input by another worksheet. |
missing-the-template-name-directive | The sheet has no template-name. |
Related
- Template directives — the output fill flow
- template-out-header — anchor by header text
- template-out-down / template-out-right — fill direction
- template-out-generate-clean — generate into a blank worksheet (only cell anchors work there)
Updated about 9 hours ago
Did this page help you?