Calc:使用多个工作表

出自OOo 中文指南手册翻译

目录 1 为什么要使用多张工作表？ Why use multiple sheets? (1) 2 设置多张表 Setting up multiple sheets (7) 2.1 识别表 Identifying sheets (9) 2.2 插入新的表 Inserting new sheets (12) 3 重命名表 Renaming sheets (37) 4 进度表 5 相关链接

[编辑] 为什么要使用多张工作表？ Why use multiple sheets? (1)

第1章介绍了电子表格中多个工作表的概念。多张工作有助于保持信息的有序组织。一旦将这些表链接在一起，会发挥出Calc的全部功能。考虑这种情况。 Chapter 1 introduced the concept of multiple sheets in a spreadsheet. Multiple sheets help keep information organized; once you link those sheets together, you unleash the full power of Calc. Consider this case. (2)

约翰在记录其个人财务方面有困难。他有几个银行帐户，信息分散且混乱。除非他可以一次看到所有记录，他就不能很好掌握他的财务状况。 John is having trouble keeping track of his personal finances. He has several bank accounts and the information is scattered and disorganized. He can’t get a good grasp on his finances until he can see everything at once. (3)

要解决这个问题，约翰决定用OOo的Calc记录自己的财务状况。约翰知道Calc可以做简单的数学计算，以帮助他保持他的帐户的运转标签。他希望建立一个汇总表，使他可以同时看到他的所有账户的余额。 To resolve this, John decided to track his finances in OOo Calc. John knows Calc can do simple mathematical computations to help him keep a running tab of his accounts, and he wants to set up a summary sheet so that he can see all of his account balances at once. (4)

这可以很容易地做到。 This can be accomplished easily. (5)

[编辑] 设置多张表 Setting up multiple sheets (7)

第1章给出了如何在一个电子表格中建立多个工作表的详细解释。下面是一个快速复习。 Chapter 1 gives a detailed explanation of how to set up multiple sheets in a spreadsheet. Here is a quick review. (8)

[编辑] 识别表 Identifying sheets (9)

当您打开一个新的电子表格时，它默认包括三个表，名为工作表1、工作表2、和工作表3。Calc中使用在电子表格底部的的标签管理表，如下所示。 When you open a new spreadsheet it has, by default, three sheets named Sheet1, Sheet2, and Sheet3. Sheets in Calc are managed using tabs at the bottom of the spreadsheet, as shown below. (10)

(译者注： 原图是CG3Ch9F1.png)

[编辑] 插入新的表 Inserting new sheets (12)

有几种方法用来插入一个新表。在任何情况下，第一步是选择与下一个新表相邻的工作表。然后执行下列操作之一： There are several ways to insert a new sheet. The first step, in all cases, is to select the sheet that will be next to the new sheet. Then do any of the following: (13)

• 从菜单栏选择插入> 表，或 Select Insert > Sheet from the menu bar, or (14)

• 右键单击标签，然后选择插入工作表，或 Right-click on the tab and select Insert Sheet, or (15)

• 单击工作表标签行末尾的空白区域。 Click in an empty space at the end of the line of sheet tabs. (16)

(译者注： 原图是 CG3Ch9F2.png)

每个方法都打开插入表对话框。在这里你可以选择把新表插入在选定的工作表之前或之后、以及表插多少个新工作表。 Each method opens the Insert Sheet dialog. Here you can choose to put the new sheet before or after the selected sheet and how many sheets to insert. (18)

我们需要6个表，5个帐户各有一个表，以及汇总表。因此我们需要增加3个表。我们也要让表的名称为其所代表的帐户：汇总、支票帐户、储蓄帐户、信用卡1、信用卡2、和汽车贷款。 We need 6 sheets, one for each of the 5 accounts and one as a summary sheet so we will add 3 more. We also want to name each of these sheets for the account they represent: Summary, Checking Account, Savings Account, Credit Card 1, Credit Card 2, and Car Loan. (20)

我们有两种选择：插入3个新表，然后命名所有6张表；或重命名现有的工作表，然后再一次一个插入三个新表，在插入每一个新工作表时重命名它。 We have two choices: insert 3 new sheets and rename all 6 sheets afterwards; or rename the existing sheets, then insert the three new sheets 1 at a time, renaming each new sheet during the insert step. (21)

要插入3个表然后重命名： To insert sheets and rename afterwards: (22)

1. 在插入工作表对话框中，选择新表的位置（在这个例子中，我们使用在当前的工作表之后)。 In the Insert Sheet dialog, choose the position for the new sheets (in this example, we use After current sheet). (23)
2. 选择新建工作表和3作为工作表数目。 （默认已经有3个表。）因为你是插入多个工作表，名称框不可用。 Choose New sheet and 3 as the No. of sheets. (Three sheets are already provided by default.) Because you are inserting more than one sheet, the Name box is not available. (24)
3. 点击确定插入表。 Click OK to insert the sheets. (25)
4. 接下来的步骤，参见下面的“重命名表”。 For the next steps, go to “Renaming sheets” below. (26)

要同时插入表和命名之： To insert sheets and name them at the same time: (27)

1. 重命名已有的表为汇总、支票帐户和储蓄帐户，如下面“重命名表”中所述。 Rename the existing sheets Summary, Checking Account, and Savings Account, as described in “Renaming sheets” below. (28)
2. 在插入表对话框中，选择了第一个新工作表的位置。 In the Insert Sheet dialog, choose the position for the first new sheet. (29)
3. 选择新建工作表，工作表数目为1。名称框现在可用。 Choose New sheet and 1 as the No. of sheets. The Name box is now available. (30)
4. 在名称框中，键入这个新工作表的名称，例如信用卡1。 In the Name box, type a name for this new sheet, for example Credit Card 1. (31)
5. 点击确定插入表。 Click OK to insert the sheet. (32)
6. 为每个新的工作表重复步骤1-4，将其命名为信用卡2和汽车贷款。 Repeat steps 1–4 for each new sheet, giving them the names Credit Card 2 and Car Loan. (33)

在插入表对话框中，您还可以从另一个不同的电子表格文档（例如一个Calc或Excel电子表格）添加一个表，选择从文件创建选项。点击浏览并选择相应的文档，一个可用工作表的列表显示在框中。选择要导入的表。如果在您选择相应的文档后，没有出现工作表列表，那么你可能选择了一个无效的文档类型（例如不是电子表格）。 On the Insert Sheet dialog, you can also add a sheet from a different spreadsheet file (for example, another Calc or Excel spreadsheet), by choosing the From file option. Click Browse and select the file; a list of the available sheets appears in the box. Select the sheet to import. If, after you select the file, no sheets appear you probably selected an invalid file type (not a spreadsheet, for example). (34)

(译者注： 然后插入对话框在它之上打开 -> 实际上在其上打开的是插入文件对话框)

如果您组要，请选择链接选项，将外部表作为链接插入，而不是作为副本插入。这是从另一个电子表格引用“活”数据的几个方法之一。 （参见页面错误：未找到引用源上的“错误：未找到引用源”。）链接可以手动更新以显示外部文档的当前内容，或者，取决于您在工具 > 选项 > OpenOffice.org Calc > 常规 > 更新选择的选项，在打开文档时自动更新。 If you prefer, select the Link option to insert the external sheet as a link instead as a copy. This is one of several ways to include “live” data from another spreadsheet. (See also “Error: Reference source not found” on page Error: Reference source not found.) The links can be updated manually to show the current contents of the external file; or, depending on the options you have selected in Tools > Options > OpenOffice.org Calc > General > Updating, whenever the file is opened. (36)(译者注： See also “Error: Reference source not found” on page Error: Reference source not found. 似乎有点问题)

[编辑] 重命名表 Renaming sheets (37)

表可以在任何时候重新命名。要给工作表一个更有意义的名称： Sheets can be renamed at any time. To give a sheet a more meaningful name: (38)

• 当创建表时在名称框中输入名称，或 Enter the name in the name box when you create the sheet, or (39)

• 右键单击工作表标签，从弹出式菜单选择重命名表，并取代现有的名称。 Right-click on a sheet tab, select Rename Sheet from the pop-up menu and replace the existing name. (40)

您的工作表标签区域现在是这个样子。 Your sheet tab area should now look like this. (42)

现在我们将建立帐户分类帐。这只是一个简单的汇总，包括以前的余额加上当前的交易额。对于提款，我们输入一个负数作为当前的交易额，以使余额变小。一个基本的分类帐如下所示。 Now we will set up the account ledgers. This is just a simple summary that includes the previous balance plus the amount of the current transaction. For withdrawals, we enter the current transaction as a negative number so the balance gets smaller. A basic ledger is shown below. (44)

该分类帐包括在支票帐户表中。总余额汇总在单元格F3中。你在编辑栏中可以看到它的公式。它是开户余额，即单元格C3，及随后的所有交易的汇总。 This ledger is set up in the sheet named Checking Account. The total balance is summed in cell F3. You can see the equation for it in the formula bar. It is the summary of the opening balance, cell C3, and all of the subsequent transactions. (45)

[编辑] 进度表

Calc:使用多个工作表 中文化进度

翻译

100%

校对

0

插图

/

上次编辑

20100310113924

编者

PingjuOOo

[编辑] 相关链接

本文原文