Calc:数据排序
出自OOo 中文指南手册翻译
Calc文档里排序的机制是在电子表格里重新排列数据。排序数据的第一步是选择想要排序的数据。要排序工作表1里的数据，选择从A1到G16的单元格区域——如果要包括列标题的话，在排序对话框中指出这一点。使用数据>排序打开排序对话框。一次最多可以根据三行或三列排序。 The sorting mechanism in a Calc document rearranges the data in the sheet. The first step in sorting data is to select the data that you want to sort. To sort the data in Table 1, select the cells from A1 to G16—if you include the column headers, indicate this in the sort dialog. Use Data > Sort to open the Sort dialog. You can sort by up to three columns or rows at a time.
点选项标签页设置排序选项。勾选区域含有列标签检查框防止列标题也和剩下的数据一起被排序。如果下图中的区域含有列标签检查框被勾选，上图中的排序按照列表框使用列标题来显示列。如果区域含有列标签检查框未被勾选，这些列则由他们的列名来区分，如列A。 Click on the Options tab to set the sort options. Check the Range contains column labels checkbox to prevent column headers from being sorted with the rest of the data. The Sort by list box in the figure above displays the columns using the column headers if the Range contains column labels checkbox in the figure below is checked. If the Range contains column labels checkbox is not checked, however, then the columns are identified by their column name; Column A, for example.
通常，排序数据会造成已有数据被新排序后的数据替代。如果勾选复制排序结果到检查框，那么选择的数据不会被改变，排序后的数据会被复制到指定的位置。可以直接输入目标地址（如，工作表3.A1）或者预定义的范围。 Normally, sorting the data causes the existing data to be replaced by the newly sorted data. The Copy sort results to checkbox, however, causes the selected data to be left unchanged and a copy of the sorted data is copied to the specified location. You can either directly enter a target address (Sheet3.A1, for example) or select a predefined range.
勾选自定义的排序规则检查框基于预定义的一系列值排序。要设置自己的预定义列表，使用工具>选项>OpenOffice.org Calc>排序列表，然后输入自己的排序列表。在不按字母或数字排序时，预定义排序列表很有用。比如，基于一周里每天的名字排序。 Check the Custom sort order checkbox to sort based on a predefined list of values. To set your own predefined lists, use Tools > Options > OpenOffice.org Calc > Sort Lists and then enter your own sort lists. Predefined sort lists are useful for sorting lists of data that should not be sorted alphabetically or numerically. For example, sorting days based on their name.
 | 当一个单元格在排序操作中被移动，对该单元格的外部引用不会更新。如果一个单元格有一个对其他已被移动单元格的相对引用，当排序结束时引用将指向新位置。知道了排序过程中引用的行为不必惊慌，这通常正是你所想的——因为引用在同一行的右边或左边。同样，我还没发现有一种电子表格程序在排序过程中对引用有不同行为的。 |
| When a cell is moved during a sort operation, external references to that cell are not updated. If a cell that contains a relative reference to another cell is moved, the reference is relative to the new position when sorting is finished. Know the behavior of references during sorting and do not be alarmed, this is almost always what you want—because the reference is to the right or left in the same row. Also, I have not found a spreadsheet program that exhibits a different behavior for references while sorting. |
[编辑] 进度表
| Calc:数据排序 中文化进度 | 翻译 | 0 | 校对 | 0 | 插图 | / | 上次编辑 | 20100625071927 | 编者 | Yookee |
