Set Range Template Cell

SpreadJS provides support for a Range Template cell that allows you to define a template of cell ranges as a single celltype and apply that template to a cell to load different types of data into the template. Now, you can directly create a range template celltype through the designer also.

The following steps should be performed to create a range template cell in the spreadsheet through the designer.

1. Create a template by designing the range of cell in the spreadsheet. You can also select the existing template.

   
   

   
   

2. Select the range where you want to insert the template.

   
   

   
   

3. After selecting the range, go to Home tab, click on the Cell Type option and select the Range Template celltype.

   
   

   
   

4. Range Template dialog box appears with two options as shown below.

   
   

   
   

   • Set the sheet on which you want to insert the range template. Make sure that you always use the current active spreadsheet.

   • Select or set the range of created or existing template.

5. Click OK after setting the above options.

   
   

   
   

6. After clicking OK button, range template cell is set to the selected range.

   
   

   
   

Note: When you select the range in the Range option, select only one range of the template. If you select multiple range, the designer will pick only the first range.