# Template Sheet Settings

An explanation of the Template Sheet functionality for SpreadJS ReportSheet, which includes settings for report-related parameters

## Content

The TemplateSheet refers to the template of a report. It includes a number of report-related parameters as well as explains many report-related concepts. Since the TemplateSheet is an extension of the worksheet, you can consider it as a worksheet as well.
You can use various methods and properties of the `TemplateSheet` class to configure the settings for a report template.
To know more about TemplateSheet settings, refer to the following topics:

| **Setting** | **Description** |
| ------- | ----------- |
| [Template Cell Type](/spreadjs/docs/v18/features/reportsheet/templatesheet/template-cell-type) | Controls how to organize data. |
| [Spill Mode](/spreadjs/docs/v18/features/reportsheet/templatesheet/spill-mode) | Overwrites cells when spilled in a ReportSheet. |
| [Auto Expand](/spreadjs/docs/v18/features/reportsheet/templatesheet/auto-expand) | Controls whether the cell can be expanded or not. |
| [Spill Direction](/spreadjs/docs/v18/features/reportsheet/templatesheet/spill-direction) | Controls how the data spills in the report sheet. |
| [Context](/spreadjs/docs/v18/features/reportsheet/templatesheet/context) | Sets the vertical and horizontal context for the cell. |
| [Pin](/spreadjs/docs/v18/features/reportsheet/templatesheet/pin) | Clears the offset of the spilled cell in the TemplateSheet. |
| [Data Filter](/spreadjs/docs/v18/features/reportsheet/templatesheet/filter-data) | Filters data based on specified conditions. |
| [Data Sort](/spreadjs/docs/v18/features/reportsheet/templatesheet/sort-cell-data) | Sorts data in ascending, descending, or in their customized order. |
| [Auto Fit Template Cell](/spreadjs/docs/v18/features/reportsheet/templatesheet/auto-fit-template-cell) | Automatically adjusts column width and row height to fit the content when generating reports. |
| [Cell Style](/spreadjs/docs/v18/features/reportsheet/templatesheet/cell-style) | Sets background colors or borders for cells. |
| [Conditional Format](/spreadjs/docs/v18/features/reportsheet/templatesheet/apply-conditional-formatting) | Sets the conditional format on the template sheet. |
| [Data Validation](/spreadjs/docs/v18/features/reportsheet/templatesheet/add-data-validation) | Verifies that the data entered into cells meets certain criteria or rules. |
| [Cell States](/spreadjs/docs/v18/features/reportsheet/templatesheet/change-cell-states) | Represents how a cell will respond to different actions from the user. |
| [Show/Collapse Cells](/spreadjs/docs/v18/features/reportsheet/templatesheet/add-showcollapse-cells) | Controls whether to show the button that can collapse the children of the cell in the report. |
| [Show Hidden Row and Col](/spreadjs/docs/v18/features/reportsheet/templatesheet/show-hidden-row-and-col) | Toggle the visibility of rows and columns marked as hidden specifically within the design view of the ReportSheet template. |
| [Formula Functions](/spreadjs/docs/v18/features/reportsheet/templatesheet/formula-functions) | Defines basic function usage. |
| [Data Entry Settings](/spreadjs/docs/v18/features/reportsheet/templatesheet/set-data-entry-settings) | Sets data entry setting in the template sheet. |
| [Pagination](/spreadjs/docs/v18/features/reportsheet/templatesheet/pagination) | Customizes pagination settings in the template sheet. |
| [Layout Setting](/spreadjs/docs/v18/features/reportsheet/templatesheet/layout-setting) | Sets row/column layout settings. |
| [Picture Shape](/spreadjs/docs/v18/features/reportsheet/templatesheet/picture-shape) | Adds a picture as a shape to make the report more informative. |