Calc:选择Calc选项
出自OOo 中文指南手册翻译
目录 |
在选项对话框中，单击左侧OpenOffice.org Calc左边的+符号，显示其选项部分的下拉列表。 In the Options dialog, click the + sign to the left of OpenOffice.org Calc on the left-hand side. A list of subsections drops down. (1)
[编辑] Calc的常规选项 General options for Calc (3)
在选项对话框中，选择OpenOffice.org Calc > 常规。 In the Options dialog, choose OpenOffice.org Calc > General. (4)
[编辑] 字体尺度 Metrics section (6)
选择电子表格和默认制表位距离使用的计量单位。 Choose the unit of measurement used in spreadsheets and the default tab stops distance. (7)
[编辑] 更新部分 Updating section (8)
选择打开文档时，是否要自动更新链接、在询问后更新、或永不更新。不管此设置如何，您随时可以手动更新链接。如果它们通常包含许多图表或链接的图形，您可能希望避免打开文档时更新链接，否则可能会减慢加载。 Choose whether to update links when opening a document always, only on request, or never. Regardless of this setting, you can manually update links at any time. You might want to avoid updating links when opening documents if they often contain many charts or linked graphics that would slow down loading. (9)
[编辑] 输入设置部分 Input settings section (10)
指定按回车键将光标移动到另一个单元格。如果选择此选项，您还可以选择光标移动的方向：向上、向下、向左或向右。如果此选项没有选中，按下回车键完成数据单元格输入的输入，但不移动光标。 Specifies that pressing Enter moves the cursor to another cell. If this option is selected, you can also choose the direction the cursor moves: up, down, left, or right. If this option is not selected, pressing Enter completes data entry for a cell but does not move the cursor. (12)
按回车键切换到编辑模式 Press Enter to switch to edit mode (13)
指定在选定的单元格按回车键进入编辑模式。 Specifies that pressing Enter puts the selected cell into edit mode. (14)
套用前一个单元格格式 Expand formatting (15)
指定是否自动将选定单元格的格式属性应用到相邻的空单元格。例如，如果选定单元格的内容有加粗的属性，这个加粗属性也将适用于相邻的单元格。已经有特定格式的单元格，将不会受到此功能的影响。您可以按Ctrl + *（*是数字小键盘的乘号）快捷方式查看相关的范围。此格式也适用于在这个范围内插入的所有新的值。此范围之外的正常的单元格适用默认设置。 Specifies whether to automatically apply the formatting attributes of the selected cell to the empty adjacent cells. If, for example, the contents of the selected cell have the bold attribute, this bold attribute will also apply to adjacent cells. Cells that already have a special format will not be modified by this function. You can see the range in question by pressing the Ctrl+ (multiplication sign on the number pad) shortcut. This format also applies to all new values inserted within this range. The normal default settings apply to cells outside this range. (16)
扩展显示插入的行列引用内容 Expand references when new columns/rows are inserted (17)
指定在毗邻引用范围处插入列或行是否扩展引用。这只有在如果插入列或行的引用范围在期望的方向上本来至少跨越两个单元格的情况下才是可能的。 Specifies whether to expand references when inserting columns or rows adjacent to the reference range. This is only possible if the reference range, where the column or row is inserted, originally spanned at least two cells in the desired direction. (18)
例如：如果一个公式中引用了区域A1：B1，在B列后插入一个新列，引用扩大至A1：C1。如果引用了区域A1：B1，第1行下面插入一个新行，引用不扩大，因为在垂直方向只有一个单元格。 Example: If the range A1:B1 is referenced in a formula and you insert a new column after column B, the reference is expanded to A1:C1. If the range A1:B1 is referenced and a new row is inserted under row 1, the reference is not expanded, since there is only a single cell in the vertical direction. (19)
如果您在引用区域的中间插入一个行或列，引用总是扩展。 If you insert rows or columns in the middle of a reference area, the reference is always expanded. (20)
突出显示选中部分的列/行的标题 Highlight selection in column/row headings (21)
指定是否突出显示选定的列或行的标题。 Specifies whether to highlight column and row headers in the selected columns or rows. (22)
文字格式化采用打印版式 Use printer metrics for text formatting (23)
指定打印机版式不仅应用于打印，而且用于格式化屏幕上的显示。如果此选项未选中，独立于打印机的一个版式应用于屏幕显示和打印。 Specifies that printer metrics are applied for printing and also for formatting the display on the screen. If this option is not selected, a printer-independent layout is used for screen display and printing. (24)
粘贴数据时显示改写警告 Show overwrite warning when pasting data (25)
指定当您从剪贴板粘贴单元格到一个非空的范围时，会出现一个警告。 Specifies that, when you paste cells from the clipboard to a cell range that is not empty, a warning appears. (26)
[编辑] Calc的视图选项 View options for Calc (27)
在选项对话框中，选择OpenOffice.org Calc > 视图。 In the Options dialog, choose OpenOffice.org Calc > View. (28)
[编辑] 线条辅助 Visual aids section (30)
指定要显示的线条。 Specifies which lines are displayed. (31)
网格线 Grid lines (32)
指定屏幕上显示时是否显示单元格之间的网格线。如果选择此选项，您还可以指定当前文档中的网格线的颜色。这些设置保存在文档中。该颜色只有在工具 > 选项 > OpenOffice.org > 外观 > 电子表格 > 网格线设置为自动时才能看得到。 Specifies whether to display grid lines between the cells when viewed onscreen. If this option is selected, you can also specify the color for the grid lines in the current document. The settings are stored in the document. This color is only visible if Tools > Options > OpenOffice.org > Appearance > Spreadsheet > Grid lines is set to Automatic. (33)
要打印网格线，选择格式 > 页面 > 工作表，选择网格选项。 For printing, choose Format > Page > Sheet and mark the Grid option. (34)
分页符 Page breaks (35)
指定是否在定义的打印区域中显示分页符。 Specifies whether to view the page breaks within a defined print area. (36)
移动时显示辅助线 Guides while moving (37)
指定移动图形、框架、图片和其他对象时是否显示辅助线。这些辅助线帮助您对齐对象。 Specifies whether to view guides when moving drawings, frames, graphics and other objects. These guides help you align objects. (38)
标准控点 Simple handles (39)
指定是否显示控点（一个选择框上的八个点）为简单的正方形，没有3D效果。 Specifies whether to display the handles (the eight points on a selection box) as simple squares without a 3D effect. (40)
大控点 Large handles (41)
指定显示比标准控点大的控点（一个选择框上的八个点）。 Specifies that larger than normal handles (the eight points on a selection box) are displayed. (42)
[编辑] 显示部分 Display section (43)
选择屏幕显示的各种选项。 Select various options for the screen display. (44)
公式 Formulas (45)
指定在单元格中是否显示公式而不是其结果。 Specifies whether to show formulas instead of results in the cells. (46)
零值 Zero values (47)
指定是否显示值为0的数。 Specifies whether to show numbers with the value of 0. (48)
批注指标器 Comment indicator (49)
指定附有批注的单元格其右上角显示一个小矩形。如果在工具 > 选项 > OpenOffice.org > 常规中启用提示，指针悬停于单元格上时，显示批注的文本。 Specifies that a small rectangle is shown in the top right corner of the cell when a comment exists for that cell. The text of the comment is shown when you hover the pointer over the cell, if tips are enabled under Tools > Options > OpenOffice.org > General. (50)
要永久显示批注，右击单元格，然后从上下文菜单中点击选择显示批注。 To display a comment permanently, right-click on the cell and select Show Comment from the context menu. (51)
突出显示数值 Value highlighting (52)
选择此选项，以突出显示工作表中的所有值。文本突出显示为黑色；数字（包括逻辑值及日期）为蓝色；公式为绿色。 Select this option to highlight all values in the sheet. Text is highlighted in black; numbers (including logical values and dates) in blue; and formulas in green. (53)
当此命令启用时，在文档中指定的任何颜色均不显示。 When this command is active, any colors assigned in the document are not displayed. (54)
标记 Anchor (55)
指定是否显示插入对象如图形被选中时的锚点图标，。 Specifies whether the anchor icon is displayed when an inserted object, such as a graphic, is selected. (56)
文本溢出标志 Text overflow (57)
如果单元格中的文本比单元格的宽度宽，文本显示在同一行相邻的空单元格中。如果没有空的相邻的单元格，在单元格边框显示小三角，表明文本继续。 If a cell contains text that is wider than the width of the cell, the text is displayed over empty neighboring cells in the same row. If there is no empty neighboring cell, a small triangle at the cell border indicates that the text continues. (58)
彩色显示引用内容 Show references in color (59)
指定彩色突出显示公式中的每个引用。只要包含引用的单元格被选中进行编辑，单元格区域也同样被彩色边界包围。 Specifies that each reference is highlighted in color in the formula. The cell range is also enclosed by a colored border as soon as the cell containing the reference is selected for editing. (60)
[编辑] 对象部分 Objects section (61)
指定是否显示或隐藏三个对象组中的对象：对象和图像、图表和图形对象。 Specifes whether to display or hide objects in three object groups: objects and graphics; charts; and drawing objects. (62)
[编辑] 窗口部分 Window section (63)
指定某些元素在屏幕上是否可见：列/行标题、水平滚动条、垂直滚动条、工作表标签、以及大纲图标。 Specifies whether some elements are visible onscreen: column/row headers, horizontal scrollbar, vertical scrollbar, sheet tabs, and outline symbols. (64)
如果工作表标签选项未选中，你只能使用导航在工作表之间切换。 If the Sheet tabs option is not selected, you can only switch between the sheets by using the Navigator. (65)
请注意，在水平滚动条和工作表标签之间有一个滑块，可以被设置为端点之一。 Note that there is a slider between the horizontal scrollbar and the sheet tabs that may be set to one end. (66)
[编辑] 显示比例部分 Zoom section (67)
选择同步工作表选项，将任何选择的缩放比例应用于电子表格中的所有工作表。如果此选项未选中，各个工作表可以应用独立的缩放比例。 Select the Synchronize sheets option to apply any selected zoom factor to all sheets in the spreadsheet. If this option is not selected, separate zoom factors can be applied to individual sheets. (68)
[编辑] 计算选项 Calculate options (69)
在选项对话框中，选择OpenOffice.org Calc > 计算。 In the Options dialog, choose OpenOffice.org Calc > Calculate. (70)
使用此页面来定义电子表格的计算设置。 Use this page to define the calculation settings for spreadsheets. (71)
[编辑] 迭代计算部分 Iterative references section (73)
迭代引用就是不断反复、直到问题得到解决的公式。在本节中，您可以选择迭代近似计算的步数和答案的精确度。 Iterative references are formulas that are continuously repeated until the problem is solved. In this section you can choose the number of approximation steps carried out during iterative calculations and the degree of precision of the answer. (74)
迭代 Iterations (75)
选择此选项，启用迭代。如果此选项未选中，一个迭代引用导致出现一个错误信息。 Select this option to enable iterations. If this options is not selected, an iterative reference causes an error message. (76)
迭代步数 Steps (77)
设置迭代步骤的最大值。 Sets the maximum number of iteration steps. (78)
最小偏差值 Minimum Change (79)
指定两个连续迭代步骤的结果之间的差异。如果迭代的结果小于最低的偏差值，那么迭代将停止。 Specifies the difference between two consecutive iteration step results. If the result of the iteration is lower than the minimum change value, then the iteration will stop. (80)
[编辑] 日期部分 Date section (81)
选择天数到数字内部转换的开始日期。 Select the start date for the internal conversion from days to numbers. (82)
12/30/1899 默认 default)
设置12/30/1899为第0天 Sets 12/30/1899 as day zero.
01/01/1900 (StarCalc 1.0)
设置1900年1月1日为第9日。包含日期项的StarCalc 1.0电子表格，使用此设置。 Sets 1/1/1900 as day zero. Use this setting for StarCalc 1.0 spreadsheets containing date entries. (86)
01/01/1904
设置1904年1月1号为第0日。对于导入的其他格式的电子表格，使用此格式设置。 Sets 1/1/1904 as day zero. Use this setting for spreadsheets that are imported in a foreign format. (88)
[编辑] 其他选项 Other options (89)
指定与电子表格计算有关的各种选择。 Specify a variety of options relevant to spreadsheet calculation. (90)
区分字母大小写 Case sensitive (91)
指定比较单元格内容时是否区分文本中的大小写。EXACT文本函数总是大小写敏感的，与此对话框中的设置无关。 Specifies whether to distinguish between upper and lower case in texts when comparing cell contents. The EXACT text function is always case-sensitive, independent of the settings in this dialog. (92)
小数点位数 Decimal places (93)
定义标准数字格式中显示的小数位数。这些数字圆整后显示，但不是按圆整的数字保存。 Defines the number of decimals to be displayed for numbers with the Standard number format. The numbers are displayed as rounded numbers, but are not saved as rounded numbers. (94)
显示的精确度 Precision as shown (95)
指定是否要使用工作表中显示的四舍五入值进行计算。图表将按显示数值显示。如果此选项未选中，显示的数字四舍五入圆整，但他们在内部计算时使用未圆整的数值。 Specifies whether to make calculations using the rounded values displayed in the sheet. Charts will be shown with the displayed values. If this option is not selected, the displayed numbers are rounded, but they are calculated internally using the non-rounded number. (96)
查找条件 = 和 <> 必须适用于全部的单元格 Search criteria = and <> must apply to whole cells (97)
指定您设置的Calc数据库函数的查找条件必须与整个单元格完全相符。当选中这个选项后，在数据库函数中搜索单元格时，Calc的行为与MS Excel完全类似。 Specifies that the search criteria you set for the Calc database functions must match the whole cell exactly. When this option is selected, Calc behaves exactly like MS Excel when searching cells in the database functions. (98)
| 这个搜索： This search: (100) | 有这样的结果： Has this result: (101) |
| win | 找到win，但不包括win95，os2win，upwind。 Finds win, but not win95, os2win, or upwind (104) |
| win.* | 找到双赢和win95，而不包括os2win或upwind Finds win and win95, but not os2win or upwind (107) |
| .*win | 找到win和os2win，而包括win95或upwind Finds win and os2win, but not win95 or upwind (110) |
| .*win.* | 找到win、win95，os2win，以及upwind Finds win, win95, os2win, and upwind (113) |
如果此选项未选中，上面的win搜索样式的行为像.*win.* - 在用Calc数据库函数进行搜索时，该搜索样式可以在单元格内的任何位置。 If this option is not selected, the win search pattern acts like .win. —the search pattern can be at any position within the cell when searching with the Calc database functions. (115)
允许公式含有正则表达式 Enable regular expressions in formulas (116)
指定搜索时和字符串比较时启用正则表达式。这涉及到数据库函数，以及VLOOKUP、HLOOKUP和SEARCH。 Specifies that regular expressions are enabled when searching and also for character string comparisons. This relates to the database functions, and to VLOOKUP, HLOOKUP and SEARCH. (117)
自动查找列和行标签 Automatically find column and row labels (118)
指定您可以使用任何单元格中的文本作为文本下面一列或者文本右边一行的标签。该文本必须包括至少一个单字，以及不能含有任何运算符。 Specifies that you can use the text in any cell as a label for the column below the text or the row to the right of the text. The text must consist of at least one word and must not contain any operators. (119)
例如：单元格E5包含文字欧洲。下面，在单元格E6中，是数值100；单元格E7是数值200。如果自动查找列和行标签选项被选中，你可以在单元格A1中写入以下公式：=SUM（欧洲）。 Example: Cell E5 contains the text Europe. Below, in cell E6, is the value 100 and in cell E7 the value 200. If the Automatically find column and row labels option is selected, you can write the following formula in cell A1: =SUM(Europe). (120)
[编辑] 排序列表选项 Sort Lists options (121)
在选项对话框中，选择OpenOffice.org Calc > 排序列表。除了所提供的清单，您可以定义和修改自己的列表，如第2章“定义填充序列”（输入、编辑与格式化数据）中所述。 In the Options dialog, choose OpenOffice.org Calc > Sort Lists. In addition to the supplied lists, you can define and edit your own lists, as described in “Defining a fill series” in Chapter 2 (Entering, Editing, and Formatting Data). (122)
[编辑] 更改选项 Changes options (124)
在选项对话框中，选择OpenOffice.org Calc > 更改。 In the Options dialog, choose OpenOffice.org Calc > Changes. (125)
在此页面上您可以指定突出显示电子表格中记录的更改的选项。您可以指定用于插入、删除和其他变化的特定的颜色，也可以让Calc根据变更的作者分配颜色。在后一种情况下，该作者的所有变更将应用同一种颜色。 On this page you can specify options for highlighting recorded changes in spreadsheets. You can assign specific colors for insertions, deletions, and other changes, or you can let Calc assign colors based on the author of the change; in the latter case, one color will apply to all changes made by that author. (127)
[编辑] 网格选项 Grid options (128)
网格页面定义电子表格的网格设置。使用网格可以帮助您确定任何添加到电子表格的图表或其他对象的确切位置。您还可以设置此网格与对齐网格一致。 The Grid page defines the grid settings for spreadsheets. Using a grid helps you determine the exact position of any charts or other objects you may add to a spreadsheet. You can also set this grid in line with the snap grid. (129)
如果您已经启动了与网格对齐，但希望移动或创建单个没有对齐位置限制的对象，您可以按下Ctrl键，根据需要停用与网格对齐。 If you have activated the snap grid but wish to move or create individual objects without snap positions, you can press the Ctrl key to deactivate the snap grid for as long as needed. (130)
在选项对话框中，选择OpenOffice.org Calc > 网格。 In the Options dialog, choose OpenOffice.org Calc > Grid. (131)
[编辑] 网格部分 Grid section (133)
与网格对齐启用与网格对齐功能。 Snap to grid activates the snap function. (134)
显示网格在屏幕上显示网格点。这些网格点并不打印出来。 Visible grid displays grid points on the screen. These points are not printed. (135)
[编辑] 分辨率部分 Resolution section (136)
在这里您可以设置横向及纵向网格点以及网格次级分节（中间点）之间的间距单位。 Here you can set the unit of distance for the spacing between horizontal and vertical grid points and subdivisions (intermediate points) of the grid. (137)
同步化轴数值对称改变当前网格设置。 Synchronize axes changes the current grid settings symmetrically. (138)
[编辑] 打印选项 Print options (139)
在选项对话框中，选择OpenOffice.org Calc > 打印。见第6章有关此页上选项的更多信息（打印、导出和电子邮送）。 In the Options dialog, choose OpenOffice.org Calc > Print. See Chapter 5 (Printing, Exporting, and E-mailing) for more about the options on this page. (140)
[编辑] 进度表
| Calc:选择Calc选项 中文化进度 | 翻译 | 100% | 校对 | 0 | 插图 | / | 上次编辑 | 20100309231751 | 编者 | PingjuOOo |
