# Template Sheet Setting

## 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/v17/) | Controls how to organize data. |
| [Spill Mode](/spreadjs/docs/v17/) | Overwrites cells when spilled in a ReportSheet. |
| [Auto Expand](/spreadjs/docs/v17/) | Controls whether the cell can be expanded or not. |
| [Spill Direction](/spreadjs/docs/v17/) | Controls how the data spills in the report sheet. |
| [Context](/spreadjs/docs/v17/) | Sets the vertical and horizontal context for the cell. |
| [Pin](/spreadjs/docs/v17/) | Clears the offset of the spilled cell in the TemplateSheet. |
| [Data Filter](/spreadjs/docs/v17/) | Filters data based on specified conditions. |
| [Data Sort](/spreadjs/docs/v17/) | Sorts data in ascending, descending, or in their customized order. |
| [Auto Fit Template Cell](/spreadjs/docs/v17/) | Automatically adjusts column width and row height to fit the content when generating reports. |
| [Cell Style](/spreadjs/docs/v17/) | Sets background colors or borders for cells. |
| [Conditional Format](/spreadjs/docs/v17/) | Sets the conditional format on the template sheet. |
| [Data Validation](/spreadjs/docs/v17/) | Verifies that the data entered into cells meets certain criteria or rules. |
| [Cell States](/spreadjs/docs/v17/) | Represents how a cell will respond to different actions from the user. |
| [Show/Collapse Cells](/spreadjs/docs/v17/) | Controls whether to show the button that can collapse the children of the cell in the report. |
| [Formula Functions](/spreadjs/docs/v17/) | Defines basic function usage. |
| [Data Entry Settings](/spreadjs/docs/v17/) | Sets data entry setting in the template sheet. |
| [Pagination](/spreadjs/docs/v17/) | Customizes pagination settings in the template sheet. |
| [Layout Setting](/spreadjs/docs/v17/) | Sets row/column layout settings. |
| [Picture Shape](/spreadjs/docs/v17/) | Adds a picture as a shape to make the report more informative. |