Global options
## Global options
This feature provides global options for user to control the default behaviors of Document Solutions for Excel Template.
Document Solutions for Excel defines some built-in workbook defined names to set global options on the template.
Currently, these options are Workbook Defined Names. So, user should take care of the scope of using in the options in the template. That is, template options in multiple worksheets will behave the same.
User can add/edit/delete these built-in defined names directly in Excel file, or via Document Solutions for Excel APIs.
The value of Name property in built-in defined name will be taken as the template global option's name.
The value of RefersTo property in built-in defined name will be taken as the template global option's value.
The option name is case-sensitive, while the option value is case-insensitive.
The template supports following types of global options:
- **TemplateOptions.KeepLineSize:** Boolean type. The value can be **True** or **False**(Default).
Whether the row height and column width should be of equal size when processing template.
- **TemplateOptions.InsertMode:** String type. The value can be **Cells**(Default) or **EntireRowColumn**.
Whether Document Solutions for Excel will insert cells or entire rows & columns when extra spaces are needed while expanding the template.