Cell Dynamic Attributes-Expansion Practice
1. Overview
This article will详细介绍模板单元格中的"扩展"功能及其配置使用方法。我们将通过一个具体的扩展案例来展示如何有效实践。
本教程所使用的案例数据集如下:产品培训演示数据集.xlsx
扩展的视频讲解,详见动态属性-扩展。
1.1. Application Scenarios
When fields from the view are dragged into cells, and you need to distribute field values across different cells, you need to use the cell expansion functionality, which is the cell E attribute (Expansion).
1.2. Function Introduction
Expansion is a basic attribute of template cells. Template cells provide three expansion methods: horizontal expansion, vertical expansion, and no expansion.
By default, cells use vertical expansion; when cells contain formulas or static text, they do not expand by default. It's worth noting that a cell can only set one expansion direction at a time.
Vertical Expansion (E=V): Data in the cell expands vertically, with all data displayed from top to bottom in different cells.
Horizontal Expansion (E=H): Data in the cell expands horizontally, with all data displayed from left to right in different cells.
No Expansion (E=N):
- Basic Excel Component: Field data in the cell does not expand, only displays the first data.
- Accelerated Excel Component: All data in the cell is displayed, separated by commas.
Note: For differences between basic and accelerated version functionality, see [Product Behavior Change Description](../../../../../../2-Product Release Notes/1-2024 Year/1-V7.0.0 Important Feature Updates/1-Product Behavior Change Description.md#1.3. Chinese-style Reports Pro underlying Excel component upgraded from basic to accelerated version).
1.3. Case Effects
Vertical Expansion:

Horizontal Expansion:

No Expansion:

2. Operation Steps
-
Drag fields from the view, default to vertical expansion;
-
Double-click the cell or right-click to open "Dynamic Attributes", select the required expansion attribute, click "OK" to apply.
-
Click "Preview" in the upper right corner to view the expansion configuration effect.
3. Notes
Dynamic attributes are recommended to be selected from the popup, but manual attribute input in cells () is also supported, separated from other attributes with half-width commas; the E attribute can be omitted when using vertical expansion.
