Linux [Electronic resources] نسخه متنی

Editing the Spreadsheet Content

The process of adding and editing spreadsheet content are familiar. Type numbers, text, or formulas into cells; delete cell contents with <Backspace> or <Del>; replace text by highlighting it and typing new text over it. The Edit menu contains familiar items, such as copy, cut, paste, and find and replace. You can insert a row or a column by right-clicking a number or letter. You can insert cells by right-clicking a cell.Chapter 11, in the section "Editing Document Contents."

You can add graphics to a spreadsheet, just as you can to a document. Graphics can be inserted from another file or drawn directly into the spreadsheet using the OpenOffice drawing tools. Graphics in spreadsheets are handled the same as graphics in word processing documents, as described in Chapter 11.

You can create and edit charts in your spreadsheet. Highlight the cells you want to include in the chart. Click Insert. Select Chart. A wizard opens that allows you to select the type of chart (bar chart, pie chart, etc.), labels, and other features and creates the chart. When you select a chart in your spreadsheet, the main toolbar (on the left) changes to provide several buttons that change the appearance of the chart. For more changes, you can double-click any element in the chart to see an element-specific window that allows you to change the borders, colors, fonts, labels, transparency, etc.