跳转至

Create and use table regions(创建和使用表格区域)

You can create a table out of any region in the spreadsheet – table regions enforce a strictly tabular format to a region and allow you to assign column headers, refer to columns by column names (vs cell references), sort the rows by any column, etc.

table

:::callout{theme="success" title="Tip"} When a new row is appended to a table region, it’ll grow the region, pushing down any values underneath as necessary. :::

:::callout{theme="warning" title="Warning"} Sorting in Fusion works differently from other spreadsheet tools that you may have used. Rather than simply presenting a sorted view of the data, performing a sort in Fusion actually rearranges the rows in a sheet so that the cells are in a sorted order. This means that a sort in Fusion cannot be "turned off" to return to the original ordering; instead, you will need to undo the sort in order to see the original ordering again. :::


中文翻译


创建和使用表格区域

您可以将电子表格中的任意区域创建为表格——表格区域会强制该区域采用严格的表格格式,并允许您分配列标题、通过列名(而非单元格引用)引用列、按任意列对行进行排序等。

表格

:::callout{theme="success" title="提示"} 当新行追加到表格区域时,该区域会随之扩展,必要时会将下方的值向下推移。 :::

:::callout{theme="warning" title="警告"} Fusion 中的排序功能与您可能使用过的其他电子表格工具不同。Fusion 执行排序时,并非仅呈现数据的排序视图,而是实际重新排列表格中的行,使单元格按排序顺序排列。这意味着 Fusion 中的排序无法通过"关闭"来恢复原始顺序;如需恢复原始顺序,您需要撤销排序操作。 :::