Cell Expansion and Parent-child Cell

Version

Function Description

Expansion in Cell Attribute includes settings for the cell expansion direction, left parent cell, up parent cell, extendable direction, and sort after expansion. This document briefly introduces the expansion settings.

Expansion Direction

With the Expansion Direction setting, you can choose to display data records from top to bottom (vertical expansion along the row direction) or from left to right (horizontal expansion along the column direction). Alternatively, you can select No Expansion to display all data in a single cell. For details, see Cell Expansion.

The following figure shows the effect of vertical expansion.

The following figure shows the effect of horizontal expansion.

The following figure shows the effect of no expansion.

Parent Cell Setting

The expansion setting of a cell will change along with that of its parent cell. When the adjacent cell to the left or above is configured with expansion settings, the one to the left defaults to Left Parent Cell, or the one above defaults to Up Parent Cell. For details, see Parent-Child Cell Setting.

Parent cell setting includes None, Default, and Custom, as shown in the following figure.

To customize the parent cell, you can enter the cell reference in the text box or click the icon and select the desired cell. The column and row of the selected cell will be returned automatically, as shown in the following figure.

Extendable Direction

Sometimes, the cell to the left of the expanding cell may stretch with the expansion, rather than being split into new rows as would normally occur during insertion. That is, the cell stretches along with the expansion of its child cell or cell at the same level when displaying content. The extendable direction can be divided into two types: Horizontally Extendable and Vertically Extendable. Horizontally Extendable is described briefly below:

Example:

The figure above shows that the cell above stretches with the expanding cell below. If you want the cell above to stay unaffected by the expanding cell below, select the desired cell, choose Cell Attribute > Expansion > Advanced on the right attribute, and deselect Horizontally Extendable.

The following figure shows the effect.

Sort After Expansion

Sort After Expansion can be divided into three types, as shown in the following figure.

For details about examples of sort after expansion, see Sort After Expansion.

Ascend

Sorting data in ascending order after cell expansion

Descend

Sorting data in descending order after cell expansion

Not Sort

Not sorting data after cell expansion