![]() Note how the formula bar icons change according to the type of input, displaying Accept and Reject buttons ( ) whenever the input is not a formula. Impress will try to automatically recognize the type of contents (text, number, date, time, and so on) of a cell and apply default formatting to it. Note that the input is also added to the main part of the formula bar where it may be easier to read. To insert data, first select the cell to make it active, then type in it. The cell reference (or coordinates) is also shown on the left hand end of the formula bar. Keyboard input is received by the active cell, identified by a thick black border. Refer to Chapter 5 (Getting Started with Calc) in the Getting Started guide for further information. Other keyboard shortcuts are available to move quickly to certain cells of the spreadsheet. Use the combinations Enter and Shift+Enter to move one cell down or one cell up respectively Tab key and Shift+Tab key to move one cell to the right or to the left respectively.Left-click with the mouse on the desired cell.To move around the spreadsheet and select the cell which has the focus, you can: All data, whether text or numbers, is input in a cell. For example, the top left cell is identified as A1, while the third cell in the second row is C2. They are identified by a row number (shown on the left hand side on gray background) and a column letter (shown in the upper part again on gray background). Cells are the elementary unit of the spreadsheet. Just like in Calc, you can rename a sheet or move it to a different position using the same pop-up menu or the Insert menu on the main menu bar.Įven if you have many sheets in your embedded spreadsheet, only one sheet-the one which is active when leaving the spreadsheet edit mode-is shown on the slide.Įach of the sheets is further organized into cells. Select Insert > Sheet from the pop-up menu.Right-click on the bottom area near the existing tab. ![]() The name of the table is shown at the bottom of the spreadsheet area (see Figure 3). ![]() The default for a spreadsheet embedded in Impress is one single table called Sheet 1. However, in Impress only one of these tables can be shown at any given time on a slide. Moving around the spreadsheet How a spreadsheet is organizedĪ spreadsheet consists normally of multiple tables which in turn contain cells. This is not recommended, because it may distort the fonts and picture shapes. When selected but not in edit mode (green handles), the spreadsheet object is treated like any other object, therefore resizing it results in changing the scale rather than the spreadsheet area.
0 Comments
Leave a Reply. |