Sheet Options
- 11 Jul 2024
- 7 Minutes to read
- Contributors
- Print
- PDF
Sheet Options
- Updated on 11 Jul 2024
- 7 Minutes to read
- Contributors
- Print
- PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
You can manage sheet properties by right-clicking the sheet tab and selecting Sheet Options. Alternatively, on the Sheet menu, click Sheet Options.
General
Property | Description |
|---|---|
Active | Enable or disable the sheet. |
Name | Change the name of the sheet. |
Description | Add a sheet description (optional). |
Output type | Specifies output type for the sheet. After a sheet has been created with a given output type, the setting cannot be changed. |
Base64 encoding | If checked, binary data will be converted to ASCII string format. |
Group | Add a group name for the sheet (optional). |
Language | Add the language of the sheet (optional). |
Company | Add the company name for the sheet (optional). |
Encode Documents to Base64
The Base64 property in the Sheet Options dialog enables you to generate Base64 encoded documents for your web services or add them as an inline document in XML files.
When activating this setting your selected output type will be encoded to a Base64 document and send to your selected output destination.
By activating JobInfo you can insert sheet data in to any JobInfo, in the Sheet Options > Combining > Sheet Embedding tab, encode your data and insert the result in an XML file added to the next sheet.
Criteria
Property | Description |
|---|---|
Add Sheet | Add a Sheet Criterion. See Use Criteria. |
Add JobInfo | Add a JobInfo Criterion. See Use Criteria. |
Edit | Edit the selected criterion. |
Remove | Remove the selected criterion. |
Move Up | Move the selected criterion up in the list. |
Move Down | Move the selected criterion down in the list. |
Sheet Expression | Can be used for defining a set of criteria which must be true (or false). |
Allow further sheet matching | Uncheck to stop processing sheets to the right of this sheet if the criteria for this sheet match. |
Sheet Order and Page Numbering
See Combine Sheet Output.
Destinations
Property | Destination |
|---|---|
Add | Add a destination. |
Edit | Edit the selected destination. |
Remove | Remove the selected destination. |
Move Down | Move the selected destination down in the list. |
Move Up | Move the selected destination up in the list. |
A single sheet can have multiple destinations e.g. a copy can be emailed whilst another copy goes to the Archive. If you require different designs for each of the output destinations, you need to create a separate sheet for each.
Pre JobInfos
Here you can add custom JobInfos as well as define values for system variables.
JobInfos added and managed on the Pre JobInfos tab are to be run at the Sheet Start event point.
Post JobInfos
Here you can add custom JobInfos as well as define values for system variables.
JobInfos added and managed on the Post JobInfos tab are to be run at the Sheet End event point.
Modifiers
Here you can add and manage modifiers for the current sheet. For more information, see Use Modifiers.
When adding a modifier, the current sheet is defined in the Container control, and the control itself is disabled.
Format
Property | Destination |
|---|---|
Add/Select Regional Profile | Create a new regional profile or select one of the existing profiles from the drop-down list (for details, see Lasernet Developer, Regional Profiles). Adding a new regional profile, you can make the value active as well as specify criteria for a definite object (for more information, see Edit Rearrange Properties). The profile which meets the first criteria, which is also true, will be executed. If no regional profile is added, the regional profile which is set as default in Lasernet Developer (shown with ✔) is then applied.  |
Rounding | Specify how the system should process extra decimals. Truncate: Discard the extra decimals. Round: Round the extra decimals. Ceiling: Map the extra decimals to the smallest following number. |
Number of decimals | Specify the number of decimals to be displayed. |
Show NaN as | Specify how NaN (Not a Number) should be displayed. |
Color negative value | Specify the color for the values which are negative. |
Remove trailing zeroes | Select to discard the trailing zeroes. |
Show only decimals | Select to show only decimals. |
Absolute value | Select to show the absolute value. |
Hide if zero | Select to hide the value if it equals zero. |
Hide if invalid date | Select to hide the value if date is invalid. |
Hide if invalid time | Select to hide the value if time is invalid. |
Printer Profiles
Here you can manage the printer profiles created in Lasernet Developer (for details, see Lasernet Developer, Printer Profiles).
Overlay Files
For more details, see Import Printed Overlays to the Setup and Adding Overlays to the Sheet in Use Overlays for Graphical Design.
Page Setup
Property | Destination |
|---|---|
Reference printer | Select the reference printer for the sheet.
|
Paper Size | Allows selecting a pre-defined size format from the drop-down list. |
Width | Allows typing custom width in millimetres. |
Height | Allows typing custom height in millimetres. |
Orientation | Switch between Portrait and Landscape page orientation. |
Set JobInfos to control the Paper Format in the Printer Devices(s) | If selected, allows to define values of the PaperWidth, PaperHeight and Orientation JobInfos based on the corresponding Paper settings. The values will overwrite the device modes settings defined in the Printer Profiles for output printers. |
Master Sheet
Lasernet supports master sheet processing which is a technique used for populating rearranges, conditional areas, JobInfos, overlays and text inserts from one sheet to another in a project. For example, a form could have two sheets, Original and Copy, where the only difference is that an extra overlay is required on the Copy sheet. Rather than manually duplicating all the settings from one sheet to another, the Copy sheet can be instructed to use the Original one as the Master sheet, leaving only the overlay to be configured.
You access the master form processing dialog via the menu Sheet > Sheet Options > Master Sheet.
Only forms and sheets compatible with the selected input and output formats are available in the selection list.
The Select Rearrange Master dialog has the following properties.
Property | Description |
|---|---|
Form | Choose the form which contains the master sheet. |
Sheet | Choose the sheet to serve as the master sheet. |
Enable master form processing | This check box is used for enabling master sheet processing. |
Advanced
On the Advanced tab of the Sheet Options dialog, you can manage the memory usage and quality for images as well as for processing jobs with many pages.
When processing sheets, temporary files can be written to a disc for optimizing memory usage in Lasernet. This feature is only recommended if you have jobs which are too big to be handled by memory. Please note that temporary files are not deleted by the system after the job has been processed. The reason is that jobs which are scheduled or failed must be available as temporary files for Lasernet until they can be processed.
A user-defined process for deleting files must be defined in the setup, otherwise the files take up unnecessary disc space.
Property | Description |
|---|---|
Maximum image DPI | Specify the maximum image resolution for image(s) added to the output. |
Zip job data | Select if the JobData size is expected to be approx. 2 GB or more. This allows to correctly process JobData.
|
Only line-break after space | Select to allow line-breaks only after a space. |
Style Sheet
Use the Style Sheet tab to add CSS (Cascading Style Sheets) for all XHTML rearranges available on the sheet using the internal way which stands for a <style> element.
The style added here can be overwritten for a particular XHTML rearrange using the Style Sheet tab of the Edit Rearrange dialog (for more details, see Edit Rearrange Properties).
Encode Documents to Base64
The Base64 property in the Sheet Options dialog enables you to generate Base64 encoded documents for your web services or add them as an inline document in XML files.
When activating this setting your selected output type will be encoded to a Base64 document and send to your selected output destination.
By activating JobInfo you can insert sheet data in to any JobInfo, in the Sheet Options > Combining > Sheet Embedding tab, encode your data and insert the result in an XML file added to the next sheet.
CSV Settings
The CSV Output has the following settings:
Setting | Description |
|---|---|
Line Separator | Determines what line separator to use between lines in the text file. |
Use tagname as heading | If selected, a header line is created where names of the tags are used for naming the columns (see below). |
Quote using | If selected, a quote character should be specified, usually “, which are put around the text of each column. When using quotes, the column width must be adjusted accordingly since the quotes are not counted in the width of the column. |
Escape quotes with | If selected, the text for each column is examined for the character entered in Quote using, so it escapes with the character here. |
Character separated | If selected, character-separated files are produced. Enter the column separator, e.g.: comma, semicolon, colon or tab. |
Pad with spaces | When selected, the text in the columns are padded with spaces until they fill out the width determined by the XML file. |
EDI Settings
The EDI Output has the following settings:
For successful conversion, you can set up EDI (UNA) characters for escaping, grouping, separations, decimal characters and segments which are included in the (EDI) file. UNA characters are typically located in the first line of the EDI data.
Select Insert Newline to add a newline after each segment or clear it to create an EDI file without newlines.
Activate Count UNT to calculate and include the number of segments in the EDI file. It is necessary for the UNT segment to already be present in the message trailer.