User manual SUN MICROSYSTEMS STAROFFICE 7 OFFICE SUITE

[. . . ] StarOfficeTM 7 Office Suite A SunTM ONE Software Offering User's Guide Sun Microsystems, Inc. 817-1802-10 July 2003, Revision A Copyrights and Trademarks Copyright © 2003 Sun Microsystems, Inc. , 4150 Network Circle, Santa Clara, California 95054. has intellectual property rights relating to technology embodied in the product that is described in this document. In particular, and without limitation, these intellectual property rights may include one or more of the U. S. [. . . ] StarOffice loads the Web page or file in the "background", that is, without displaying it. In the large list box of the External Data dialog, you can see the name of all the sheets or named ranges you can choose from. You can also activate the automatic update function every "n" minutes and click OK. The contents will be inserted as a link in the StarOffice Calc document. When you open it again later, StarOffice Calc will update the linked cells following an inquiry. Under Tools - Options - Spreadsheet - General you can choose to have the update, when opened, automatically carried out either always, upon request or never. The update can be started manually in the dialog under Edit - Links. 228 StarOfficeTM 7 User's Guide Using Charts Data from spreadsheets can be represented graphically in a chart. You can select from a variety of charts suited for illustrating the structure of the data. Long-click the Insert Object icon found in the Main Toolbar to display the floating toolbar. The mouse pointer will change to a cross-hair symbol with a small chart symbol. In the spreadsheet, drag open a rectangle defining the initial location and size of the chart. As soon as you release the mouse button, a dialog appears in which you can make further entries. You can also click the Create button to create a chart with the default settings. 4. 5. The example data show the number of times people of different age groups in various cities go to the movie theater annually. Look for the document in your samples folder. Chapter 4 Creating Spreadsheets With StarOffice Calc 229 If you would rather put the cities than the age groups on the horizontal axis, you can "tilt" the chart: With the chart still selected, the Main Toolbar contains a Data in Columns icon and a Data in Rows icon. You can either double-click on the objects or, with the chart selected, choose the commands from the Format menu. For example, if you double-click on a color preview in the legend, you can reformat all data points of that data series. If you double-click the background in the box of the legend, you can format the background of the legend. If you created the chart from the data of a StarOffice Calc spreadsheet, the data series that you click on in the chart are highlighted in the table. Suppose you placed the chart in your StarOffice Calc spreadsheet in the background, and now you are wondering how to select it for further editing. Open the Show Draw Functions floating toolbar and select the first tool, the Select arrow. In a StarOffice Calc chart, you can move a data series forward or backward. [. . . ] Alt and the underlined character Copies or moves the current field into the in the word "Column" "Column" area. Alt and the underlined character Copies or moves the current field into the in the word "Data" "Data" area. Ctrl+Up Arrow Moves the current field up one place. 452 StarOfficeTM 7 User's Guide Shortcut Ctrl+Down Arrow Ctrl+Left Arrow Ctrl+Right Arrow Ctrl+Home Ctrl+End Alt+O Delete Action Moves the current field down one place. Removes the current field from the area. Shortcut Keys for StarOffice Impress The following is a list of shortcut keys for StarOffice Impress. Function Keys for StarOffice Impress Shortcut F2 F3 Ctrl+F3 Shift+F3 F4 F5 F7 Ctrl+F7 F8 Ctrl+Shift+F8 F9 (or Ctrl+F2) Action Edit text Edit group Exit group Duplicate Position and Size Navigator Spellcheck Thesaurus Edit Points Fit text to frame Start Slide Show Chapter 8 Appendix 453 Shortcut F11 F12 Ctrl+F12 Action Stylist Outline View Drawing View Shortcut Keys in Slide Shows Shortcut F9 (or Ctrl+F2) Action Start Slide Show Esc or Backspace or (-) Minus key End presentation on the numerical keypad Spacebar Enter or Arrow Down or N [number] - Enter Arrow Left or Arrow Up or P Arrow Right Pos 1 End Ctrl+Page Up Ctrl+Page Down F5 B W Next animated object or next slide Go to next slide Type a number of a slide and press Enter to go to the slide. [. . . ]