Getting the data out of Calc into another format is easy, and you have a lot of options for what format to switch to. Saving One or All Spreadsheets in 5.2 or Excel FormatChoose File > Save As and select the appropriate format from the format dropdown list. It's also a good idea to delete the previous file extension such as . sxc from the file name , and select Automatic File Extension in the dialog box. Then click OK. See also Automatically Saving in StarOffice 5.2 or Microsoft Office Formats on page 163. Saving a Calc Spreadsheet as a Text FileWhen you save a Calc spreadsheet as a delimited text file, only the active sheet in the spreadsheet is saved. To save more than one sheet as a text file, you must repeat this procedure for each sheet.
If you want to open the text file, first close the spreadsheet file you used to create the text file. Otherwise the text file will open in read-only mode. Saving a Spreadsheet in HTML FormatChoose File > Save as and select Web Page (Calc) in the format dropdown list. Delete the . sxc file extension and select Automatic File Extension. Figure 18-25 and Figure 18-26 show an example of a Calc spreadsheet saved in HTML. The Save As feature exports all sheets to the same Web page and creates links at the top so you can easily click to each sheet. Figure 18-25. Original spreadsheet (first of five original sheets) and HTML version
Figure 18-26. Original spreadsheet (second of five original sheets) and HTML version
Sending a Spreadsheet as EmailInstead of launching Mail, creating a new mail message, and attaching a Calc file to it, you can send an open Calc file as an email attachment or as the contents of an email message.
If the document is unsaved, the program displays the Save As window. Save the file. Creating and Maintaining SheetsA Calc file can contain multiple spreadsheets (called sheets), each of which has a tab at the bottom of the Calc window. This helps you keep different financial information separate in a single file. For example, you can set up a sheet for income information, a second sheet for expense information, and a third sheet that contains combined information about the first two sheets along with a chart. You switch between sheets by clicking their tabs. When you start a new spreadsheet document, the file comes with three sheets by default, called Sheet1, Sheet2, and Sheet3. These are just a starting point to get you going.
This section shows you how to add, rename, reorder, and delete sheets, and resize the viewing area of the sheet tabs. Adding Sheets to a Spreadsheet
Updating Linked SheetsIf you add a sheet in Calc that is a link to a sheet in another spreadsheet file (see previous procedure), you can update the added sheet when the source file containing that sheet is modified. When you open the file containing the link, the program by default prompts you to update links. (You can change this default in Tools > Options > Spreadsheet > Other.) You can also update the link as you're working by choosing Edit > Links, selecting the linked sheet in the Edit Links window, and clicking the Update button. Changes you make to the source file must be saved before changes are reflected in the linked sheet. Note If you don't see the Links item in the Edit menu, or if you don't see the linked sheet listed in the Edit Links window, the sheet was inserted as a copy rather than a link. Delete the sheet and re-insert it as a link. (See Adding Sheets to a Spreadsheet on page 521.) Renaming Sheets
Reordering Sheets
Deleting SheetsDeleting a sheet deletes all the data on the sheet. You can't delete sheets that have been protected (see Protecting Cells From Modification on page 602).
Resizing and Navigating in the Tab AreaAs you add sheets and change sheet names , you may not be able to see all tabs at once. Use the tips in Figure 18-29 to navigate in the tab area of a spreadsheet document. Figure 18-29. Navigating the tab area
Row LimitThere is a limit of 32,000 rows per spreadsheet. The explanation at http://sc.openoffice.org/row-limit.html keeps updated information. |