The Hide Tags

The "hide" tags are a group of tags that hide parts of a workbook. All hide tags must contain a body. There are tags for hiding columns, hiding rows, and hiding an entire sheet.

Attributes

  • All "hide" tags support all base tag attributes.
  • test: boolean Required. If true, hide the columns/rows/sheet, else show the columns/rows/sheet.

The HideCols Tag

The jt:hideCols tag will hide (or show) all columns in the tag's body.

In this example, the cell B1 contains the text <hideCols test="true">. This tag will affect columns B-E. Column D is hidden. The cell H1 contains the text <jt:hideCols test="false">. This tag will affect columns H-K. Column J is hidden.

HideCols Template

When transformed, columns B-E are hidden. Column D, which was already hidden in the template, remains hidden. Columns H-K are visible. Column J, which was hidden in the template, is now visible.

HideCols Result

The HideRows Tag

The jt:hideRows tag will hide (or show) all rows in the tag's body.

In this example, the cell A2 contains the text <jt:hideRows test="true">. This tag will affect rows 2-5. Row 4 is hidden. The cell A8 contains the text <jt:hideRows test="false">. This tag will affect rows 8-11. Row 10 is hidden.

HideRows Template

When transformed, rows 2-5 are hidden. Row 4, which was already hidden in the template, remains hidden. Rows 8-11 are visible. Column 10, which was hidden in the template, is now visible.

HideRows Result

The HideSheet Tag

The jt:hideSheet tag will hide (or show) the entire sheet on which the tag is found.

In this example, the cell B2 in the sheet "HideSheet" contains the text <jt:hideSheet test="true">. This tag will affect the entire sheet. There is a sheet hidden in the template workbook called "ShowSheet". In that sheet, the cell B2 contains the text <jt:hideSheet test="false">. This tag will affect the entire sheet.

HideSheet Template

When transformed, the entire sheet "HideSheet" is hidden. The previously hidden sheet, "ShowSheet", is now visible.

HideSheet Result