Calc:隐藏和显示数据
出自OOo 中文指南手册翻译
当元素隐藏后，它们既不可见也不打印。但如果选择了其周围的元素，它们也仍然可以选定进行复制。例如，如果B列是隐藏的，当您选择A和C列时，它也被复制。当重新需要一个隐藏的元素时，可以按相反的过程，显示该元素。 When elements are hidden, they are neither visible nor printed, but can still be selected for copying if you select the elements around them. For example, if column B is hidden, it is copied when you select columns A and C. When you need a hidden element again, you can reverse the process, and show the element. (1)
要隐藏或显示工作表、行和列，使用格式菜单或右击（上下文）菜单中的选项。例如，要隐藏一行，首先选择该行，然后选择格式 > 行 > 隐藏（或点击右键并选择隐藏)。 To hide or show sheets, rows, and columns, use the options on the Format menu or the right-click (context) menu. For example, to hide a row, first select the row, and then choose Format > Row > Hide (or right-click and choose Hide). (2)
要隐藏或显示选定的单元格，从菜单栏选择格式 > 单元格（或右击并选择格式化单元格)。在单元格格式对话框中，选择单元格保护选项卡。 To hide or show selected cells, choose Format > Cells from the menu bar (or right-click and choose Format Cells). On the Format Cells dialog, go to the Cell Protection tab. (3)
[编辑] 大纲组合控制 Outline group controls (5)
如果您需要不断地隐藏和显示一些相同的单元格，可以创建大纲组合简化操作，添加一组用于隐藏和显示相应组合中单元格的控制，可以快速应用，并且总是可用的。 If you are continually hiding and showing the same cells, you can simplify the process by creating outline groups, which add a set of controls for hiding and showing the cells in the group that are quick to use and always available. (6)
如果单元格的内容为一个常规的样式，如有四个单元格后，紧接其后是总和，那么你可以使用数据 > 组合及大纲 > 自动大纲 ，让Calc根据相应的模式添加大纲控制。否则，你可以手动设置大纲组合。选择要组合的的单元格，然后选择数据 > 组合及大纲 > 组合。在组合对话框中，您可以选择是按行还是列对选定的单元格进行组合。 If the contents of cells falls into a regular pattern, such as four cells followed by a total, then you can use Data > Group and Outline > AutoOutline to have Calc add outline controls based on the pattern. Otherwise, you can set outline groups manually by selecting the cells for grouping, then choosing Data > Group and Outline > Group. On the Group dialog, you can choose whether to group the selected cells by rows or columns. (7)
当该对话框关闭后，大纲组合控制在行或列标题与编辑窗口的边缘之间可见。这些控点外观上类似于一个文档管理器的树型结构，可以通过选择数据 > 大纲 > 隐藏细节将其隐藏。他们是仅仅用于联机操作，不能打印。 When you close the dialog, the outline group controls are visible between either the row or column headers and the edges of the editing window. The controls resemble the tree-structure of a file-manager in appearance, and can be hidden by selecting Data > Outline > Hide Details. They are strictly for online use, and do not print. (8)
基本的大纲控点，在该组合的开始显示有正负号标志，以显示或隐藏被隐藏的单元格。但是，如果一个或多个大纲组合嵌套于另一个组合内，控点有编号按钮，用于隐藏不同级别的组合。 The basic outline controls have plus or minus signs at the start of the group to show or hide hidden cells. However, if one or more outline group is nested in another, the controls have numbered buttons for hiding different levels of group. (9)
如果不再需要一个组合时，将鼠标光标放置于其中任何一个单元格内，并选择数据 > 组合及大纲 > 取消组合。若要删除一个表中的所有组合，选择数据 > 组合及大纲 > 删除。 If you no longer need a group, place the mouse cursor in any cell in it and select Data > Group and Outline > Ungroup. To remove all groups on a sheet, select Data > Group and Outline > Remove. (10)
[编辑] 筛选可见单元格 Filtering which cells are visible (12)
过滤器是一个条件列表，每个条目都必须满足，才能得以显示。您可以从数据 > 筛选子菜单设置三种类型的过滤器。 A filter is a list of conditions that each entry has to meet in order to be displayed. You can set three types of filters from the Data > Filter sub-menu. (13)
自动筛选在一列的顶部行中添加一个下拉列表，包含常用的过滤器。它们方便快捷，而且，由于条件包括了选定的单元格中的每一个独特的项目，因此几乎对文字与数字都是有用的。 Automatic filters add a drop-down list to the top row of a column that contains commonly used filters. They are quick and convenient, and, because the condition includes every unique entry in the selected cells, are almost as useful with text as with numbers. (14)
除了每一个独特的项目之外，自动筛选包括显示所有项目的选项，10个最大的数值，和所有为空或不为空的单元格，以及一个标准的过滤器。其缺点是，它们比较有限。特别是，他们不容许正则表达式。所以使用自动过滤器，不能显示类似、但不完全相同的内容。 In addition to each unique entry, automatic filters include the option to display all entries, the ten highest numerical values, and all cells that are empty or not-empty, as well as a standard filter. Their drawback is that they are somewhat limited. In particular, they do not allow regular expressions, so you cannot display contents that are similar, but not identical, by using automatic filters. (15)
标准筛选 比自动筛选更加复杂。您可以设置多达三种筛选条件，以运算符OR和AND连接它们。标准筛选主要用于数字，尽管几个条件运算符如 = 和 < > 也可用于一些文本。 Standard filters are more complex than automatic filters. You can set as many as three conditions as a filter, combining them with the operators AND and OR. Standard filters are mostly useful for numbers, although a few of the conditional operators, such as = and < > can also be useful for text. (16)
标准筛选的其他条件运算符包括显示最大、最小值、或其百分比的选项。标准本身很有用，当用于进一步完善的自动筛选时，就更有价值。 Other conditional operators for standard filters include options to display the largest or smallest values, or a percentage of them. Useful in themselves, standard filters take on added value when used to further refine automatic filters. (17)
高级筛选的结构类似于标准筛选。区别是，高级筛选不限于三个条件，其标准也不是在对话框中输入。相反，高级筛选在一个工作表的空白区域中输入其条件，然后通过高级筛选工具引用并应用它们。 Advanced filters are structured similarly to standard filters. The differences are that advanced filters are not limited to three conditions, and their criteria are not entered in a dialog. Instead, advanced filters are entered in a blank area of a sheet, then referenced by the advanced filter tool to apply them. (18)
