Sheet

Component «Sheet»  of the Form has a direct relationship to a Worksheet of the Printing form at runtime (resultant XLSX-file).

You should create so many sheets in the form as many worksheets (one or more) will required in the Printing form.

If number of sheets isn't known in advance, You able to insert it dynamically into resultant XLSX-fileYou can make a looping through rows of the nested table of the context via component «Loopstep» and then include a «Sheet» into it:

Properties tab:



Item «Binding with sheet on the template»

The item is for assigning the form component «Sheet» to a worksheet of Excel-template. Press a button  and then in the popup list ofsearch-help choose the corresponding worksheet: 


Here you can define a runtime state of the worksheet (Visible or Hidden): 

 --> 

 

Item «Sheet name at runtime»

The item is for specifying a worksheet name in the Printing form at runtime (resultant XLSX-file).

By default set a mode «Auto», it means an autoincrement principle of name creation. Ie sheet name in the resultant XLSX-file will be setted like name of bound worksheet in the Excel-template (if sheet with same name already exists in the resultant XLSX-file, a counter will be added to end of sheet name).

But if You want, the sheet name can be appointed by value from field of the context. You have to press a button  and then in the popup window of search-help You have to choose required field of the context (contains sheet name):


Here You are able to output just a part of string instead an entire string. To do that You have to press a button and then on a popup window specify a start position and number of characters that should be outputted (for example, first 10 characters). Furthermore, via option  You can switching on a conversion routine (if it exists) to convert a source value to an external format (for example, date conversion from '20140101' to  '01.01.2014').


 

Item «Appearance at runtime»


By default, a Sheet is always appearing in the Printing form at runtime. But it is possible to dynamically define a presence of component in the Printing form.
The item is for associating the component appearance (in Printing form at runtime) with value of any context field (the Sheet will be output in the Printing form only if the specified context field is not initial).
You have to press a button and then in the popup search-help You have to choose required context field (so-called Appearance indicator):




If an Appearance indicator has character data type, You are able to set for analyzing just a part of string (substring) instead of entire string. To do that You have to press a button , and then on a popup window specify a start position and number of characters that should be analized:


 

Item «Print titles»

The item allows You to print particular row and column headings on each page of the resultant XLSX-file.  

You have to press button  and then in the popup window of search-help You have to choose required Pattern, its rows or columns should be repeated on each page:

 

Item «Sheet protection»

The item provides extended protection options.  

From template

Here all sheet protection options in Run-time mode will be completely copied from corresponding sheet of Design-time mode.


From context

Here a specified context field (which must have type CHAR and length 15) is being analysed. Each character (char.position) of the specified field is a flag for corresponding sheet protection option:


Static

Here you just have to set checkboxes for required options of sheet protection:


In this item, as in previous, you can pick one from predefined password list, or pick "Off" (i.e. without password).