--- title: "Add Input Data to a Sheet (Rearranges)" slug: "add-input-data-to-a-sheet" description: "Describes how to add input data (rearranges) to a Lasernet Core form." tags: ["Form Editor", "Lasernet Core", "Rearranges "] updated: 2026-04-15T13:32:03Z published: 2026-04-15T13:32:03Z canonical: "kb.lasernetgroup.com/add-input-data-to-a-sheet" --- > ## Documentation Index > Fetch the complete documentation index at: https://kb.lasernetgroup.com/llms.txt > Use this file to discover all available pages before exploring further. # Add Input Data to a Sheet (Rearranges) The rearrange tool is one of the most important functions in Lasernet Form Editor. It is used to define input variables in the input data files and map them to output fields in forms. You activate the rearrange tool by clicking the **Rearrange** button in the toolbar. ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/rearranges 3.png) ## Create a Rearrange The way that you create a rearrange depends on the form’s input data type. Refer to the information that applies to the form’s input data type: **XML input data (Lasernet Core 11, Lasernet Core 10, and Lasernet Essentials / Professional / Advanced)** Activate the rearrange tool and click an element within the XML input data. The element will be highlighted, and (for most output types) a corresponding field will be added to your form design. However, for XML output (including PDF Form (Filled) output) you must manually drag the rearrange to a node. ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/input xml 10.png) In the above example, an XML tag named ‘CityName’ has been marked as a rearrange. You can then access the input properties of the rearrange by right-clicking it and choosing **Properties** from the menu. The properties are essentially the same as for non-XML input files, except for the position information which is irrelevant in XML. **Text input data (Lasernet Core 11 and 10 only)** Activate the rearrange tool and select an area in your input data file by drawing a box around the text. The selected area will be highlighted in blue (symbolizing a rearrange), and a corresponding field will be added to your form on the right-hand side of Lasernet Form Editor for the EMF output. For XML output, you must manually drag to a node. ## Rearrange Properties To modify the properties of the new rearrange (for example, to change the font and text size), see [Edit Rearrange Properties](/v1/docs/edit-rearrange-properties). ### Add Input Data to Rich-Text-Based DOCX, PDF, and HTML/XHTML Output **Applies to:** Lasernet Core 11 and 10 (not Lasernet Essentials / Professional / Advanced) For these types of output, you do not create rearranges. Instead, you add fields from the DataSet formatted input to the form design, where they act as mail-merge fields. For instructions, see [Add Fields to Rich-Text-Based DOCX, PDF, and HTML/XHTML Output](/v1/docs/add-input-data-to-a-sheet#add-input-data-to-richtextbased-docx-pdf-and-htmlxhtml-output). ### Add Input Data to XLSX Spreadsheet Output **Applies to:** Lasernet Core 11 and 10 (not Lasernet Essentials / Professional / Advanced) For XLSX spreadsheet output, you do not create rearranges. Instead, you add fields from the DataSet formatted input to the form design, where they act as mail-merge fields. For instructions, see [Add Fields to XLSX Spreadsheet Output](/v1/docs/add-input-data-to-a-sheet#add-fields-to-xlsx-spreadsheet-output). ## Several Patterns Matching the Lines If there are one or more patterns matching the lines you wish to select after clicking the **Rearrange** tool, you can press Shift prior to releasing the mouse (or, for XML input, before clicking the mouse on an XML element). A context menu is then displayed showing all patterns that match the selected line. Select the desired pattern to create a conditional rearrange or select **Sheet** to create an absolute rearrange. ## Instance Qualifiers When you work with conditional rearranges, you can use the **Instance(s) qualifiers** option. It allows you to extend pattern expressions with the ability to specify: 1. All instances (the option is selected by default), 2. First instance, 3. Middle instance(s) which are all non-first and non-last, 4. Last instance, 5. Single instance, which is the only one existing line of the pattern of: 1. All instances of the pattern (the option is selected by default), 2. All consecutive instances of the pattern, 3. All instances of the pattern within a region, 4. All instances of the pattern within a group. ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/rearranges 15.png) > [!NOTE] > Note > > The controls for the **Instance(s) qualifiers** group box are disabled if the settings are already specified for the pattern to which the rearrange(s) belong. > [!NOTE] > Note > > Instance qualifiers are only supported for conditional rearranges added to a pattern. They are not applicable to rearranges added to an absolute fixed position. ## Render XHTML Within Input Data **Applies to:** Lasernet Core 11 and 10 (not Lasernet Essentials / Professional / Advanced) Lasernet Core can read XHTML within input data and render the XHTML in the output. Select the **XHTML** checkbox on the **General** page of the **Edit Rearrange** window. The list of supported tags includes the following: - `h1` to `h6` — headings - `<p>` — paragraph - `<a>` — hyperlink. For example: `<a href="url">hyperlink text</a>` - `<b>` or `<strong>` — bold - `<i>` or `<em>` — italic - `<u>` — underlined - `<div>` - `<ul>` with `<li>` to create unordered (bullet) lists. You can also include inline CSS. For example: `<p>This is <span style="font-weight:bold">bold text</span>.</p>` Using this capability, Lasernet Core can render a document with headings and formatted text in paragraphs. ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/xhtml 1.png) Lasernet Core 10.12 and later support `rbga` functional CSS notation in XHTML properties. However, the alpha channel is disregarded. ### Numbered Lists Lasernet Core 10.11 and later support `<ol>` tags with `<li>` tags to create numbered lists. Optionally, you can specify a `type` attribute for an `<ol>` tag to specify the numbering style. The type attribute can have the following values: - `1`: Decimal number - `a`: Lower-case letter - `A`: Upper-case letter - `i`: Lower-case roman numeral - `I`: Lower-case roman numeral If you do not specify `type`, the default style (`1` - decimal number) is used. You can also specify a `start` attribute to specify the starting value for the list. The start attribute has a numeric value. For example: `<ol type="i" start=5>` starts a list with the letter `e`. **Example** ```plaintext
     
  1. Item 1
    2.  
  2. Item 2
``` The code above results in the following list: ```plaintext a. Item 1 b. Item 2 ``` ## Rearranges in XML Format Output **Applies to:** Lasernet Core 11 and 10 (not Lasernet Essentials / Professional / Advanced) When you produce XML files, the output properties of a rearrange are identical to the structure of the XML file and the input rearranges are mapped to tags in the output XML file. ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/xml output 1.png) The example illustrates how data contained in an input text file is mapped to a tag in an output XML file using rearranges. ## Add a Rearrange to PDF Form (Filled) Output **Applies to:** Lasernet Core 11 and 10 (not Lasernet Essentials / Professional / Advanced) To add data from the input into the output data structure, you must create rearranges in the XML input data (as described) above and then use those rearranges in the output data structure. Add rearranges to the input, and then drag them to the output to fill the fields (interactive elements) as needed. ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/xml output 43.png) ## Add Fields to Rich-Text-Based DOCX, PDF, and HTML/XHTML Output **Applies to:** Lasernet Core 11 and 10 (not Lasernet Essentials / Professional / Advanced) To add mail-merge fields to the design of forms that create these types of output, follow these steps: 1. Drag the required fields from the input to the output. We recommend that you drag the fields from the table where the **Use for Mail Merge** option is selected first. These fields are then inserted as inline text. ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/rich text 1.png) 2. You can then drag fields belonging to the nested table. To do this, select the required fields on the nested table by holding down the Ctrl key while clicking the left mouse button on each field you want to add. Those fields are then added to the output in the order you have selected them. ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/rich text 2.png) 3. In addition, you can also drag the whole nested table. You can also define or re-define settings for fields you have added to the output using the **Properties** button on the **Field** bar. To do this, highlight the item (field) for which you want to edit the properties. The **Properties** button then becomes available on the **Field** bar. Click it and then specify the required properties. ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/rich text 3.png) ## Add Fields to XLSX Spreadsheet Output **Applies to:** Lasernet Core 11 and 10 (not Lasernet Essentials / Professional / Advanced) To add mail merge fields to the spreadsheet, select a cell in the template and then double-click a field in the input which contains the value you want to insert into the selected cell. Repeat the same action for each cell you want to fill in with the required field value. Cells in the **Detail** range have to be filled in with field values from the master detail table. Cells in **DetailLevel0** have to be filled in with field values from the nested table. The output should then look like the image below: ![](https://cdn.document360.io/c831ef63-c6b3-48ee-b443-3e33644e4e2e/Images/Documentation/spreadsheet 6.png) In addition to adding input data to the spreadsheet, you could style various elements of the spreadsheet and add calculations and images to the sheet.