Manage Cells

When using table widgets in your web screen, you can manage the cells, the columns, and rows of that table. The operations available for the Cell widget are merge and split.

Merge cells

The Merge Cells operation produces a single cell that spans several columns. The contents of these cells are placed in the resulting cell.

You can merge any adjacent cells either horizontally or vertically.

To merge two cells, you must have some values inside them. Otherwise, the merge does not work.

Example

This example shows a situation where merging cells is helpful in displaying table contents.

Suppose you have the following table for cities of the world:

Select both Name and Country header cells and merge them. Then remove the 'Name' and 'Country' header titles and type 'Cities' as the single header title. The result is the following:

Split cells

The Split Cells operation allows you to replace the select cell by two cells in the same row. The second cell is empty.

Example

This example shows you a situation where splitting cells is helpful in displaying table contents.

Suppose you have the following table:

To display the price for the maximum discount split the Max Discount data cell. Then, in the new cell, add the expression that computes the minimum price (in brackets). The result is the following: