Bound and unbound properties

Properties that you define on the Properties panel can be either bound, that is linked to spreadsheet cells, or unbound not linked to spreadsheet cells.

Unbound properties

By default, all properties are unbound. The values of unbound properties can be specified directly on the Properties panel.

To define unbound properties for a Text component.

  1. Add a Text component to the page.
  2. Make sure the Properties panel is displayed by clicking on the Main Toolbar.
  3. Select the Text component to display the Text properties panel.
  4. Define the properties as follows:
    • In the Text area, type any text.
    • In the Background area, click inside the field just above Color and select a color for the text background.
    • Click next to the Color field to show the color.
    • Under Border, click to show the border color.
    • Next to Radius, enter 32px.

Here is how our component should look like as a result:


Bound properties and repeated context

You can bind a single component's property to a single cell, or you can bind a repeated group's property to a range.

When a component is repeated, each time you bind a property of such a component to a cell, in fact you bind the property to a range. The range is used to configure the property for each of the instances in the repeated group. The repeated context defines the length and direction of the range. This range is referred to as a bound range.


Bound-range variability

The values in the bound range can be either fixed or not fixed. The default, not fixed, means that each cell value in the bound range directly affects the respective instance. When the cells are fixed, the component instances have the same property value tied to the value of the bound cell and the other cells in the bound range do not affect the instances in any way.

Fixed cells are subdivided into the following categories:

  • BOTH: Fixed in both vertical and horizontal directions. The bound cell value determines the property value of all the instances in related group.
  • RIGHT: Fixed in the horizontal direction. Cells in the vertical direction can affect the instances.
  • DOWN: Fixed in the vertical direction. Cells in the horizontal direction can affect the instances.

You can toggle the variability of cells during the binding process by using the toggle button .

In the screenshot below, because the cells are fixed in both the directions, the component instances have the same text.

Fixed cell range

Binding format

When binding the text value property of a component to a spreadsheet cell, by default the format is also bound, that is the format of the component's text value corresponds to the format of the cell. You can bind or unbind format using the toggle button

On the Repeater tab, you can configure the direction of the bound range and the number of component instances in the repeated group.