Calc:合并计算
出自OOo 中文指南手册翻译
数据>合并计算提供了一个图形界面从一个单元格区域复制数据到另一个区域，然后对数据进行某一运算。在合并期间，多个工作表的单元格内容可以被合并在一起。 Data > Consolidate provides a graphical interface for copying data from one range of cells to another, then running one of a dozen functions on the data. During consolidation, the contents of cells from several sheets can be combined in one place.
- 打开包含要合并的单元格区域的文档。 Open the document that contains the cell ranges to be consolidated.
- 选择数据>合并计算打开合并计算对话框。 Choose Data > Consolidate to open the Consolidate dialog.
- 如果源数据区域列表包含已命名的区域，可以选择一个源单元格区域与其他区域合并。 If the Source data range list contains named ranges, you can select a source cell range to consolidate with other areas.
- 点新增。所选区域就出现在合并计算数据区域列表里。 Click Add. The selected range now appears on the Consolidation ranges list.
- 在每一次选择后再选择另外的区域点新增。 Select additional ranges and click Add after each selection.
- 从复制结果到框里选择一个目标区域指定为显示结果的地方。 Specify where you want to display the result by selecting a target range from the Copy results to box.
- 从计算规则列表里选择一个函数。函数指定合并区域的值如何连接。默认设置是求和函数。 Select a function from the Function list. The function specifies how the values of the consolidation ranges are linked. The Sum function is the default setting.
- 在合并计算对话框上点更多按钮显示额外的设置。 Optionally click More in the Consolidate dialog to display additional settings.
- 选和源数据连接在目标区域插入公式生成结果，而不是插入实际结果。如果连接了数据，源区域里任何数值的改变都会自动更新目标区域里的值。目标区域里相应单元格的引用被插入到连续的行里，自动排序并隐藏。仅基于所选函数的最终结果会被显示。 Select Link to source data to insert the formulas that generate the results in the target range, rather than the actual results. If you link the data, any values modified in the source range are automatically updated in the target range. The corresponding cell references in the target range are inserted in consecutive rows, which are automatically ordered and then hidden from view. Only the final result, based on the selected function, is displayed.
- 如果源数据区域单元格未被合并，与区域里相同位置的单元格相一致，但是根据行标签或列标签能进行匹配，则选择合并按照下的行数据标签或列标签。要按照行标签或列标签合并，标签必须包含在所选源区域里。标签的文本必须相同，这样行和列才能准确匹配。如果行或列的标签与目标区域已有的均不匹配，那么将被追加为新行或新列。 Under Consolidate by, select either Row labels or Column labels if the cells of the source data range are not to be consolidated corresponding to the identical position of the cell in the range, but instead according to a matching row label or column label. To consolidate by row labels or column labels, the label must be contained in the selected source ranges. The text in the labels must be identical, so that rows or columns can be accurately matched. If the row or column label does not match any that exist in the target range, it will be appended as a new row or column.
- 点确定合并区域。 Click OK to consolidate the ranges.
如果源区域没有命名，点击右侧的字段，输入第一个源数据区域的引用或者使用鼠标在工作表上选择区域。（可能需要移动合并对话框到所需单元格。） If the source range is not named, click in the field to the right, and either type a reference for the first source data range or use the mouse to select the range on the sheet. (You may need to move the Consolidate dialog to reach the required cells.)
如果目标区域未命名，点复制结果到框旁的字段，输入目标区域的引用，或用鼠标选择区域，或放置光标在目标区域的左上单元格。 If the target range is not named, click in the field next to Copy results to and enter the reference of the target range or select the range using the mouse or position the cursor in the top left cell of the target range.
多数有效的函数是统计学的（如平均值、最小值、最大值、标准偏差），当你对相同的数据反复计算时这个工具很有用。 Most of the available functions are statistical (such as AVERAGE, MIN, MAX, STDEV), and the tool is most useful when you are working with the same data over and over.
如果对同一区域连续计算，也许应该使用数据>定义区域给它命名。 If you are continually working with the same range, then you probably want to use Data > Create Range to give it a name.
合并计算数据区域里的数据和目标区域在保存文档时也会被保存。如果以后打开定义有合并计算的文档，这些数据仍然有效。 The data from the consolidation ranges and target range are saved when you save the document. If you later open a document in which consolidation has been defined, this data will again be available.
[编辑] 进度表
| Calc:合并计算 中文化进度 | 翻译 | 0 | 校对 | 0 | 插图 | 1/1 | 上次编辑 | 20100628033008 | 编者 | Yookee |
