LibreOffice 3.4入门/Calc入门

Calc是什么? 编辑

Calc is the spreadsheet component of LibreOffice. You can enter data (usually numerical) in a spreadsheet and then manipulate this data to produce certain results.
Calc是LibreOffice的电子表格软件。你可以在电子表格里输入数据(通常为数字),然后操作这个数据产生某些结果。

Alternatively you can enter data and then use Calc in a ‘What if...’ manner by changing some of the data and observing the results without having to retype the entire spreadsheet. 此外,修改部分数据时你可以使用“What if...”方式来查看结果,而不必通过重新输入整个电子表格。

Other features provided by Calc include:

Calc其他特点包括:

  • Functions, which can be used to create formulas to perform complex calculations on data
  • Database functions, to arrange, store, and filter data
  • Dynamic charts; a wide range of 2D and 3D charts
  • Macros, for recording and executing repetitive tasks
  • Ability to open, edit, and save Microsoft Excel spreadsheets
  • Import and export of spreadsheets in multiple formats, including HTML, CSV, PDF, and PostScript
* 函数:可以提供公式及函数对数据进行复杂的运算。
* 数据库函数:排列、储存、过滤数据。
* 动态的图表:含有多种2D或者3D图表。
* 宏:记录及完成重复的任务
* 可以打开,编辑及保存 Microsoft Excel 电子表格
* 以多种格式导入和导出电子表格文件,包括 HTML、CSV、PDF和PostScript等。

Note
If you want to use macros written in Microsoft Excel using the VBA macro code in LibreOffice, you must first edit the code in the LibreOffice Basic IDE editor. See Chapter 13, Getting Started with Macros, in this book and Chapter 12 in the Calc Guide.
提示
如果您想在LibreOffice使用Microsoft Excel的VBA宏,您必须首先在LibreOffice Basic IDE编辑器对代码进行的编辑。详情,请参见第13章“宏的使用入门”,以及第12章“Calc指南”。

电子表格、工作表与单元格 编辑

Spreadsheets, sheets and cells
Calc works with documents called spreadsheets. Spreadsheets consist of a number of individual sheets, each sheet containing cells arranged in rows and columns. A particular cell is identified by its row number and column letter.

由Calc操作的文档叫做电子表格。电子表格由许多单个的工作表组成,每个工作表中含有由行与列分割成的单元格。一个特定的单元格是通过它所在的行序号和所在的列字母序号来标识的。

Cells hold the individual elements—text, numbers, formulas, and so on—that make up the data to display and manipulate. 单元格里保存着由文本、数值、公式等组成的单个数据,这些数据可以被显示和操作。

Each spreadsheet can have many sheets, and each sheet can have many individual cells. In Calc 3.3, each sheet can have a maximum of 1,048,576 rows and 1024 columns.

每一个电子表格能够包含许多的工作表,每个工作表能够包含许多个单元格。在Calc3.3中,每个工作表最多能拥有1,048,576行和1024列。

Calc的局部主窗口界面 编辑

Parts of the main Calc window

When Calc is started, the main window looks similar to Figure 91.

Calc启动后,其主窗口界面如图91所示。

标题栏 编辑

Title bar

The Title bar, located at the top, shows the name of the current spreadsheet. When the spreadsheet is newly created, its name is Untitled X, where X is a number. When you save a spreadsheet for the first time, you are prompted to enter a name of your choice.

标题栏,位于顶部,显示当前电子数据表文件的文件名。如果电子数据表文件是新创建的,就它的文件就是“未命名X”,“X”是一个阿拉伯数字。当您第一次保存电子表格文件时,系统将会提示你输入一个文件名。

菜单栏 编辑

Menu bar

Under the Title bar is the Menu bar. When you choose one of the menus, a submenu appears with other options. You can modify the Menu bar, as discussed in Chapter 14, Customizing LibreOffice.

在标题栏下面的是菜单栏。当您选择菜单栏的某一项时,将会显示带其他选项的子菜单。你可以自定义菜单栏,详情请参考第14章 “定制LibreOffice”。

 
图91 Calc的局部主界面

工具栏 编辑

Toolbars

Three toolbars are located under the Menu bar by default: the Standard to toolbar, the Formatting toolbar, and the Formula Bar.

在菜单栏下,默认排列着三个工具栏:标准工具栏,格式工具栏和公式工具栏等。

The icons (buttons) on these toolbars provide a wide range of common commands and functions. You can also modify these toolbars, as discussed in Chapter 14, Customizing LibreOffice.

在这些工具栏上面的图标提供了一系列的常用命令和功能。您也可以定制它们,详情请参考第14章定制LibreOffice。

In the Formatting toolbar, the three boxes on the left are the Apply Style, Font Name, and Font Size lists. They show the current setting for the selected cell or area. (The Apply Style list may not be visible by default.) Click the down-arrow to the right of each box to open the list.

在格式工具栏上,左边的三个选项框分别为:使用样式列表字体名称列表字体大小列表等,它们显示是“您所选中的单元格或选取区域”的当前相关设置。(“使用样式列表”可能默认不显示)。单击各个列表框的右边的向下箭头来打开列表。

 
图92 使用样式列表、字体名称列表和字体大小列表

公式栏 编辑

Formula bar

On the left hand side of the Formula bar is a small text box, called the Name Box, with a letter and number combination in it, such as D7. This combination, called the cell reference, is the column letter and row number of the selected cell.

在公式栏的左侧,有一个小的文字框,叫做“名称框”,里面由字母和数字组合,比如“D7”。这种组合,称为单元格引用,是您由所选中单元格的列对应字母和行对应的数字组成。

To the right of the Name box are the the Function Wizard, Sum, and Function buttons.

在名称框的右侧分别为:“函数向导求和函数按钮。

Clicking the Function Wizard button opens a dialog from which you can search through a list of available functions. This can be very useful because it also shows how the functions are formatted.

单击“函数向导”按钮会打开一个对话框,您可以从里面搜索一系列的函数列表。这是非常有用的功能,因为它同时也显示了函数的参数格式。

 
Figure 93. Formula bar

In a spreadsheet the term function covers much more than just mathematical functions. See Chapter 7 in the Using Formulas and Functions for more details.

在电子数据表软件中,函数功能涵盖范围远远超过数学计算。更多详情,请参见第4节公式与函数的使用

Clicking the Sum button inserts a formula into the current cell that totals the numbers in the cells above the current cell. If there are no numbers above the current cell, then the cells to the left are placed in the Sum formula.

单击“求和”按钮将会在当前选中的单元格中插入求和函数,该函数会对当前选中单元格位置之上的所有单元格求和,如果当前选中单元格位置之上没有数值数据,那么将会对其左侧所有单元格求和。

Clicking the Function button inserts an equals (=) sign into the selected cell and the Input line, enabling the cell to accept a formula.

单击函数按钮将会在当前选取单元格及“输入栏”中插入等号“=”,可以单元格里或输入栏里输入公式。

When you enter new data into a cell, the Sum and Equals buttons change to Cancel and Accept buttons [[Image:]].

当你在单元格里输入一个数据时,“求和”“函数”按钮会分别变成“取消”“采用”按钮。

 
Add caption here

The contents of the current cell (data, formula, or function) are displayed in the Input line, which forms the remainder of the Formula Bar. You can edit the contents of the current cell on the Input line or in the cell itself. To edit on the Input line, click in the line, then type your changes. To edit within the current cell, just double-click the cell.

当前选取的“单元格”的内容(包括数据、公式或者函数)都会显示在“输入栏”,输入栏的外形占据了公式栏的剩余空间。您可以选择在“输入栏”或者当前选取的单元格处编辑单元格内容;若您选择在“输入栏”里编辑,点击它,键入您的更改,若您选择在在当前选取的单元格里编辑,只要双击该单元格就可以了。

单个单元格 编辑

The main section of the screen displays the cells in the form of a grid, with each cell being at the intersection of a column and a row.

在屏幕上所显示的网格是由行与列交织而成的单元格组成。

At the top of the columns and at the left end of the rows are a series of gray boxes containing letters and numbers. These are the column and row headers. The columns start at A and go on to the right, and the rows start at 1 and go down.

在列的最顶端与行的最左端分别有一系列的包含字母与数字的灰色框,这些就是列与行的标题。“列”是由字母“A”起始,以字母表顺序向右递增;而“行”是由数字“1”起始,向下递增。

These column and row headers form the cell references that appear in the Name Box on the Formula Bar (Figure 93). You can turn these headers off by selecting View > Column & Row Headers.

这些列与行的标题构成了单元格引用,该引用会出现在“公式栏”上的“名称框”(见图93)。您可以通过选择“视图 > 列/行标题”关闭它们的标题显示。

工作表标签 编辑

Sheet tabs

At the bottom of the grid of cells are the sheet tabs. These tabs enable access to each individual sheet, with the visible (active) sheet having a white tab. You can choose colors for the different sheet tabs by right-clicking the space, choosing Tab Color, and choosing a color from the palette.

工作表标签是在由单元格组成的网格底部。这些标签可以进入每个独立的工作表,当前活动的工作表标签是白色的。您可以为不同的工作表标签选择不同的颜色,右击标签,然后从调色板中选择一种颜色。

Clicking on another sheet tab displays that sheet, and its tab turns white. You can also select multiple sheet tabs at once by holding down the Control key while you click the names.

单击另一个工作表标签时将会显示另一个工作表,同时该标签颜色变成白色。若您要选择多个工作表,可按住“Ctrl”键再加上鼠标左鍵来选取工作表。

[[Image:|thumb|Figure 94: Choosing a tab color]]

状态栏 编辑

Status bar

At the very bottom of the Calc window is the status bar, which provides information about the spreadsheet and convenient ways to quickly change some of its features. Most of the fields are similar to those in other components of LibreOffice; see Chapter 1, Introducing LibreOffice, in this book and Chapter 1, Introducing Calc, in the Calc Guide.

状态栏位于Calc窗口界面的最底部,它提供了电子表格的信息,以及便捷的方式来快速地修改一些属性。其大部字段与LibreOffice的软件相类似,详情请参考第1章LibreOffice的简介,及在Calc入门中有关Calc的简介。

 
图95:状态栏左侧


 
状态栏右侧

打开和保存CSV文件 编辑

Opening and saving CSV files

Chapter 1, Introducing LibreOffice, includes instructions on starting new Calc documents, opening existing documents, and saving documents.

A special case for Calc is opening and saving comma-separated-values (CSV) files, which are text files that contain the cell contents of a single sheet. Each line in a CSV file represents a row in a spreadsheet. Commas, semicolons, or other characters are used to separate the cells. Text is entered in quotation marks, numbers are entered without quotation marks.

Calc还有一个特殊的功能,那就是还可以打开并保存CSV文件,CSV文件是包含单独工作表的单元格内容的纯文本格式文件。CSV文件里的每一行代表电子表格里的行。它用逗号,分号或者其他的字符用来分开单元格,输入文本(字符串)时要用引号(英文的"")标记,输入数值时则不要引号标记。

打开一个CSV文件 编辑

Opening a CSV file

To open a CSV file in Calc:

在Calc里打开CSV文件,步骤如下:

* 第一步:选择“文件”-“打开”。
* 第二步:找到你想打开的CSV文件的位置。
* 第三步:如果文件有*.csv后缀,选择它并单击“打开”。
* 第四步:如果文件有其他的后缀(例如:*,txt),在文件格式框里选择“文本CSV(*.csv;*txt;*xls)”,你可以滚动以便找到它。然后单击 “打开”。
* 第五步在Text导入对话框(图97),选择“分隔选项”把文件中的文本分隔成数据列(字段)。您也可以在对话框底部预览导入数据的布局。
* 第六步:单击确定来打开文件
  1. Choose File > Open.
  2. Locate the CSV file that you want to open.
  3. If the file has a *.csv extension, select the file and click Open.
  4. If the file has another extension (for example, *.txt), select the file, select Text CSV (*csv;*txt;*xls) in the File type box (you will have to scroll down some distance to find it) and then click Open.
  5. On the Text Import dialog (Figure 97), select the Separator options to divide the text in the file into columns.
    You can preview the layout of the imported data at the bottom of the dialog.

Right-click a column in the preview to set the format or to hide the column.
If the CSV file uses a text delimiter character that is not in the Text delimiter list, click in the Text delimiter box, and type the character.

  1. Click OK to open the file.


[[Image:|thumb|Figure 97: Text Import dialog, with Comma (,) selected as the separator and double quotation mark (“) as the text delimiter.]]

另存为CSV文件 编辑

Saving as a CSV file

To save a spreadsheet as a comma separate value (CSV) file:

把电子数据表另存为CSV文件的步骤如下:

  1. Choose File > Save As.
  2. In the File name box, type a name for the file.
  3. In the File type list, select Text CSV (.csv) and click Save.
  • 第一步:选择菜单“文件 > 另存为”。
  • 第二步:在“文件名”输入框里,输入文件名。
  • 第三步:在“文件类型”列表中,选择“Text CSV(.csv)”,然后单击“保存”

You may see the message box shown below. Click Keep Current Format.

接下您可能会看到一个提示信息框,请单击“保留当前格式”。

[[Image:]]
  1. In the Export text file dialog, select the options you want and then click OK.

第四步:在“导出文本文件”对话框里,选择您需要的选项,然后单击“确定”

[[Image:|thumb|Figure 98: Choosing options when exporting to Text CSV]]

操作电子表格文件 编辑

Navigating within spreadsheets

Calc provides many ways to navigate within a spreadsheet from cell to cell and sheet to sheet. You can generally use the method you prefer.

Calc提供了多种方式来操作电子表格文件,不管是从单元格到单元格还是从工作表到工作表的操作,您可以选择您习惯的操作方式。

跳转到指定的单元格 编辑

Going to a particular cell

Using the mouse

使用鼠标

把光标放到该单元格上方,然后单击。

Place the mouse pointer over the cell and click.

Using a cell reference

使用单元格引用

Click on the little inverted black triangle just to the right of the Name Box (Figure 93). The existing cell reference will be highlighted. Type the cell reference of the cell you want to go to and press Enter. Or just click into the Name box, backspace over the existing cell reference and type in the cell reference you want and press Enter.

单击位于名称框右侧的黑色反向三角形,那么“当前单元格引用”就会高亮显示(见图93)。输入您要跳转到单元格的引用,然后按“Enter”键,或者只要单击名称框,删除“当前单元格引用”,然后输入您要跳到到的单元格的引用,再按“Enter”键。

Using the Navigator

使用导航

To open the Navigator, click its icon [[Image:]] on the Standard toolbar, or press F5, or choose View > Navigator on the Menu bar, or double-click on the Sheet Sequence Number [[Image:]] in the Status Bar. Type the cell reference into the top two fields, labeled Column and Row, and press Enter. In Figure 99 the Navigator would select cell A7.

若要打开“导航”,请在标准工具上单击它图标,或按“F5”键,或在菜单栏上选择“视图 > 导航”,又或者双击状态栏上的工作表编号。输入单元格的引用(列的字母标题与行的数字标题)到顶部的两个输入框中,标签名分别为“”和“”,然后按“Enter”键。在图99中,导航将会选取单元格A7。

You can dock the Navigator to either side of the main Calc window or leave it floating. (To dock or float the Navigator, hold down the Control key and double-click in an empty area near the icons in the Navigator dialog.)

您可以把“导航”固定到Calc主窗口的任意一边,或让它浮动。(若要固定或浮动“导航”,按住“Ctrl”键,然后双击“导航对话框”的图标旁的空白区域)。

[[Image:|thumb|Figure 99: The Navigator in Calc]]

The Navigator displays lists of all the objects in a document, grouped into categories. If an indicator (plus sign or arrow) appears next to a category, at least one object of this kind exists. To open a category and see the list of items, click on the indicator.

“导航”以列表形式显示了一个文档中的所有对象,并把它们分成不同类别。如果某个类别旁边有一个指示器(“+”或箭头),那么该类别下就存在多个对象。若要打开某个类别并查看其中的对象,单击该指示器。

To hide the list of categories and show only the icons at the top, click the Contents icon [[Image:]]. Click this icon again to show the list.

若要隐藏某种类别列表并使之仅在顶部以图标显示,单击“内容”图标,再次单击这个图标,列表又再出现。

单元格与单元格之间的移动操作 编辑

Moving from cell to cell
In the spreadsheet, one cell normally has a black border. This black border indicates where the focus is (see Figure 100). If a group of cells is selected, they are highlighted in a light blue color, with the focus cell having a black border.

在电子表格文件中,单元格如果被选取则会有黑色边框,这个黑色边框指示焦点所在(见图100)。如果某个单元格区域被选中,那么该区域的所有单元格都会以淡蓝色高亮显示,而选取的单元格则会有黑色边框。下面就介绍几种操作单元格的方法。

Using the mouse

To move the focus using the mouse, simply move the mouse pointer to the cell where you want the focus to be and click the left mouse button. This changes the focus to the new cell. This method is most useful when the two cells are a large distance apart.

方法一:使用鼠标

若要使用鼠标来移动单元格位置,只要移动鼠标指针到您要选取的单元格,然后再单击鼠标,这时单元格位置就变成另一个单元格。
当两个单元格相隔太远时,这是最有效的方法。
[[Image:|thumb|
Figure 100. (Left) One selected cell and (right) a group of selected cells]]

Using the Tab and Enter keys

  • By default, pressing Enter or Shift+Enter moves the focus down or up, respectively.
  • Pressing Tab or Shift+Tab moves the focus to the right or to the left, respectively.

方法二:使用“Tab”及“Enter”键

*  Calc默认使用“Enter”或“Shift+Enter”键分别移动单元格位置向下或向上。
*  Calc默认使用“Tab”或“Shift+Tab”键分别移动单元格位置向右或向左。

Using the arrow keys

Pressing the arrow keys on the keyboard moves the focus in the direction of the arrows.

方法三:使用方向键

按键盘上的方向键来移动单元格位置。

Using Home, End, Page Up and Page Down

  • Home moves the focus to the start of a row.
  • End moves the focus to the column furthest to the right that contains data.
  • Page Down moves the display down one complete screen and Page Up moves the display up one complete screen.
  • Combinations of Control and Alt with Home, End, Page Down, Page Up, and the cursor keys move the focus of the current cell in other ways. See the Help or Appendix A, Keyboard Shortcuts, in the Calc Guide for details.

方法四:使用Home,End Page UP和Page Down

* “Home”将会把单元格位置移到该行的开头
* “End”将会把单元格位置移到右边含有数据的最后一列
* “Page Down”把屏幕移到下一个完整页,"Page Up"把屏幕移到上一个完整页。
* Ctrl、Alt键,组合Home, End, Page Down, Page Up及方向键以移动单元格位置的其他方法,请参考快捷键列表,详情请参见Calc入门。
Tip
Use one of the four Alt+Arrow key combinations to resize a cell.
提示
使用“Alt+方向键”的来调整单元格大小

自定义“Enter”键功能 编辑

You can customize the direction in which the Enter key moves the focus, by selecting Tools > Options > LibreOffice Calc > General.

您可以从菜单栏上选择“工具 > 选项 > LibreOffice Calc > 一般”,在选项页里自定义“Enter”键移动单元格位置的方向。

The four choices for the direction of the Enter key are shown on the right hand side of Figure 101. It can move the focus down, right, up, or left. Depending on the file being used or on the type of data being entered, setting a different direction can be useful.

在图101右边,“Enter”键显示了四个方向选项。它可以移动单元格位置“上、下、左、右”等。根据不同的文档与输入的数据类型,设置一个最有利的移动方向。

The Enter key can also be used to switch into and out of editing mode. Use the first two options under Input settings in Figure 101 to change the Enter key settings.

Enter”也可以设置为编辑模式切换键,只要使用“输入设置”下前两个选项(见图101)就能修改“Enter”键的相关设置。

[[Image:|thumb|Figure 101: Customizing the effect of the Enter key]]

工作表之间的移动操作 编辑

Moving from sheet to sheet
Each sheet in a spreadsheet is independent of the others, though they can be linked with references from one sheet to another. There are three ways to navigate between different sheets in a spreadsheet.

在电子表格文件中,工作表之间可以通过引用来相互链接,但每个工作表却都是独立的。有三种方式来对不同的工作表进行操作,如下:

Using the Navigator

When the Navigator is open (Figure 99), double-clicking on any of the listed sheets selects the sheet.

使用导航

当“导航”打开时(见图99),您可以双击工作表列表中的任意一个来选取工作表。

Using the keyboard

Pressing Control+Page Down moves one sheet to the right and pressing Control+Page Up moves one sheet to the left.

使用键盘

* 按“Ctrl+Page Down”键移动一个工作表到右边另一个;
* 按“Ctrl+Page Up”键移动一个工作表到左边另一个;

Using the mouse

Clicking on one of the sheet tabs at the bottom of the spreadsheet selects that sheet.

使用鼠标

在电子表格文件里,单击底部的任意一种工作表标签来选取工作表。

If you have a lot of sheets, then some of the sheet tabs may be hidden behind the horizontal scroll bar at the bottom of the screen. If this is the case, then the four buttons at the left of the sheet tabs can move the tabs into view. Figure 102 shows how to do this.

如果您有太多的工作表,那么有些“工作表的标签”也许就会隐藏到底部的“水平滚动条”后面。这时工作表标签的左边就会出现四个按钮,按这四个按钮就会显示隐藏的工作表标签。

[[Image:|thumb|Figure 102. Sheet tab arrows]]

Notice that the sheets here are not numbered in order. Sheet numbering is arbitrary; you can name a sheet as you wish. 注:工作表之间没有编号顺序的,是任意排列的,您可以任意命名工作表的名称。

Note
The sheet tab arrows that appear in Figure 102 only appear if you have some sheet tabs that are hidden by the horizontal scrollbar. Otherwise, they will appear faded as in Figure 91.
备注
只有在您有一些工作表标签被隐藏到了水平滚动条之后时,工作表标签箭头才会可用(见图102);否则,它们是灰色的即不可用(见图91)。

在工作表或电子表格中,如何选取项目 编辑

Selecting items in a sheet or spreadsheet

如何选取单元格 编辑

Selecting cells

Cells can be selected in a variety of combinations and quantities.

单元格的选取有多种组合与范围

Single cell

Left-click in the cell. The result will look like the left side of Figure 100. You can verify your selection by looking in the Name box.

选取单个单元格

单击(左击)该单元格即可,其结果将使其外观如图100左边所示,然后您可以在名称框里核实您的选取。

Range of contiguous cells

A range of cells can be selected using the keyboard or the mouse.

选取连续的单元格区域

连续的单元格区域可以通过键盘或鼠标来完成。

To select a range of cells by dragging the mouse:

  1. Click in a cell.
  2. Press and hold down the left mouse button.
  3. Move the mouse around the screen.
  4. Once the desired block of cells is highlighted, release the left mouse button.

使用鼠标的拖动来选取连续的单元格区域,其步骤如下:

*  第一步:单击一个单元格;
*  第二步:按住鼠标左键不放;
*  第三步:在屏幕上移动鼠标;
*  第四步:当您需要的单元格区域高亮显示时,释放鼠标左键。

To select a range of cells without dragging the mouse:

  1. Click in the cell which is to be one corner of the range of cells.
  2. Move the mouse to the opposite corner of the range of cells.
  3. Hold down the Shift key and click.

使用鼠标与"Shift"相配合来选取连续的单元格区域,其步骤如下:

*  第一步:单击您要选取的单元格区域最边角上的单元格。
*  第二步:移动鼠标到另一个对角上单元格;
*  第三步:按住“Shift”键,然后单击;

To select a range of cells without using the mouse:

  1. Select the cell that will be one of the corners in the range of cells.
  2. While holding down the Shift key, use the cursor arrows to select the rest of the range.

使用键盘来选取连续的单元格区域,其步骤如下:

*  第一步:选中您要选取的单元格区域最边角上的单元格。
*  第二步:同时按住“Shift”,使用方向键来选择或重置单元格区域;

The result of any of these methods looks like the right side of Figure 100.

上述任何一种选取单元格区域的方法其外观如图100所示。

Tip
You can also directly select a range of cells using the Name box. Click into the Name Box as described in “Using a cell reference” on page 111. To select a range of cells, enter the cell reference for the upper left-hand cell, followed by a colon (:), and then the lower right-hand cell reference. For example, to select the range that would go from A3 to C6, you would enter A3:C6.
提示
您还可以直接通过名称框来选取连续的单元格区域。使用上节“操作电子表格文件/使用单元格引用”所述方法,

单击进入名称框。若要选择连续的单元格区域,请先输入该区域左上的单元格引用,再接上“:”然后再输入该区域右下角的引用。例如,要选择A3至C6之间的单元格区域,请输入“A3:C6”

Range of non-contiguous cells

  1. Select the cell or range of cells using one of the methods above.
  2. Move the mouse pointer to the start of the next range or single cell.
  3. Hold down the Control key and click or click-and-drag to select a range.
  4. Repeat as necessary.

选取“不连续的单元格或单元格区域”的方法:

  • 第一步:使用上述任意一种方法选取某个单元格或单元格区域。
  • 第二步:把鼠标移到下一个要选取单元格或单元格区域。
  • 第三步:按住“Ctrl”键不放,然后单击选取下一个要选取的单元格,或拖动选取下一个要选取的单元格区域
  • 第四步:重复上述步骤,直到完成您的所有选取为止。

选取列与行 编辑

Selecting columns and rows Entire columns and rows can be selected very quickly in LibreOffice.

整列与整行的选取在LibreOffice是非常便捷的。

Single column or row

To select a single column, click on the column identifier letter (see Figure 91).

To select a single row, click on the row identifier number.

'选取单行或单列

  • 若要选择单列,请单击列上面的标记字母(见图91)。
  • 若要选择单行,请单击行左端的标记数字。


Multiple columns or rows

选取多列或多行

若要选取连续的多列或多行,步骤如下:

  • 第一步:单击连续的列(行)中的第一列(行)
    第二步:按住“Shift”键不放
    第三步:单击最后一列(行)。

To select multiple columns or rows that are contiguous:

  1. Click on the first column or row in the group.
  2. Hold down the Shift key.
  3. Click the last column or row in the group.

To select multiple columns or rows that are not contiguous:

若要选取不连续的行或列,步骤如下:

  • 第一步:单击第一个要选取的列(行)
    第二步:按住“Ctrl”键不放
    第三步:按住“Ctrl”键,使用鼠标选取其他要选择的列(行)。
  1. Click on the first column or row in the group.
  2. Hold down the Control key.
  3. Click on all of the subsequent columns or rows while holding down the Control key.


Entire sheet

选取整个工作表

要选取整个工作表,请单击“A”列与“1”行组成的小方框。

To select the entire sheet, click on the small box between the A column header and the 1 row header.

[[Image:|thumb|Figure 103. Select All box]]

You can also press Control+A to select the entire sheet.

同样,您可以使用“Ctrl+A”来选取整个工作表。

选择工作表 编辑

Selecting sheets

You can select either one or multiple sheets. It can be advantageous to select multiple sheets at times when you want to make changes to many sheets at once.

根据您的需要,您可以选择单个或一次性选择多个工作表。

Single sheet

Click on the sheet tab for the sheet you want to select. The active sheet becomes white (see Figure 104).

选择单个工作表的方法:只要单击您要选择的工作表标签,该工作表标签立刻变成白色。

Multiple contiguous sheets

选择标签连续的多个工作表

To select multiple contiguous sheets:

  1. Click on the sheet tab for the first desired sheet.
  2. Move the mouse pointer over the sheet tab for the last desired sheet.
  3. Hold down the Shift key and click on the sheet tab.

要选择标签连续的多个工作,步骤如下:

  • 第一步:单击您要选择第一个工作表标签
    第二步:把光标移到最后一个要选择的工作表标签之上。
    第三步:同时按住“Shift”,然后单击最后一个要选择的工作表标签。

这时,在这两个工作表标签之间的所有标签都变成白色,您的任何一种操作都会影响高亮显示的工作表。

All the tabs between these two sheets will turn white. Any actions that you perform will now affect all highlighted sheets.


Multiple non-contiguous sheets

To select multiple non-contiguous sheets:

  1. Click on the sheet tab for the first sheet.
  2. Move the mouse pointer over the second sheet tab.
  3. Hold down the Control key and click on the sheet tab.
  4. Repeat as necessary.

多个不连续的工作表

若要选择多个不连续的工作表,步骤发下:

  • 第一步:单击第一个要选择的工作表标签
    第二步:把光标移到下一个要选择的工作表标签之上
    第三步:同时按住“Ctrl”键,然后单击该标签。
    第四步:重复第二步、第三步多次,直到选择到所有您要的工作表。

The selected tabs will turn white. Any actions that you perform will now affect all highlighted sheets.

这时,选中的标签都会变成白色,您的任何一种操作都会影响高亮显示的工作表。

All sheets

选择所有的工作表

Right-click any one of the sheet tabs and choose Select All Sheets from the pop-up menu.

在任意一个工作标签上右击鼠标,然后在弹出工作菜单上选择“选择所有的工作表”。

如何操作工作表中的“行与列” 编辑

Working with columns and rows

“行与列”的插入 编辑

Inserting columns and rows

Columns and rows can be inserted individually or in groups.

在工作表中,您可以插入单行(列),或者插入多行(列)。


Note
When you insert a single new column, it is inserted to the left of the highlighted column. When you insert a single new row, it is inserted above the highlighted row.

当您插入新的一列时,该列就会放到高亮显示(即当前选中)列左边。当您插入新的一行时,该行会被插入当前选中(高亮显示)的行上边

Cells in the new columns or rows are formatted like the corresponding cells in the column or row before (or to the left of) which the new column or row is inserted.插入的列和行的格式和相应列和行的单元格一致。

Single column or row

单列或行的插入

Using the Insert menu:

方法一:使用插入 菜单

  1. Select the cell, column or row where you want the new column or row inserted.
  2. Choose either Insert > Columns or Insert > Rows.
  • 第一步:选择你想插入列或行的位置(单元格、列、行等)。
    第二步:从主菜单上,选择 插入 > 列 插入 > 行

Using the mouse:

方法二:使用鼠标

  1. Select the cell, column or row where you want the new column or row inserted.
  2. Right-click the header of the column or row.
  3. Choose Insert Rows or Insert Columns.
  • 第一步:选择你想插入列或行的位置(单元格、列、行等)。
    第二步:在该位置(某行或某列的开头)上,单击鼠标。
    第三步:选择插入行 插入列

Multiple columns or rows

“多列或多行”的插入

Multiple columns or rows can be inserted at once rather than inserting them one at a time.

您可以一次性插入多行(列)到工作表,不需要一次一个地操作。

  1. Highlight the required number of columns or rows by holding down the left mouse button on the first one and then dragging across the required number of identifiers.
  2. Proceed as for inserting a single column or row above. The specified number of rows/columns will be inserted above or to the left of the first one you selected.
  • 第一步:在要选择的首行(列)上按住鼠标不放,然后拖动框选到所有需要的行(列),当选中后,它们都会高亮显示。
    第二步:使用上节有关“插入单行(列)”操作来完成插入,这时选定的行(列)就会插入到当前选中行的上边(列的左边)。

“行与列”的删除 编辑

Deleting columns and rows

Columns and rows can be deleted individually or in groups. 您可以删除单行或单列,多行或多列。

Single column or row

单行或单列的删除

A single column or row can only be deleted by using the mouse:

单行(列)的删除只能通过鼠标完成,步骤如下:

  1. Select the column or row to be deleted.
  2. Right-click on the column or row header.
  3. Select Delete Columns or Delete Rows from the pop-up menu.
  • 第一步:用鼠标选择行径需要删除的行(列)。
    第二步:在该行(列)标题上右击鼠标
    第三步:在弹出的菜单上选择删除列删除行

Multiple columns or rows

多行或多列的删除

Multiple columns or rows can be deleted at once rather than deleting them one at a time.

多行或多列的删除可以一次性地完成,不需要一行或一列地删除。

  1. Highlight the required number of columns or rows by holding down the left mouse button on the first one and then dragging across the required number of identifiers.
  2. Proceed as for deleting a single column or row above.
第一步:在要删除的行(或列)上按住鼠标左键不放,向下(列是向右)拖动选择需要删除的行(或列),这时这些行(或列)就会高亮显示。
第二步:接下来的操作就如上节所述有关“删除单行或单列”。

工作表的操作 编辑

Working with sheets

Like any other Calc element, sheets can be inserted, copied, moved, deleted, and renamed.

如同Calc其他组件一样,工作表可以进行插入,复制,移动,删除和重命名等操作。

插入新的工作表 编辑

Inserting new sheets

There are several ways to insert a new sheet. The fastest method is to click on the Add Sheet button [[Image:]] to the right of the sheet tabs. If you cannot see this button, drag the separator bar next to the tabs towards the right to make space for it. This button inserts one new sheet at that point, without opening the Insert Sheet dialog.

有几种方法插入工作表。最快的方法:点击在工作表标号右边的“添加按钮

 
Add Sheet button

。如果你不能看见这个按钮,向右拖动分隔条提供空间让其显示。这个按钮每点一次新建一个工作表,而不用打开插入工作表对话框。

Use one of the other methods to insert more than one sheet, to rename the sheet at the same time, or to insert the sheet somewhere else in the sequence. The first step for these methods is to select the sheet that the new sheet will be inserted next to. Then use any of the following options.

有很多种方法插入多个工作表,或者同时重命名工作表,又或者把工作表插入工作表序列的其他地方。这些方法的第一步便是选中要插入工作表的位置,然后使用下面的任意一种方法。

  • Choose Insert > Sheet from the menu bar.
  • Right-click on a sheet tab and choose Insert Sheet.
  • Click in an empty space at the end of the line of sheet tabs.
  1. 从菜单栏上选择插入 > 工作表
  2. 在工作表标号上右击然后选择插入工作表
  3. 在工作表标签末尾空白处点击鼠标。
[[Image:|thumb|Figure 104. Creating a new sheet]]

Each method will open the Insert Sheet dialog (Figure 105). Here you can select whether the new sheet is to go before or after the selected sheet and how many sheets you want to insert. If you are inserting only one sheet, there is the opportunity to give the sheet a name.

每一种方法都会打开插入工作表对话框(图105)。在对话框里,您可以选择新工作表是在当前工作表之后,或者在当前工作之前;也可以输入您要插入的工作表数量。若您仅插入单个工作表,还可以对它命名。

[[Image:|thumb|Figure 105. Insert Sheet dialog]]

移动和复制工作表 编辑

Moving and copying sheets

You can move or copy sheets within the same spreadsheet by using either the mouse (drag and drop) or a dialog. Drag and drop does not work if you wish to move or copy a sheet to a different spreadsheet; instead, you need to use the dialog.

在同一个电子表格文档中,您可以使用鼠标(拖动然后停靠),或者通过对话框。若您想把工作表移动或复制到另一个电子表格文档去,那么您必须通过对话框。

办法一:通过鼠标操作工作表 编辑

Using the mouse

To move a sheet to a different position within the same spreadsheet, click on the sheet tab and drag it left or right. Two little triangles indicate where the sheet will be dropped (see Figure 106). The mouse pointer (not shown in the illustration) may change to include an indicator; the indicator symbol varies with your operating system.

在同一个电子表格文档中,若要把移动某个工作表到另一个位置去,单击该工作表标签,然后按住鼠标左键不放,拖到左边或右边。这时会有两个小的箭头状指示器,

[[Image:|thumb|Figure 106: Dragging a sheet to move it]]

To copy a sheet within the same spreadsheet, hold down the Control key (Option key on Mac) while you click on the sheet tab and drag it. The mouse pointer may change to include a plus sign or other indicator; the symbol varies with your operating system.

办法二:使用对话框 编辑

Using a dialog

The Move/Copy dialog provides the opportunity to specify exactly where you want the sheet to go (in the same or a different document, and what its name will be, at the same time as moving or copying occurs.

“移动或复制工作表”对话框里提供了“移动或复制工作表“到指定位置的选项,包括当前文档或另一个文档,以及”移动或复制“后该工作表的名称。

Note
When moving or copying sheets between different spreadsheets, be sure that both documents are open.
注意
在两个不同的文档之间进行“移动或复制”工作表操作时,必须确保两个文档都已经打开。

Follow these steps:

其步骤如下:

  • 第一步:在当前文档下,找到您要“移动或复制”的工作表的标签,右击鼠标。
  • 第二步:从弹出的下列式菜单中,选择“移动或复制工作表”,打开“移动或复制工作表”对话框。
  • 第三步:在“移动或复制工作表”对话框中,
    • 选择您想要的操作:复制 : 或 移动
    • “加入文档”选项:可以选择您要放置文档的位置,默认为当前文档,如果您打开了另一个电子表格文档,那么它的文件名就会出现在

下拉列表,末尾处接着“-新文档-”。

    • 前置于选项:选定在目标文档中放置的位置。
    • 新名称选项:您可以为要“复制”或“移动”的工作表指定另一个名称。若您不输入一个名称,Calc会自动为其命名。
  • 第四步:以上选项填好后,单击“确定”即可。
  1. In the current document, right-click on the sheet tab you wish to move or copy.
  2. Select Move/Copy Sheet from the context menu.
  3. On the Move/Copy Sheet dialog (Figure 107):
  • Select the action: Move or Copy.
  • To document: select the document in which you want to place the sheet. By default, the field will show the current document. If you have another spreadsheet open, its name will appear in the drop-down list along with -new document-.
  • Insert before: select the position within the target document.
  • New name: you can rename the sheet you are moving or assign a different name to the copied sheet. If you do not enter a name for a copied sheet, Calc creates a name.
  1. When you are done, click OK.


Caution
[[Image:]]
If you choose -new document- as the location, a new spreadsheet will be created. This may cause conflicts with formulas linked to other sheets in the previous location. If you accidentally move a sheet, you can fix it by moving or copying the sheet back to the original location.

This caution also apply for moving sheets to other existing documents.

注意
[[Image:]]
若您选择“-新文档-”作为目标位置,将会建立一个新电子表格文档。这可能会导致当前文档中,一些链接到其他工作表的公式失效。若您只是碰巧移动了文档,这时您只要把工作表“复制或移动”回原来的文档,就能解决该问题。

特别注意:当您把工作表移动到其他已有文档时,也可能会产生这个问题。

[[Image:|thumb|Figure 107: Move/Copy Sheet dialog]]

如何删除工作表 编辑

Deleting sheets

Sheets can be deleted individually or in groups.

工作表可以单个地删除,也可以一次性删除多个。

Single sheet

单个工作表删除

在您要删除的工作表的标签上,右击鼠标,再然后从弹出式菜单中选择“删除工作表”,或者从菜单栏上选择“编辑 > 工作表 > 删除”

Right-click on the tab of the sheet you want to delete and choose Delete Sheet from the pop‑up menu, or chose Edit > Sheet > Delete from the menu bar.

Multiple sheets

删除多个工作表

若您要删除多个工作表,如前几节所讲的办法使用鼠标选中它们(连续的工作表加"SHIFT",不连续的工作表加“CTRL”),然后在工作表标签上右击鼠标,然后从弹出式菜单中选择“删除工作”;或者从菜单栏上选择“编辑 > 工作表 > 删除”。

To delete multiple sheets, select them as described earlier, then either right-click over one of the tabs and select Delete Sheet from the pop-up menu, or choose Edit > Sheet > Delete from the menu bar.

如何为工作表重命名 编辑

Renaming sheets

The default name for the a new sheet is SheetX, where X is a number. While this works for a small spreadsheet with only a few sheets, it becomes awkward when there are many sheets.

在Calc,工作表默认的名称为“SheetX”,这里的X是一个数字。这种命名方法仅适用于工作表数量较少时,而当工作表数量太多时就不行了。

若您要为工作取一个有意义的名称,方法如下:

  • 在您建立工作表时,直接在名称框里输入名称,或者使用下列方法;
  • 在工作表标签上右击鼠标,然后从弹出式菜单中选择“重命名工作表”,再在“重命名工作表对话框”中输入您要取的名称。
  • 双击工作表标签弹出“重命名工作表对话框”,再在“重命名工作表对话框”中输入您要取的名称。

To give a sheet a more meaningful name, you can:

  • Enter the name in the Name box when you create the sheet, or
  • Right-click on a sheet tab and choose Rename Sheet from the pop-up menu; replace the existing name with one of your choosing.
  • Double-click on a sheet tab to pop up the Rename Sheet dialog.


Note
Sheet names must start with either a letter or a number. Apart from the first character of the sheet name, allowed characters are letters, numbers, spaces, and the underline character. Attempting to rename a sheet with an invalid name will produce an error message.
注意
工作表名称必须以字母或数字、下划线开头。为工作表指定一个非法的名称可能会产生未知错误。

Calc的数据查看功能 编辑

Viewing Calc

缩放功能的使用 编辑

Using zoom

Use the zoom function to change the view to show more or fewer cells in the window. For more about zoom, see Chapter 1, Introducing LibreOffice, in this book.

缩放功能用于改变窗口中表格视图缩放比率,显示更多或更少单元格。更多有关缩放功能的简介,详细请参考第1章-LibreOffice简介。

如何冻结行和列 编辑

Freezing rows and columns

Freezing locks a number of rows at the top of a spreadsheet or a number of columns on the left of a spreadsheet or both. Then when scrolling around within the sheet, any frozen columns and rows remain in view.

冻结电子表格中某些行或者列,或两者都冻结。然后在工作中滚动表格,被冻结的行或列总是能显示。

Figure 108 shows some frozen rows and columns. The heavier horizontal line between rows 3 and 14 and the heavier vertical line between columns C and H denote the frozen areas. Rows 4 through 13 and columns D through G have been scrolled off the page. The first three rows and columns remained because are frozen into place. 图108显示了冻结的行和列。在3和14行中比较粗的水平线及C和H中比较粗的垂直线组成了冻结区域。行4到行13和列D到列G

[[Image:|thumb|
Figure 108. Frozen rows and columns]]

You can set the freeze point at a row, a column, or both a row and a column as in Figure 108.

你可以设置要冻结的某一行或者一列,或者两者都冻结,就像图108所示.

Freezing single rows or columns

如何冻结行或列

  • 第一步:单击您要冻结的行标题下方的单元格或列标题右侧的单元格。
  • 第二步:从菜单栏上选择“窗口 > 冻结窗口”。被冻结之的单元格区域将会有一条黑线显示。
  1. Click on the header for the row below where you want the freeze or for the column to the right of where you want the freeze.
  2. Choose Window > Freeze. A dark line appears, indicating where the freeze is put.

Freezing a row and a column

如何同时冻结行与列

  1. Click into the cell that is immediately below the row you want frozen and immediately to the right of the column you want frozen.
  2. Choose Window > Freeze. Two lines appear on the screen, a horizontal line above this cell and a vertical line to the left of this cell. Now as you scroll around the screen, everything above and to the left of these lines will remain in view.

點擊欲固定之欄位下方的儲存格及列位右方的儲存格

  • 第一步:单击您要冻结的行正下方及列右方的单元格;
  • 第二步:从菜单栏上选择“窗口 > 冻结窗口”。这时屏幕画面将会出现两条黑线,水平的线位于该单元格的上方,垂直的线位于该单元格的左侧。现在只要您拉动滚动条(水平与垂直均可),位于这两条线的上方与左侧的单元格区域将会继续显示在画面中。

Unfreezing

如何解除冻结

若您要解除列或行的冻结,从菜单栏上选择“窗口 > 冻结窗口”,取消钩选“冻结窗口”即可。

To unfreeze rows or columns, choose Window > Freeze. The check mark by Freeze will vanish.

拆分窗口功能 编辑

Splitting the screen

Another way to change the view is by splitting the window, also known as splitting the screen. The screen can be split either horizontally or vertically or both. You can therefore have up to four portions of the spreadsheet in view at any one time.

另一种改变视图的方法是拆分窗口,也被称为拆分画面。Calc窗口的画面可以被水平拆分或垂直拆分,或者二者结合使用,最多同时有四个显示区域在同一画面上。

Why would you want to do this? Imagine you have a large spreadsheet and one of the cells has a number in it which is used by three formulas in other cells. Using the split screen technique, you can position the cell containing the number in one section and each of the cells with formulas in the other sections. Then you can change the number in the cell and watch how it affects each of the formulas.

您什么时候要用这个功能呢?当电子表格数据很庞大,而其中的单元格的函数又引用了来自于三个不同位置的单元格,这时可技巧性地选择使用频率最高的区域来拆分,然后您可以在修改引用位置单元格内容后,马上看到函数(公式)的值。

[[Image:|thumb|Figure 109. Split screen example]]

如何水平拆分Calc窗口(画面) 编辑

Splitting the screen horizontally

To split the screen horizontally:

若您要水平拆分Calc窗口(画面),具体步骤如下:

  1. Move the mouse pointer into the vertical scroll bar, on the right-hand side of the screen, and place it over the small button at the top with the black triangle. Immediately above this button you will see a thick black line.
  • 第一步:把鼠标光标移到窗口(画面)右边的垂直滚动条上,然后把光标放到顶部的黑色小三角形(箭头状)按钮上方。
  • 第二步:当鼠标移到垂直滚动条上方的黑线时,将会变成有上下黑色双箭头的光标。
[[Image:|thumb|
Figure 110. Split screen bar on vertical scroll bar]]
  • 第三步:按住鼠标左键不放,向下拖动时,便会出现灰色的线横穿整个窗口(画面)。向下拖动鼠标时,这条线也会跟着向下动。
  • 第四步:翻译鼠标左键时,窗口(画面)便拆分为两个视图,每个视图都含有垂直滚动条,这两个滚动条的滚动是互相独立的。
  1. Move the mouse pointer over this line and it turns into a line with two arrows.
[[Image:|thumb|
Figure 111. Split screen bar on vertical scroll bar with cursor]]
  1. Hold down the left mouse button. A gray line appears, running across the page. Drag the mouse downwards and this line follows.
  2. Release the mouse button and the screen splits into two views, each with its own vertical scroll bar. You can scroll the upper and lower parts independently.

Notice in Figure 109, the Beta and the A0 values are in the upper part of the window and other calculations are in the lower part. Thus you can make changes to the Beta and A0 values and watch their affects on the calculations in the lower half of the window.


Tip
You can also split the screen using a menu command. Click in a cell immediately below and to the right of where you wish the screen to be split, and choose Window > Split.
提示
您也可以通过菜单命令来拆分窗口(画面)。在您要拆分的窗口(画面)的下方及右边的单元格,单击鼠标然后选择窗口 > 拆分窗口

如何垂直拆分窗口画面 编辑

Splitting the screen vertically

To split the screen vertically:

若您要垂直拆分窗口画面,步骤如下:

  • 第一步:移动鼠标光标到窗口底部的水平滚动条上,然后把光标放到最右边的黑色三角形状的箭头上,这里光标将变为左右的黑色双箭头线。
  • 第二步:按住鼠标左键不放,拖动时便会出现一条灰色纵向贯穿窗口画面,向左拖动鼠标时,这条线也跟着动。(如图112所示)
  • 第三步:释放鼠标,然后窗口画面便拆分为两个视图,每个视图都有水平滚动条,这两个滚动条是独立。
  1. Move the mouse pointer into the horizontal scroll bar at the bottom of the screen and place it over the small button on the right with the black triangle. Immediately to the right of this button is a thick black line.
[[Image:|thumb|Figure 112: Split bar on horizontal scroll bar]]
  1. Move the mouse pointer over this line and it turns into a line with two arrows.
  2. Hold down the left mouse button, and a gray line appears, running up the page. Drag the mouse to the left and this line follows.
  3. Release the mouse button and the screen is split into two views, each with its own horizontal scroll bar. You can scroll the left and right parts of the window independently.

如何移除拆分视图 编辑

Removing split views

To remove a split view, do any of the following:

下列任意一种方法均可移除拆分视图:

  • 双击分割线。
  • 单击分割线,然后把它们移到它们所处的滚动条的末端。
  • 选择菜单命令“窗口 > 拆分”,可以一次性地移除所有的分割线。


  • Double-click on each split line.
  • Click on and drag the split lines back to their places at the ends of the scroll bars.
  • Choose Window > Split to remove all split lines at the same time.

如何使用键盘录入数据到Calc工作表 编辑

Entering data using the keyboard Most data entry in Calc can be accomplished using the keyboard.

在Calc工作表中,大部分数据都是由键盘录入 。

如何输入数值 编辑

Entering numbers

Click in the cell and type in the number using the number keys on either the main keyboard or the numeric keypad.

单击您要输入数值的单元格,然后使用主键盘或数字键上的数字键输入数值。

To enter a negative number, either type a minus (–) sign in front of it or enclose it in parentheses (brackets), like this: (1234).

若要输入一个负数,在数值前面加上符号“-”,或者用()框住数值,如(1234)

By default, numbers are right-aligned and negative numbers have a leading minus symbol.

在单元格中,数值型数据默认为右对齐,而负数前面会有一个符号“-”。

Note
If a number beginning with 0 is entered in to a cell, Calc will drop the 0 (for example 01234 becomes 1234).


如果输入单元格的数字是以“0”开始,Calc将会丢弃这个“0”,如输入"01234",将会变成"1234".

To enter a number and retain the leading 0, right-click on the cell and choose Format Cells > Numbers. In the Format Cells dialog, under Options select the required number of Leading zeros.

若您要输入数字且保留前导零,在单元格上右击鼠标,然后从弹出式菜单中选择“单元格格式 > 数字”。在单元格格式对话框里, ”数字选项页”下,在一个“前导零”选项。

“前导零”的个数需要比单元格的数字位数多一。如如果输入数字为1234,那么前导零个数就要为5。

The number selected for leading zeros needs to be one higher than the digits in a number. For example, if the number is 1234, the number entered for the leading zero will be 5.

[[Image:|thumb|Figure 113: Adjusting leading zeros]]

文本的输入 编辑

Entering text

Click in the cell and type the text. Text is left-aligned by default.

单击单元格,然后输入文本,文本的默认为左对齐。

如何把“数值”以文本格式输入? 编辑

Entering numbers as text

A number can be entered as text to preserve a leading zero by entering an apostrophe before the number, like this: '01481.

若以数字格式輸入 01481,Calc将会忽略开头的0;若要输入电话号码等以0开头的数字串时,可在开头加上单引号'(英文状态下的),例如:‘01481,这便可以将此数字串改为文本格式,在Calc中就可以正常显示为 “01481”。通常,此数字串在公式可运算(被当作是0),但在函数中会被忽略,无法计算。

The data is now regarded as text by Calc and displayed exactly as entered. Typically, formulas will treat the entry as a zero and functions will ignore it. Take care that the cell containing the number is not used in a formula.


Note
If “smart quotes” are used for apostrophes, the apostrophe remains visible in the cell.

To choose the type of apostrophe, use Tools > AutoCorrect > Custom Quotes. The selection of the apostrophe type affects both Calc and Writer.


注意
If “smart quotes” are used for apostrophes, the apostrophe remains visible in the cell.

To choose the type of apostrophe, use Tools > AutoCorrect > Custom Quotes. The selection of the apostrophe type affects both Calc and Writer.

Entering dates and times 输入日期和时间 Select the cell and type the date or time. You can separate the date elements with a slant (/) or a hyphen (–) or use text such as 15 Oct 10. Calc recognizes a variety of date formats. You can separate time elements with colons such as 10:43:45. 选择单元格输入数据和时间,可以用斜线(/)和连字符(-)来区分它和数据,或者用文本,比如15 Oct 10。Calc能识别多种日期格式,你也可以用冒号形式来表示时间,如10:43:45。

Deactivating automatic changes 编辑

Calc automatically applies many changes during data input, unless you deactivate those changes. You can also immediately undo any automatic changes with Ctrl+Z.

AutoCorrect changes

Automatic correction of typing errors, replacement of straight quotation marks by curly (custom) quotes, and starting cell content with an uppercase (capital letter) are controlled by Tools > AutoCorrect Options. Go to the Custom Quotes, Options, or Replace tabs to deactivate any of the features that you do not want. On the Replace tab, you can also delete unwanted word pairs and add new ones as required.

AutoInput

When you are typing in a cell, Calc automatically suggests matching input found in the same column. To turn the AutoInput on and off, set or remove the check mark in front of Tools > Cell Contents > AutoInput.

Automatic date conversion

Calc automatically converts certain entries to dates. To ensure that an entry that looks like a date is interpreted as text, type an apostrophe at the beginning of the entry. The apostrophe is not displayed in the cell.

Speeding up data entry 编辑

加速数据的输入 编辑

Entering data into a spreadsheet can be very labor-intensive, but Calc provides several tools for removing some of the drudgery from input. 把数据输入到电子表格是一项很繁琐且劳动量很大的工作,但是calc提供了几个可以使你轻松搞定数据的工具。 The most basic ability is to drag and drop the contents of one cell to another with a mouse. Calc also includes several other tools for automating input, especially of repetitive material. They include the Fill tool, selection lists, and the ability to input information into multiple sheets of the same document. 最基本的操作是用鼠标将一个单元格中的内容拖放到另一个单元。calc也有一些填充工具,选项列表,向同一文档中不同表格中输入相同信息的工具,特别是重复的数据。

Using the Fill tool on cells 编辑

在单元格中使用填充工具 编辑

At its simplest, the Fill tool is a way to duplicate existing content. Start by selecting the cell to copy, then drag the mouse in any direction (or hold down the Shift key and click in the last cell you want to fill), and then choose Edit > Fill and the direction in which you want to copy: Up, Down, Left or Right. 简而言之,填充工具就是重复复制已有的内容。首先选择你要复制的单元格,然后用鼠标拖向各个方向(或者按下shift键然后单击你要填充的最后一个单元格)然后选择编辑>填充以及选择你要复制的方向:上,下,左,右。

Caution
[[Image:]]
Choices that are not available are grayed out, but you can still choose the opposite direction from what you intend, which could cause you to overwrite cells accidentally.
Tip
A shortcut way to fill cells is to grab the “handle” in the lower right-hand corner of the cell and drag it in the direction you want to fill. If the cell contains a number, the number will fill in series. If the cell contains text, the same text will fill in the direction you chose.
[[Image:|thumb|Figure 114: Using the Fill tool]]

Using a fill series 编辑

[[Image:|thumb|Figure 115: Result of fill series selection shown in Figure 116]]

A more complex use of the Fill tool is to use a fill series. The default lists are for the full and abbreviated days of the week and the months of the year, but you can create your own lists as well.

To add a fill series to a spreadsheet, select the cells to fill, choose Edit > Fill > Series. In the Fill Series dialog (Figure 116), select AutoFill as the Series type, and enter as the Start value an item from any defined series. The selected cells then fill in the other items on the list sequentially, repeating from the top of the list when they reach the end of the list.

[[Image:|thumb|Figure 116: Specifying the start of a fill series (result is in Figure 115)]]

You can also use Edit > Fill > Series to create a one-time fill series for numbers by entering the start and end values and the increment. For example, if you entered start and end values of 1 and 7 with an increment of 2, you would get the sequence of 1, 3, 5, 7.

In all these cases, the Fill tool creates only a momentary connection between the cells. Once they are filled, the cells have no further connection with one another.

Defining a fill series 编辑

To define your own fill series:

  1. Go to Tools > Options > LibreOffice Calc > Sort Lists. This dialog shows the previously-defined series in the Lists box on the left, and the contents of the highlighted list in the Entries box.
[[Image:|thumb|Figure 117: Predefined fill series]]
  1. Click New. The Entries box is cleared.
  2. Type the series for the new list in the Entries box (one entry per line). Click Add. The new list will now appear in the Lists box.
  3. Click OK at the bottom of the dialog to save the new list.
[[Image:|thumb|Figure 118: Defining a new fill series]]

Using selection lists 编辑

Selection lists are available only for text, and are limited to using only text that has already been entered in the same column.

To use a selection list, select a blank cell and press Ctrl+D. A drop-down list appears of any cell in the same column that either has at least one text character or whose format is defined as Text. Click on the entry you require.

[[Image:|thumb|
Figure 119: Using a selection list
]]

Sharing content between sheets 编辑

You might want to enter the same information in the same cell on multiple sheets, for example to set up standard listings for a group of individuals or organizations. Instead of entering the list on each sheet individually, you can enter it in all the sheets at once. To do this, select all the sheets (Edit > Sheet > Select), then enter the information in the current one.


Caution
[[Image:]]
This technique overwrites any information that is already in the cells on the other sheets—without any warning. For this reason, when you are finished, be sure to deselect all the sheets except the one you want to edit. (Ctrl+click on a sheet tab to select or deselect the sheet.)

Validating cell contents 编辑

When creating spreadsheets for other people to use, you may want to make sure they enter data that is valid or appropriate for the cell. You can also use validation in your own work as a guide to entering data that is either complex or rarely used.

Fill series and selection lists can handle some types of data, but they are limited to predefined information. To validate new data entered by a user, select a cell and use Data > Validity to define the type of contents that can be entered in that cell. For example, a cell might require a date or a whole number, with no alphabetic characters or decimal points; or a cell may not be left empty.

Depending on how validation is set up, the tool can also define the range of contents that can be entered and provide help messages that explain the content rules you have set up for the cell and what users should do when they enter invalid content. You can also set the cell to refuse invalid content, accept it with a warning, or start a macro when an error is entered.

See Chapter 2, Entering, Editing and Formatting Data, in the Calc Guide for more information.

Editing data 编辑

Editing data is done in much the same way as entering data. The first step is to select the cell containing the data to be edited.

Removing data from a cell 编辑

Data can be removed (deleted) from a cell in several ways.

Removing data only

The data alone can be removed from a cell without removing any of the formatting of the cell. Click in the cell to select it, and then press the Delete key.

Removing data and formatting

The data and the formatting can be removed from a cell at the same time. Press the Backspace key (or right-click and choose Delete Contents, or use Edit > Delete Contents) to open the Delete Contents dialog. From this dialog, the different aspects of the cell can be deleted. To delete everything in a cell (contents and format), check Delete all.

[[Image:|thumb|Figure 120: Delete Contents dialog]]

Replacing all the data in a cell 编辑

To remove data and insert new data, simply type over the old data. The new data will retain the original formatting.

Changing part of the data in a cell 编辑

Sometimes it is necessary to change the contents of cell without removing all of the contents, for example if the phrase “Sales in Qtr. 2” is in a cell and it needs to be changed to “Sales rose in Qtr. 2” It is often useful to do this without deleting the old cell contents first.

The process is the similar to the one described above, but you need to place the cursor inside the cell. You can do this in two ways.

Using the keyboard

After selecting the appropriate cell, press the F2 key and the cursor is placed at the end of the cell. Then use the keyboard arrow keys to move the cursor through the text in the cell.

Using the mouse

Using the mouse, either double-click on the appropriate cell (to select it and place the cursor in it for editing), or single-click to select the cell and then move the mouse pointer up to the input line and click into it to place the cursor for editing.

Formatting data 编辑

The data in Calc can be formatted in several ways. It can either be edited as part of a cell style so that it is automatically applied, or it can be applied manually to the cell. Some manual formatting can be applied using toolbar icons. For more control and extra options, select the appropriate cell or cells, right-click on it, and select Format Cells. All of the format options are discussed below.


Note
All the settings discussed in this section can also be set as a part of the cell style. See Chapter 4 in the Calc Guide for more information.

Formatting multiple lines of text 编辑

Multiple lines of text can be entered into a single cell using automatic wrapping or manual line breaks. Each method is useful for different situations.

Using automatic wrapping 编辑

To set text to wrap at the end of the cell, right-click on the cell and select Format Cells (or choose Format > Cells from the menu bar, or press Ctrl+1). On the Alignment tab (Figure 121), under Properties, select Wrap text automatically and click OK. The results are shown in Figure 122.

[[Image:|thumb|Figure 121: Format Cells > Alignment dialog]]
[[Image:|thumb|Figure 122: Automatic text wrap]]

Using manual line breaks 编辑

To insert a manual line break while typing in a cell, press Ctrl+Enter. This method does not work with the cursor in the input line. When editing text, first double-click the cell, then single-click at the position where you want the line break.

When a manual line break is entered, the cell width does not change. Figure 123 shows the results of using two manual line breaks after the first line of text.

[[Image:|thumb|Figure 123: Cell with manual line breaks]]

Shrinking text to fit the cell 编辑

The font size of the data in a cell can automatically adjust to fit in a cell. To do this, select the Shrink to fit cell size option in the Format Cells dialog (Figure 121). Figure 124 shows the results.

[[Image:|thumb|Figure 124: Shrinking font size to fit cells]]

Formatting numbers 编辑

Several different number formats can be applied to cells by using icons on the Formatting toolbar. Select the cell, then click the relevant icon.

[[Image:|thumb|
Figure 125: Number format icons. Left to right: currency, percentage, date, exponential, standard, add decimal place, delete decimal place.]]

For more control or to select other number formats, use the Numbers tab (Figure 126) of the Format Cells dialog:

  • Apply any of the data types in the Category list to the data.
  • Control the number of decimal places and leading zeros.
  • Enter a custom format code.

The Language setting controls the local settings for the different formats such as the date order and the currency marker.

[[Image:|thumb|Figure 126: Format Cells > Numbers]]

Formatting the font 编辑

To quickly choose the font used in a cell, select the cell, then click the arrow next to the Font Name box on the Formatting toolbar and choose a font from the list.


Tip
To choose whether to show the font names in their font or in plain text, go to Tools > Options > LibreOffice > View and select or deselect the Show preview of fonts option in the Font Lists section. For more information, see Chapter 2, Setting Up LibreOffice.

[[Image:]]To choose the size of the font, click the arrow next to the Font Size box on the Formatting toolbar. For other formatting, you can use the Bold, Italic, or Underline icons.

To choose a font color, click the arrow next to the Font Color icon to display the color palette. Click on the desired color.

(To define custom colors, use Tools > Options > LibreOffice > Colors. See Chapter 2.)

To specify the language of the cell (useful because it allows different languages to exist in the same document and be spell checked correctly), use the Font tab of the Format Cells dialog. Use the Font Effects tab to set other font characteristics. See Chapter 4, Using Styles and Templates in Calc, of the Calc Guide for more information.

Formatting the cell borders 编辑

To add a border to a cell (or group of selected cells), click on the Borders icon on the formatting toolbar, and select one of the border options displayed in the palette.

To quickly choose a line style and color for the borders of a cell, click the small arrows next to the Line Style and Line Color icons on the Formatting toolbar. In each case, a palette of choices is displayed.

For more controls, including the spacing between the cell borders and the text, use the Borders tab of the Format Cells dialog. There you can also define a shadow. See Chapter 4, Using Styles and Templates in Calc, of the Calc Guide for details.


Note
The cell border properties apply to a cell, and can only be changed if you are editing that cell. For example, if cell C3 has a top border (which would be equivalent visually to a bottom border on C2), that border can only be removed by selecting C3. It cannot be removed in C2.

Formatting the cell background 编辑

To quickly choose a background color for a cell, click the small arrow next to the Background Color icon on the Formatting toolbar. A palette of color choices, similar to the Font Color palette, is displayed.

(To define custom colors, use Tools > Options > LibreOffice > Colors. See Chapter 2 for more information.)

You can also use the Background tab of the Format Cells dialog. See Chapter 4, Using Styles and Templates in Calc, of the Calc Guide for details.

Autoformatting cells and sheets 编辑

You can use the AutoFormat feature to quickly apply a set of cell formats to a sheet or a selected cell range.

  1. Select the cells, including the column and row headers, that you want to format.
  2. Choose Format > AutoFormat.


Note
The AutoFormat feature can only be applied if the selected set of cells contains at least 3 columns and 3 rows and also includes the column and row headers.
  1. To select which properties (number format, font, alignment, borders, pattern, autofit width and height) to include in an AutoFormat, click More. Select or deselect the required options.
  2. Click OK.

If you do not see any change in color of the cell contents, choose View > Value Highlighting from the menu bar.

[[Image:|thumb|Figure 127: Choosing an AutoFormat]]

Defining a new AutoFormat 编辑

You can define a new AutoFormat that is available to all spreadsheets.

  1. Format a sheet (in the style for the new AutoFormat).
  2. Choose Edit > Select All.
  3. Choose Format > AutoFormat. The Add button is now active.
  4. Click Add.
  5. In the Name box of the Add AutoFormat dialog, type a meaningful name for the new format.
  6. Click OK to save. The new format is now available in the Format list in the AutoFormat dialog.

Formatting spreadsheets using themes 编辑

Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets.

It is not possible to add themes to Calc, and they cannot be modified. However, you can modify their styles after you apply them to a spreadsheet.

To apply a theme to a spreadsheet:

  1. Click the Choose Themes icon in the Tools toolbar. If this toolbar is not visible, you can show it using View > Toolbars > Tools.

The Theme Selection dialog appears. This dialog lists the available themes for the whole spreadsheet.

[[Image:]]
  1. In the Theme Selection dialog, select the theme that you want to apply to the spreadsheet.

As soon as you select a theme, some of the properties of the custom styles are applied to the open spreadsheet and are immediately visible.

  1. Click OK. If you wish, you can now go to the Styles and Formatting window to modify specific styles. These modifications do not change the theme; they only change the appearance of this specific spreadsheet document.

Using conditional formatting 编辑

You can set up cell formats to change depending on conditions that you specify. For example, in a table of numbers, you can show all the values above the average in green and all those below the average in red.

Conditional formatting depends upon the use of styles, and the AutoCalculate feature (Tools > Cell Contents > AutoCalculate) must be enabled. See Chapter 2, Entering, Editing, and Formatting Data, in the Calc Guide for details.

Hiding and showing data 编辑

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.

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).

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.

[[Image:|thumb|Figure 128: Hiding or showing cells]]

Outline group controls 编辑

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.

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.

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 on screen use, and do not print.

[[Image:|thumb|Figure 129: Outline group controls]]

The basic outline controls have plus or minus signs at the start of the group to show or hide hidden cells. However, if outline groups are nested, the controls have numbered buttons for hiding different levels.

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.

Filtering which cells are visible 编辑

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.

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 are useful with text and with numbers, because the list includes every unique entry in the selected cells.

In addition to these unique entries, 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. The automatic filters are somewhat limited. In particular, they do not allow regular expressions, so you cannot use them to display cell contents that are similar, but not identical.

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.

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.

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.

Sorting records 编辑

Sorting arranges the visible cells on the sheet. In Calc, you can sort by up to three criteria, which are applied one after another. Sorts are handy when you are searching for a particular item, and become even more powerful after you have filtered data.

In addition, sorting is often useful when you add new information. When a list is long, it is usually easier to add new information at the bottom of the sheet, rather than adding rows in the proper places. After you have added information, you can then sort it to update the sheet.

Highlight the cells to be sorted, then select Data > Sort to open the Sort dialog (or click the Sort Ascending or Sort Descending toolbar buttons). Using the dialog, you can sort the selected cells using up to three columns, in either ascending (A-Z, 1-9) or descending (Z-A, 9-1) order.

On the Options tab of the Sort dialog, you can choose the following options:

Case sensitive

If two entries are otherwise identical, one with an upper case letter is placed before one with a lower case letter in the same position.

Range contains column labels

Does not include the column heading in the sort.

Include formats

A cell's formatting is moved with its contents. If formatting is used to distinguish different types of cells, then use this option.

Copy sort results to

Sets a spreadsheet address to which to copy the sort results. If a range is specified that does not have the necessary number of cells, then cells are added. If a range contains cells that already have content, then the sort fails.

Custom sort order

Select the box, then choose one of the sort orders defined in Tools > Options > Spreadsheet > Sort Lists from the drop-down list.

Direction

Sets whether rows or columns are sorted. The default is to sort by columns unless the selected cells are in a single column.

Using formulas and functions 编辑

You may need more than numbers and text on your spreadsheet. Often the contents of one cell depend on the contents of other cells. Formulas are equations using numbers and variables to get a result. The variables are cell locations that hold the data you need for the equation.

A function is a predefined calculation entered in a cell to help you analyze or manipulate data. All you have to do is add the arguments, and the calculation is automatically made for you. Functions help you create the formulas needed to get the results that you are looking for.

Refer to Chapter 7 in the Calc Guide for more information.

Analyzing data 编辑

Calc includes several tools to help you analyze the information in your spreadsheets, ranging from features for copying and reusing data, to creating subtotals automatically, to varying information to help you find the answers you need. These tools are divided between the Tools and Data menus.

One of the most useful of these tools is the PivotTable (called DataPilot in Calc 3.3). This is a tool for combining, comparing, and analyzing large amounts of data easily. Using the PivotTable, you can view different summaries of the source data, display the details of areas of interest, and create reports, whether you are a beginner, an intermediate or advanced user. Refer to Chapter 8 in the Calc Guide for more information.

Other analysis options include:

Consolidation

Data > Consolidate provides a way to combine data from two or more ranges of cells into a new range while running one of several functions (such as Sum or Average) on the data.

Subtotals

Use Data > Subtotals to calculate subtotals for up to three columns.

Scenarios

Tools > Scenarios opens a dialog for testing “what-if” questions, such as different interest rates on a loan.

Goal seek

Use Tools > Goal Seek if you know the result you want, but need to discover what values will produce this result.

Solver

Tools > Solver is similar to Goal Seek, but you can use more than one variable. The Solver is designed to minimize or maximize the result according to a set of rules that you define.

All of these options are further discussed in Chapter 9 in the Calc Guide.

Printing 编辑

Printing from Calc is much the same as printing from other LibreOffice components (see Chapter 10), but some details are different, especially regarding preparation for printing.

Using print ranges 编辑

Print ranges have several uses, including printing only a specific part of the data or printing selected rows or columns on every page. For more about using print ranges, see Chapter 6, Printing, Exporting, and E-mailing, in the Calc Guide.

Defining a print range 编辑

To define a new print range or modify an existing print range:

  1. Highlight the range of cells that comprise the print range.
  2. Choose Format > Print Ranges > Define.

The page break lines display on the screen.


Tip
You can check the print range by using File > Page Preview. LibreOffice will only display the cells in the print range.

Adding to the print range 编辑

After defining a print range, you can add more cells to it. This allows multiple, separate areas of the same sheet to be printed, while not printing the whole sheet. After you have defined a print range:

  1. Highlight the range of cells to be added to the print range.
  2. Choose Format > Print Ranges > Add. This adds the extra cells to the print range.

The page break lines no longer display on the screen.


Note
The additional print range will print as a separate page, even if both ranges are on the same sheet.

Removing a print range 编辑

It may become necessary to remove a defined print range, for example if the whole sheet needs to be printed later.

Choose Format > Print Ranges > Remove. This removes all defined print ranges on the sheet. After the print range is removed, the default page break lines will appear on the screen.

Editing a print range 编辑

At any time, you can directly edit the print range, for example to remove or resize part of the print range. Choose Format > Print Ranges > Edit.

Selecting the page order, details, and scale 编辑

To select the page order, details, and scale to be printed:

  1. Choose Format > Page from the main menu.
  2. On the Page Style dialog (Figure 130), select the Sheet tab.
  3. Make your selections, and then click OK.

Page Order

When a sheet will print on more than one page, you can set the order in which pages print. This is especially useful in a large document; for example, controlling the print order can save time if you have to collate the document a certain way. The two available options are shown below.


Top to bottom, then right [[Image:]]
Left to right, then down [[Image:]]
[[Image:|thumb|Figure 130. The Sheet tab of the Page Style dialog]]

Details

You can specify which details to print. These details include:

  • Row and column headers
  • Sheet grid—prints the borders of the cells as a grid
  • Comments—prints the comments defined in your spreadsheet on a separate page, along with the corresponding cell reference
  • Objects and graphics
  • Charts
  • Drawing objects
  • Formulas—prints the formulas contained in the cells, instead of the results
  • Zero Values—prints cells with a zero value


Note
Remember that since the print detail options are a part of the page’s properties, they are also a part of the page style’s properties. Therefore, different page styles can be set up to quickly change the print properties of the sheets in the spreadsheet.

Scale

Use the scale features to control the number of pages the data will print on. This can be useful if a large amount of data needs to be printed compactly or if you want the text enlarged to make it easier to read.

  • Reduce/Enlarge printout—scales the data in the printout either larger or smaller. For example if a sheet would normally print out as four pages (two high and two wide), a scaling of 50% would print as one page (both width and height are halved).
  • Fit print range(s) on number of pages—defines exactly how many pages the printout will take up. This option will only reduce a printout, it will not enlarge it. To enlarge a printout, the reduce/enlarge option must be used.
  • Fit print range(s) to width/height—defines how high and wide the printout will be, in pages.

Printing rows or columns on every page 编辑

If a sheet is printed on multiple pages, you can set up certain rows or columns to repeat on each printed page.

For example, if the top two rows of the sheet as well as column A need to be printed on all pages, do the following:

  1. Choose Format > Print Ranges > Edit. On the Edit Print Ranges dialog, type the rows in the text entry box under Rows to repeat. For example, to repeat rows 1 and 2, type $1:$2. This automatically changes Rows to repeat from, - none - to - user defined -.
[[Image:|thumb|Figure 131: Specifying repeating rows]]
  1. To repeat, type the columns in the text entry box under Columns to repeat. For example, to repeat column A, type $A. In the Columns to repeat list, - none - changes to - user defined -.
  2. Click OK.


Note
You do not need to select the entire range of the rows to be repeated; selecting one cell in each row works.

Page breaks 编辑

While defining a print range can be a powerful tool, it may sometimes be necessary to manually adjust Calc’s printout. To do this, you can use a manual break. A manual break helps to ensure that your data prints properly. You can insert a horizontal page break above, or a vertical page break to the left of, the active cell.

Inserting a page break 编辑

To insert a page break:

  1. Navigate to the cell where the page break will begin.
  2. Select Insert > Manual Break.
  3. Select Row Break or Column Break depending on your need.

The break is now set.

Row break

Selecting Row Break creates a page break above the selected cell. For example, if the active cell is H15, then the break is created between rows 14 and 15.

Column break

Selecting Column Break creates a page break to the left of the selected cell. For example, if the active cell is H15, then the break is created between columns G and H.


Tip
To see page break lines more easily on screen, you can change their color. Choose Tools > Options > LibreOffice > Appearance and scroll down to the Spreadsheet section.

Deleting a page break 编辑

To remove a page break:

  1. Navigate to a cell that is next to the break you want to remove.
  2. Select Edit > Delete Manual Break.
  3. Select Row Break or Column Break depending on your need.

The break is now removed.


Note
Multiple manual row and column breaks can exist on the same page. When you want to remove them, you have to remove each one individually. This may be confusing at times, because although there may be a column break set on the page, when you go to Edit > Manual Break, Column break may be grayed out.

In order to remove the break, you have to be in the cell next to the break. For example, if you set the column break while you are in H15, you can not remove it if you are in cell D15. However, you can remove it from any cell in column H.

Headers and footers 编辑

Headers and footers are predefined pieces of text that are printed at the top or bottom of a sheet outside of the sheet area. Headers are set in the same way as footers.

Headers and footers are assigned to a page style. You can define more than one page style for a spreadsheet and assign different page styles to different sheets. For more about page styles, see Chapter 4, Using Styles and Templates, in the Calc Guide.

Setting a header or footer 编辑

To set a header or footer:

  1. Navigate to the sheet that you want to set the header or footer for. Choose Format > Page.
  2. On the Page Style dialog, select the Header (or Footer) tab. See Figure 132.
  3. Select the Header on option.

From here you can also set the margins, the spacing, and height for the header or footer. You can check the AutoFit height box to automatically adjust the height of the header or footer.

Margin

Changing the size of the left or right margin adjusts how far the header or footer is from the side of the page.

Spacing

Spacing affects how far above or below the sheet the header or footer will print. So, if spacing is set to 1.00", then there will be 1 inch between the header or footer and the sheet.

Height

Height affects how big the header or footer will be.

[[Image:|thumb|Figure 132: Header dialog]]

Header or footer appearance 编辑

To change the appearance of the header or footer, click the More button in the header dialog. This opens the Border/Background dialog (Figure 133).

From this dialog you can set the background and border of the header or footer. For more information see Chapter 4, Using Styles and Templates, in the Calc Guide.

[[Image:|thumb|Figure 133: Header/Footer - Border/Background]]

Setting the contents of the header or footer 编辑

The header or footer of a Calc spreadsheet has three columns for text. Each column can have different contents.

To set the contents of the header or footer, click the Edit button in the header or footer dialog shown in Figure 132 to display the dialog shown in Figure 134.

[[Image:|thumb|Figure 134: Edit contents of header or footer]]

Areas

Each area in the header or footer is independent and can have different information in it.

Header

You can select from several preset choices in the Header drop-down list, or specify a custom header using the buttons below the area boxes. (To format a footer, the choices are the same.)

Custom header

Click in the area (Left, Center, Right) that you want to customize, then use the buttons to add elements or change text attributes.

[[Image:]] Opens the Text Attributes dialog.

[[Image:]] Inserts the total number of pages.

[[Image:]] Inserts the File Name field.

[[Image:]] Inserts the Date field.

[[Image:]] Inserts the Sheet Name field.

[[Image:]] Inserts the Time field.

[[Image:]] Inserts the current page number.