目录

# 将名称识别为地址

您可以使用包含文本的单元格来表示该单元格所在的行或列。

If the resulting cell is below or above another cell containing text, LibreOffice Calc assumes the text as a column label, else LibreOffice Calc assumes the text as a row label.

在该例子中，您可以在公式中使用字符串「'Column One'」作为对单元格区域「B3」到「B5」的引用，或者使用字符串「'Column Two'」作为对单元格区域「C2」到「C5」的引用。您也可以使用「'Row One'」表示单元格区域「B3」到「D3」，或者使用「'Row Two'」表示单元格区域「B4」到「D4」。公式「SUM('Column One')」中使用了单元格名称，其计算结果为600。

Automatically finding labels is a legacy feature and deactivated by default as it can produce nondeterministic behavior depending on actual document content. To turn this function on, choose LibreOffice - Preferences Tools - Options - LibreOffice Calc - Calculate and mark the Automatically find column and row labels check box.

Using defined labels instead is always possible and behaves similar but in a defined way.

If you enter a label name in the formula yourself, enclose the name in single quotation marks ('). If a single quotation mark appears in a name, you must double it, for example, 'Harry''s Bar'.

相关主题

命名单元格

Define Label Range

地址和引用，绝对和相对