Copyright © 2001 COREL CORPORATION and COREL CORPORATION LIMITED. All rights reserved. For complete copyright information, please refer to the About section in the Help menu of the software.
Book contents Section 1: Introduction . . . Section 2: WordPerfect 10 . Section 3: Quattro Pro 10 . . . . . . . . . . . . . . 5 29 . . . . . . . 145 Section 4: Corel Presentations 10 . . . . . . 251 Section 5: Paradox 10 . . . . . . . . 339 . . . . . . . 399 .
Section 1 Introduction
Table of contents: Introduction Welcome to WordPerfect Office 2002 . . . What’s the purpose of this user guide . . . . About Corel Corporation . . . . . . . WordPerfect Office 2002 applications . . . . What's new in WordPerfect Office 2002 . . . . Other WordPerfect Office 2002 applications and utilities Installing WordPerfect Office 2002 . . . . . . . . . . . . . . . . . . . . Using online Help . . . . PerfectExpert . . . . . We want your feedback . . .
Welcome to WordPerfect Office 2002 1 Welcome to WordPerfect® Office 2002 from Corel Corporation. WordPerfect Office 2002 is an award-winning, integrated set of business-productivity applications for at work and at home. With WordPerfect Office 2002, you can create annual reports, calculate your home budget, produce mailing lists from databases, design brochures and menus, deliver business presentations, and more.
You can find more information about WordPerfect Office 2002 documentation and online Help in Chapter 3 of this section. Documentation conventions Before you start using this user guide and the online Help, it's important to understand the documentation conventions. The following are conventions related to using the mouse. When you see this … Do the following ... Click File } New Click the File menu with the mouse, and click the word New in the menu.
The following conventions are used in this user guide. When you see this … This is... A note. A tip. About Corel Corporation Corel Corporation is an internationally recognized developer of award-winning business productivity and graphics applications. Development of market-leading products, such as WordPerfect Office 2002 and the CorelDRAW™ line of graphics applications, is continually evolving to meet the demands of the corporate, retail, and academic users.
preparing year-end financial statements, performing complex data analysis, and creating reports from external databases. Like WordPerfect 10, Quattro Pro 10 lets you create a single file, then publish it to paper, electronic media, and the World Wide Web. As well as enhancements to existing features, the charting engine in Quattro Pro 10 has been reengineered to give you more power, control, flexibility, and ease of use.
Wide Web, ensuring more accurate reporting. In addition, Paradox 10 contains enhancements to developer features, new graphics filters, and new document filters. Paradox also features ObjectPAL®, an object-based, event-driven development language that you can use to create customized database applications. For more information about new features included in Paradox 10, refer to the “What’s new” section of the online Help file.
Corel Connector If you have an Internet connection, you can connect to product-specific information, newsgroups, updates, technical support, and more using the new Corel Connector included in WordPerfect Office 2002. The Corel Connector is a thin Web client integrated into the applications.
when you want to leave a reminder, note a change in a document, or make a remark about a document. Desktop Application Director The Desktop Application Director™ (DAD) lets you access the major applications in WordPerfect Office 2002 from the Windows taskbar, which eliminates the need to create shortcuts. You can customize DAD to include any application or executable file, which reduces the need to navigate through the Windows Start menu. Dragon NaturallySpeaking Dragon NaturallySpeaking 5.
Install As You Go Install As You Go™ lets you minimize the hard disk space required by WordPerfect Office 2002 applications. If you try to use an item that is not installed, Install As You Go asks if you would like to install it. You can install only the applications and utilities you need, as you need them. Macros and PerfectScript Macros are time-saving programming scripts that automate routine tasks. Macros let you reproduce the behavior of keyboard commands, some mouse actions, and menu commands.
To install Quick View Plus 1 Insert the WordPerfect Office 2002 CD #1 into the CD-ROM drive. If the WordPerfect Office 2002 Setup screen does not display, click the Start button on the Windows taskbar, and click Run. Type D:\SETUP (where D is the letter corresponding to the CD-ROM drive) in the Open box. 2 Click Quick View Plus Setup. 3 Follow the on screen prompts. PerfectExpert PerfectExpert™ includes the best features from QuickTask, templates, Coaches, and online Help.
tools and utilities, including code generation wizards for third-party add-ons to WordPerfect, Quattro Pro, and Corel Presentations; utilities to monitor events in WordPerfect and Corel Presentations; and a file format parsing tool The SDK can be downloaded from www.corel.com. The Corel Solution Partners program supports developers of complimentary products and add-ons for selected Corel products, including WordPerfect Office 2002.
Installing WordPerfect Office 2002 2 You must install WordPerfect Office 2002 before you run it for the first time. The WordPerfect Office 2002 Setup application makes it easy to install.
16-bit sound card or built-in audio input quality equal to or greater than Soundblaster 16. Speaker required for sound output. Additional hardware may be required for laptop installation. Setting up WordPerfect Office 2002 The WordPerfect Office 2002 Setup application installs all the main applications and components. To Install WordPerfect Office 2002 applications 1 Insert the WordPerfect Office 2002 CD into the CD-ROM drive.
T I P To change selections in the Setup Wizard, click the Back button. Click the Help button for more information when you make selections in the Setup Wizard. Registering WordPerfect Office 2002 Registering WordPerfect Office 2002 provides you with timely access to the latest product updates and to high-quality technical support. The serial number on the registration card is proof that you own a legal copy of WordPerfect Office 2002.
To update a WordPerfect Office 2002 installation 1 Close any open WordPerfect Office 2002 applications. 2 On the Windows taskbar, click Start } WordPerfect Office 2002 } Setup and notes } WordPerfect Office 2002 Setup. 3 Enable the Update Current Installation button. 4 Click the Next button. 5 Click the Install button.
I did a Compact installation. Why do Spell Check, Thesaurus, or Grammatik not run? A Compact installation installs only the files necessary to run WordPerfect Office 2002. If you want to install writing tools, such as Spell Check, Thesaurus, or Grammatik®, run the Setup application again, choose Custom installation, then install the files you want. Can I reinstall specific files? If you need a specific file, you can copy it from the CD, where all the decompressed WordPerfect Office 2002 files are located.
2 From the Windows taskbar, click the Start button, and click Run. Type D:\NETADMIN\NETSETUP.EXE (where D is the letter that corresponds to the CD-ROM drive) in the Open box. 3 Click the Release Notes button if you want to read the WordPerfect Office 2002 Release Notes. The Release Notes may contain installation tips that were not available at press time. 4 Click the Next button, and follow the instructions in the Network Administrator Setup wizard.
Learning how to use WordPerfect Office 2002 3 In addition to the user guide you are reading, WordPerfect Office 2002 offers electronic documentation to help you learn and use the applications efficiently, and the PerfectExpert, a user assistance tool, to help you work more quickly while you become more familiar with WordPerfect Office 2002 applications. WordPerfect Office 2002 electronic documentation is available in two formats that offer different content and tools: online Help files and PDF manuals.
To print an entire section in the online Help 1 On the Contents page, choose the section you want to print. 2 Click the Print button. To print a selected topic in the online Help Right-click the help topic window, and click Print Topic. Context-sensitive Help WordPerfect Office 2002 includes several forms of context-sensitive Help — help that provides you with information about the application while you work. You can access context-sensitive Help from the menus, dialog boxes, and toolbars.
provides you with galleries of professionally designed documents to choose from, whose layout and content you can change to match your needs. To enable the PerfectExpert From a WordPerfect Office 2002 application, click Help } PerfectExpert. We want your feedback If you have comments or suggestions about WordPerfect Office 2002 documentation, you can email them to wpodocs@corel.ca or mail them to the address below. Unfortunately, we may not be able to respond to your messages individually.
Other sources for learning WordPerfect Office 2002 Other sources for learning about using WordPerfect Office 2002 applications inlcude the following: World Wide Web Corel’s site on the World Wide Web provides resources to help answer your questions about WordPerfect Office 2002. For information about these resources, see “Technical support on the World Wide Web” on page 25.
Corel support and services 4 The Corel product you are using is supported by the Corel Client Services team. This team is committed to providing quality customer service and support that is easy to access and convenient to use, while fostering one-to-one customer relationships. If you have a question about the features and functions of Corel applications or operating systems, see the user guide or online Help for the product you are using.
Self-serve option How to access FTP information http://www.corel.com/support/ftpsite/ftpindex.ht m Online Help Type keyword Technical Support Interactive Voice Answering Network (IVAN)* 1-877-42-COREL Automated Fax on Demand* 1-877-42-COREL *IVAN and Fax on Demand are available only in North America. Telephone technical support options Corel users can use complimentary and fee-based telephone technical support options. Three levels of support are available.
Mail, fax, email You can send specific customer-service questions to Corel Customer Service representatives by mail, fax, and email. Corel Corporation Corel Customer Service 1600 Carling Avenue Ottawa, Ontario Canada K1Z 8R7 Fax: 1-613-761-9176 Email: custserv2@corel.ca Telephone You can telephone Corel Customer Service centers with your questions. In North America, you can reach Corel Customer Service by calling the 1-800-772-6735 toll-free line. The hours of operation are 9:00 A.M. to 9:00 P.M.
Section 2 WordPerfect 10
Table of contents: WordPerfect 10 Welcome to WordPerfect 10 . . What’s new in WordPerfect 10 . . What’s different in WordPerfect 10 . Working with documents . . . . . . . . . . . . . . . Understanding the components of a document Creating documents . . . . . . Opening documents . . . . . . Adding the date and time to a document . Saving a document . . . . . . Printing a document . . . . . . Closing documents and quitting WordPerfect. Formatting pages . . . . . . . . . . . . . . . . . .
Making text fit a specific number of pages . . Changing the spacing between lines and paragraphs Hyphenating text. . . . . . . . Setting hyphenation prompts and notifications . Changing hyphen options and position . . . Working with footnotes and endnotes . . . . . . . . . . . . . . . . . . . . . Creating and applying bulleted lists . Numbering lists and outlines . . . . . . Numbering pages . . . . . . Setting page, chapter, and volume numbers . Suppressing and discontinuing page numbers . .
Selecting and moving table components . . . Setting and inserting rows and columns in tables . Joining and splitting table cells . . . . . Deleting tables and table components . . . . Rotating table cell contents and skewing cells . . Adjusting table column widths . . . . . Creating table header rows and adjusting table rows . Applying fills, lines, and color to tables . . . Applying borders to tables . . . . . . Entering formulas in tables . . . . . . Calculating formulas in tables . . . . . .
Welcome to WordPerfect 10 1 WordPerfect 10 is a powerful word-processing application that helps you produce newsletters, articles, reports, proposals, books, and other documents. WordPerfect lets you add graphics, tables, and charts to documents. You can publish to paper, electronic media, and the World Wide Web. WordPerfect allows you to format, structure, and edit documents at any time and gives you complete control over their design.
Feature What it does Text to tables Lets you convert document text to a tabular format, based on a user-specified delimiter. Toolbar and property bar pickers Lets you choose an option for underlining, undoing or redoing, adding drop caps, and other formatting options. Two-page view Supports Reveal codes and writing tools. Variables Lets you insert a variable placeholder into a document and change the contents later, updating all instances of the variable.
Feature What’s different Tables A Table menu has been added to the menu bar. Cells containing formulas are marked with a colored indicator. You can also copy cell formulas by dragging. The QuickSplit columns and rows button on the property bar lets you split a cell into four cells (columns and rows). The Shadow Cursor now works in table cells. Text selection You have more flexibility in selecting text with your mouse or keyboard. From here For more information about... In the online Help Index, type.
Working with documents This chapter tells you how to perform basic operations in WordPerfect. 2 In this section, you’ll learn about understanding the components of a document creating documents opening documents adding the date and time to a document saving a document printing a document closing documents and quitting WordPerfect Understanding the components of a document A WordPerfect document is a file with a filename extension.
Templates A template is a preformatted document that can be used as a guide for creating a new document. Every document created in WordPerfect is based on a template or a project template. When you open WordPerfect, the blank document you see is based on the default template. Project templates can include fax cover sheets, memos, newsletters, and brochures. For more information about templates, see “Using project templates” in the online Help. Macros Macros are used to automate application tasks.
To open a WordPerfect document 1 Click File } Open. 2 Choose the drive and folder where the document is stored. 3 Choose a file format from the File type list box. Choosing the All files item displays files of all types. 4 Double-click the document file name. You can also open a document by clicking the Open button on the toolbar. If you know where a file is located, you can type the full path and filename in the File name list box. To open a document created in another application 1 Click File } Open.
To delete the date or time 1 Select the date or time in your document. 2 Press DELETE. Saving a document When you save a document for the first time, you assign it a name and choose a folder in which to store it. Any changes you make to the document after that are saved to that location. You can create a new copy of the document by saving it to a different folder or with a different filename.
4 Specify any other print options. 5 Click Print. You can also print a document by clicking the Print button on the toolbar. Closing documents and quitting WordPerfect You can close the active document or all documents and leave WordPerfect open. When you quit WordPerfect, the application closes along with all of the documents you have open. You are prompted to save any modified documents before closing or quitting. To close and quit WordPerfect To Do the following Close a document Click File } Close.
Formatting pages 3 When you change the format of a document, you change the physical arrangement of information on a page and the general appearance of the finished document. WordPerfect 10 lets you change the format for part of a page or for a whole page, and you can apply one format to selected text and apply a different format to other text in the same document. WordPerfect contains on-screen alignment tools, such as guidelines, rulers, and ruler guides, to help you as you type.
To set the page margins by using the margin guidelines 1 Click View } Guidelines. 2 Enable the Margins check box. 3 Point to one of the following guidelines: left vertical dotted guideline right vertical dotted guideline upper horizontal dotted guideline lower horizontal dotted guideline The pointer changes to a double-sided arrow. 4 Drag the guideline to the position you want. To set the page margins by using exact measurements 1 Click a page. 2 Click Format } Margins.
Setting page size definitions and orientation A page size definition determines how a printer formats and prints pages. For example, you can create page size definitions for envelopes and nonstandard-sized pages. You can choose from preset page size definitions, or you can create your own. Page size definitions are matched to the printer you have selected. A definition may not be available when you change to another printer or a different computer.
The default paper source is the source specified in the Windows printer properties for the selected printer. Choose Manual feed from the Source list box in the Edit page definition dialog box only if you put paper in the printer manually, one sheet at a time. To delete a page size definition 1 Click File } Page setup. 2 Click the Page setup tab. 3 Choose a page size from the Page definition list box. 4 Click the Delete form button .
As you edit the document, each logical page is treated as a separate page. The document window also changes to show the dimensions of the logical page. After you fill a logical page, the text continues on the next logical page. All the formatting you can use in a regular document applies to the logical pages you create. To choose a document layout for binding 1 Click File } Page setup. 2 Click the Page setup tab.
You can choose how an object is imported into a document by clicking Edit } Paste special. For example, you can choose to paste it in an unformatted text format or in Rich Text Format. Creating and deleting columns You can use columns to divide text vertically on a page. There are four types of columns for use in documents such as newsletters, glossaries, scripts, or inventory lists: Newspaper, Balanced newspaper, Parallel, and Parallel with block protect. The following picture shows newspaper columns.
grouped across the page in a row. The next row starts below the longest column of the previous row. Parallel columns are useful for résumés, scripts, charts, or inventory lists. The following picture shows parallel columns with block protect and illustrates that parallel columns with block protect keep each row of columns together. If a column in one row becomes so long that it moves across a page break, the entire row moves to the next page. You can also use tables to create this type of column.
Parallel w/block protect — keeps all rows of the columns together across page breaks You can also apply columns to a page by clicking the Columns button toolbar to specify the number of columns and other options. on the To delete a column 1 Click in a column. 2 Click Format } Columns. 3 Click Discontinue. You can also delete columns by dragging the COL DEF code out of the Reveal Codes window. From here For more information about... In the online Help Index, type...
Working with headers and footers 4 You can use headers and footers to display information, such as numbering, a chapter heading, a title, a date, a person’s name, or a company name, at the top or bottom of each page or on alternating pages of a document.
To insert a header or footer 1 Click Insert } Header/footer. 2 Enable one of the following options: Header A Header B Footer A Footer B 3 Click Create. 4 Type the header or footer text. 5 Click File } Close. You can use two different headers and two different footers at any place in a document. You can have several headers and footers in a document, but only two headers and two footers can be active on a page. Only a header or footer of the same kind can replace an existing header or footer.
If the Page view command or the Two pages view command is displayed, you can also edit the header or footer by clicking anywhere inside the header or footer. To adjust the distance below a header or above a footer 1 Click Insert } Header/footer. 2 Enable one of the following options: Header A Header B Footer A Footer B 3 Drag the header or footer guidelines up or down.
Inserting items into headers and footers You can insert a horizontal line into a header or footer to, for example, create a separation between the information in the header or footer and the document text. You can also insert the filename (or the path and filename) of the active document into headers and footers. If the document has never been saved, a code will be inserted, but the filename (or path and filename) will not be displayed until you save the document.
Footer A Footer B 3 Click Insert } Date/time. 4 Choose a date and time format from the Date/time formats list. 5 Click Insert. To insert numbering into a header or footer 1 Click Insert } Header/footer. 2 Enable one of the following options: Header A Header B Footer A Footer B 3 Click Format } Page } Insert page number. 4 Choose a page numbering format from the Number list. 5 Click Insert.
Formatting text 5 In WordPerfect, you can use a variety of formatting tools to control the design and arrangement of text.
The following image displays examples of different fonts and font styles. To change the font 1 Click in the document. 2 Click Format } Font. 3 Click the Font tab. 4 Choose a font from the Face list. You can also Change the font style In the Appearance area, enable any of the check boxes. Change the font size Choose a font size from the Size list box. Change the relative font size Click Relative size, and click a font size. Change the font color Open the Color picker, and click a color.
You can change the font size using Corel RealTime Preview by opening the Font size list box on the property bar, viewing the font sizes in the font size preview window, and choosing a font size. To disable Corel RealTime Preview 1 Click Tools } Settings. 2 Click the Display icon. 3 Click the Document tab. 4 In the Show area, disable the RealTime Preview check box. Corel RealTime Preview is enabled by default.
To highlight text 1 Click Tools } Highlight } On. The cursor changes to a highlighting pen. 2 Select the text. 3 Click Tools } Highlight } On. Highlighting is disabled when no check mark displays beside the On menu command. You can also highlight text by selecting text and clicking the Highlight button . To remove highlighting from text 1 Select the highlighted text. 2 Click Tools } Highlight } Remove.
The following image shows a paragraph without a drop cap (on the left) and a paragraph with a drop cap (on the right). To add or remove a drop cap To Do the following Add a drop cap to a blank line Click in a document. Click Format } Paragraph } Drop cap. Type a letter. Add a drop cap to an existing paragraph Click at the beginning of a paragraph. Click Format } Paragraph } Drop cap. Remove a drop cap Click before a drop cap. Click the Drop cap style button on the property bar.
To change the position of a drop cap 1 Click before a drop cap. 2 Click the Drop cap position button on the property bar. 3 In the Position area, type a value in the Position drop cap in margin box. You can also specify the position of a drop cap by moving the slider in the Position area. You can also change the position of a drop cap by clicking the Drop cap position picker on the property bar and clicking a drop cap position. To change the style of a drop cap 1 Click before a drop cap.
not indented, 2) an indented paragraph, 3) a paragraph to which a double indent has been applied, and 4) a paragraph to which a hanging indent has been applied. To apply a single indent to text To indent Do the following A line of text Click at the beginning of a line of text. Press TAB. A paragraph Click at the beginning of a paragraph. Click Format } Paragraph } Indent. The first line of every paragraph automatically Click in a paragraph. Click Format } Paragraph } Format.
The following image shows the justification options that WordPerfect provides: 1) a left-justified paragraph, 2) a right-justified paragraph, 3) a center-justified paragraph, 4) a fully justified paragraph, and 5) a paragraph with all lines justified. To justify text 1 Click in a paragraph.
To keep words together 1 Click between two words. 2 Click Format } Line } Other codes. 3 Enable the Hard space [HSpace] option. 4 Click Insert. Before inserting a hard space between two words, you must remove any spaces between them. To keep a paragraph together 1 Click at the beginning of a paragraph. 2 Click Format } Keep text together. 3 In the Widow/orphan area, enable the Prevent the first and last lines of paragraphs from being separated across pages check box.
Lowercase — changes all letters to lowercase Uppercase — changes all letters to uppercase Initial capitals — changes only the first letter of each word to uppercase You can add buttons to the toolbar for capitalization. For information about toolbars, see “Customizing toolbars” in the online Help. You can also change the selected text to uppercase or lowercase by pressing CTRL + K. To automatically correct capitalization 1 Click Tools } QuickCorrect. 2 Click the Format-As-You-Go tab.
To make text fit a specific number of pages 1 Click in a document. 2 Click Format } Make it fit. 3 Type a value in the Desired number of pages box. The number of pages you set must be within 50 percent of the document’s current page count. 4 In the Items to adjust area, enable any of the following check boxes: Left margin Right margin Top margin Bottom margin Font size Line spacing 5 Click Make it fit. To make only a certain block of text fit, select the text.
To change the line height to a fixed size 1 Click in a paragraph. 2 Click Format } Line } Height. 3 Enable the Fixed option, and type a value in the box. Line height is determined by multiplying the current line height by the number you specify. You can also change the line height of selected text. To change the space between paragraphs 1 Click in a paragraph. 2 Click Format } Paragraph } Format.
Setting hyphenation prompts and notifications Setting a prompt for hyphenation lets you choose whether to be prompted when a word needs hyphenation. You can also set a notification sound when a word needs hyphenation. To set a prompt for hyphenation 1 Click Tools } Settings. 2 Click the Environment icon. 3 In the Environment settings dialog box, click the Prompts tab.
To position the hyphen in a word 1 Type text in a document. The Position hyphen dialog box displays when a hyphen is required. 2 Click in the Use mouse or arrow keys to position hyphen box, and press any of the following keys: LEFT ARROW — moves the hyphen to the left of the displayed word RIGHT ARROW — moves the hyphen to the right of the displayed word To reposition the hyphen, click where you want the hyphen to display in the word in the Use mouse or arrow keys to position hyphen box.
Working with footnotes and endnotes 6 Footnotes and endnotes allow you to provide more information about a topic discussed in a document. In this section, you’ll learn about creating footnotes and endnotes editing footnotes and endnotes converting footnotes to endnotes or endnotes to footnotes formatting footnotes and endnotes Creating footnotes and endnotes A footnote provides more information about a topic and is found below text or at the bottom of a page.
Editing footnotes and endnotes You can edit the text of footnotes or endnotes. To edit a footnote or endnote 1 Click Insert } Footnote/endnote. 2 Enable one of the following options, and type a value in the box beside it: Footnote number Endnote number 3 Click Edit. 4 Edit the footnote or endnote text. 5 Click File } Close. If you are using Page view, you can also edit the text of the footnote or endnote by clicking in the text.
Starting new numbers for footnotes and endnotes is another option, which is useful when you want each chapter or section of a document to have its own footnotes or endnotes. In addition, you can adjust the separator line that displays between document text and footnotes or endnotes. To change the format of a footnote or endnote number 1 Click Insert } Footnote/endnote. 2 Enable one of the following options: Footnote number Endnote number 3 Click Options, and click Advanced.
To change the numbering method of a footnote or endnote 1 Click Insert } Footnote/endnote. 2 Enable one of the following options: Footnote number Endnote number 3 Click Options, and click Advanced. 4 In the Numbering method area, choose a numbering method from the Numbering list box. If you want to restart footnote numbering on every page, enable the Restart numbering on each page check box. To restart subsequent endnote numbers at 1 1 Click Insert } Footnote/endnote.
Using lists and outlines 7 You can organize text by using bullets, numbers, or outlines. Bullets help to differentiate items in a list or add emphasis to selected paragraphs. You can use bullets to mark list items that have no particular order. Numbered lists and outlines help you organize and display information and are used to show the relationship between ideas. Bulleted lists, numbered lists, and outlines can include several levels of numbering.
To create a bulleted list 1 Click in a document. 2 Click Insert } Outline/bullets & numbering. 3 Click the Bullets tab. 4 Choose a bullet style from the Description list box. 5 Click OK. 6 Type the text, and press ENTER. Perform this step for each entry in the list. 7 Press BACKSPACE to discontinue the list. You can also create a bulleted list by clicking the Bullets picker on the toolbar. To enable QuickBullets 1 Click Tools } QuickCorrect. 2 Click the Format-As-You-Go tab.
To apply a bullet format to existing text 1 Select the text to which you want to apply the bullet format. 2 Click Insert } Outline/bullets & numbering. 3 Click the Bullets tab. 4 Choose a bullet style from the Description list box. You can also add a bullet to existing text by clicking at the beginning of a line and clicking the Bullets button on the toolbar. To type body text between list items, press ENTER twice, and press UP ARROW to type on the line that begins without a bullet.
To create a numbered list by using QuickNumbers 1 Type a number followed by a period, closing parenthesis, or hyphen at the beginning of a new line. 2 Press TAB. 3 Type the text for the first list item, and press ENTER. For a paragraph, let the text wrap at the end of the line instead of inserting a hard return. Perform this step for each entry in the list. 4 Press BACKSPACE. To use QuickNumbers, QuickBullets must first be enabled.
Numbering 8 WordPerfect 10 allows you to assign numbers to paragraphs and documents as well as insert and customize numbers within documents. In this section, you’ll learn about numbering pages setting page, chapter, and volume numbers suppressing and discontinuing page numbers Numbering pages You can number the pages of a document, including information such as the number of pages, chapters, volumes, or secondary pages.
You can choose from several common page numbering formats or create a custom format of your own. For information about custom formats, see “Customizing page numbering formats” in the online Help. To insert page numbers 1 Click Format } Page } Numbering. 2 From the Position list box, choose a position for the page numbers. 3 From the Page numbering format list box, choose a format for the page numbers.
When you merge a multiple-page form document, you can restart the page numbering for each merged record by enabling the Always keep number the same option. To set a chapter number 1 Click Format } Page } Numbering. 2 Click Set value. 3 In the dialog box, click the Chapter tab. 4 Type a new chapter number in the Set chapter number box.
From here For more information about... In the online Help Index, type...
Editing documents 9 WordPerfect 10 provides automatic editing features that help save you time when editing documents. In this section, you’ll learn about marking misspelled words and grammatical errors as you type correcting misspelled words automatically Marking misspelled words and grammatical errors as you type Correcting spelling You can use Spell-As-You-Go™ to check and correct spelling.
To enable or disable Spell-As-You-Go, Grammar As-You-Go, and Prompt As-You-Go To Do the following Enable or disable Spell-As-You-Go Click Tools } Proofread } Spell-As-You-Go. A bullet next to the Spell-As-You-Go command indicates that Spell-As-You-Go is enabled. A bullet next to the Off command indicates that Spell-As-You-Go is disabled. Enable Grammar As-You-Go Click Tools } Proofread } Grammar As-You-Go. A bullet next to the Grammar As-You-Go command indicates that Grammar As-You-Go is enabled.
Correcting misspelled words automatically You can enable QuickCorrect to automatically correct common typing mistakes. QuickCorrect provides a list of commonly misspelled words and their correct spellings. For example, QuickCorrect can automatically replace “adn” with “and.” You can add words to the QuickCorrect list, including a pair of words. For example, you can replace “byt he” with “by the.” Words can also be deleted from the QuickCorrect list. To enable QuickCorrect 1 Click Tools } QuickCorrect.
From here For more information about... In the online Help Index, type...
Using graphics 10 WordPerfect 10 lets you insert graphics, such as shapes, drawings, and clipart images, into documents. You can size, move, and modify graphics to suit your needs.
The following image shows examples of preset shapes 1) basic shapes and 2) flowchart shapes. WordPerfect lets you save a graphic as a separate file which you can insert into other documents. For information about exporting files, see “Import and export file formats for WordPerfect 10" in the online Help. You can delete graphics from a document. WordPerfect also allows you to hide or display graphics. To create a shape 1 Click Insert } Shapes.
To save a graphic 1 Select a graphic. 2 Click File } Save as. 3 In the Save dialog box, click Selected image. 4 Click OK. 5 In the Save image as dialog box, choose the drive and folder where you want to save the graphic. 6 Type a filename in the Filename box. 7 Choose a file type from the File type list box. If you want to save fonts with a graphic, enable the Embed fonts check box. 8 Click Save. To delete a graphic 1 Select a graphic. 2 Press DELETE. To hide or display graphics Click View } Graphics.
To insert a clipart image 1 Click where you want to insert an image. 2 Click Insert } Graphics } Clipart. The Scrapbook™ opens. 3 Browse through the folders in the Scrapbook until you find the image you want to insert. 4 Select the clipart image. 5 Click Insert. You can also insert a clipart image by dragging the image from the Scrapbook into a document. To insert a picture from the WordPerfect Office 2002 CD 1 Insert the WordPerfect Office 2002 CD into your CD drive.
2 Modify the drawing. 3 Click File } Save. You can also modify a drawing or clipart image by double-clicking it. Modifying shapes In WordPerfect, you can modify a shape in several ways. For example, you can add drop shadows, and change the color of lines, shadows, and fills for shapes. You can skew a shape, which means to distort it or make it not symmetrical. Some shapes can be altered using glyphs. The following image demonstrates the different forms a shape can take when altered using a glyph.
You can also modify a shape by using the property bar to change the attributes of a shape. To skew a shape 1 Right-click a shape, and click Skew shape. Small, green, diamond-shaped skewing handles display. 2 Drag a skewing handle until the shape is the size you want. To modify a shape by using a glyph 1 Select a shape. 2 Drag a glyph until you obtain the desired effect. Manipulating graphics WordPerfect 10 lets you manipulate a graphic in several ways.
You can group graphics so that they remain together when they are moved, sized, and edited. The following image is an example of grouped graphics. To reorder overlapping graphics 1 Right-click a graphic.
Aligning and distributing objects WordPerfect lets you align and distribute objects in relation to themselves and the page. You can, for example, align a series of objects horizontally and vertically. To align an object 1 Select an object. 2 Click Tools } Align and distribute. 3 Click the Align tab. 4 Enable any of the check boxes that correspond to the horizontal and vertical alignment you want. If you want to align an object vertically, enable the Left, Center, or Right check box.
To create a color by using color models 1 Click Format } Font. 2 Click the Font tab. 3 Open the Color picker , and click More. 4 Choose a color model from the Color model list box. 5 In the Color values area, type values in the boxes until the color you want displays in the Current color box. The color model you select determines the options available in the Color values boxes. You can open the Select color dialog box from any color palette in WordPerfect. To preview color changes 1 Select a graphic.
To crop an image 1 Right-click an image, and click Image tools. 2 Open the Zoom flyout, and click the Crop image tool . 3 Point to the image until the pointer changes to a magnifying glass. 4 Using the magnifying glass pointer, marquee select the part of the image that you want to crop. The area you select fills the graphics box. Click the Zoom actual size tool original size.
To flip an image 1 Right-click an image, and click Image tools. 2 Click one of the following: Vertical flip — flips or reverses the image on its vertical axis Horizontal flip — flips or reverses the image on its horizontal axis You can also flip an image by clicking the Horizontal flip button flip button on the property bar. or the Vertical To rotate an image 1 Right-click an image, and click Image tools. 2 Click Rotate. Rotation handles display at each corner of the graphics box.
Using tables and charts 11 WordPerfect 10 lets you create tables and charts. Tables let you organize data in rows and columns of cells. Tables can contain text or graphics and can be formatted. You can use tables to present lists, schedules, financial data, comparisons, and summaries. Charts can enhance the presentation of data in a document. You can use data charts to display comparisons, trends, and statistics, or you can use organization charts to display an organization’s structure.
The following image shows a table with 1) rows and 2) columns. To create a table 1 Click Table } Create. 2 Type values in the following boxes: Columns Rows 3 Click Create. You can also Create a table in a graphics box Enable the Drag to create a new table check box, click Create, and drag a rectangle anywhere in a document. Create a floating cell Enable the Floating cell option in the Create area.
To select a table or table components by using QuickSelect To select Do the following A cell In the table, move the pointer until it changes to an arrow pointing upward or to the left, and click. A row In the table, move the pointer until it changes to an arrow pointing to the left, and double-click. A column In the table, move the pointer until it changes to an arrow pointing upward, and double-click.
If you want to move a selected range of cells, a row, or a column, click Edit } Cut. You can also copy table components by selecting a range of cells, a row, or a column, right-clicking, and clicking Copy. Setting and inserting rows and columns in tables You can set the number of rows and columns in a table. You can also insert columns or rows in a table. New columns or rows have the same formatting as the column or row in which the cursor is positioned.
You can also join table cells by clicking Table } Join } QuickJoin and selecting the cells you want to join. To join two tables 1 Click View } Reveal Codes. 2 In the Reveal Codes window, delete all hard return codes and any other codes or text between the [Tbl Off] code of the first table and the [Tbl Def] code of the second table. 3 Click in the first table. 4 Click Table } Join } Table. To split a table cell 1 Click in a cell. 2 Click Table } Split } Cell.
Columns — lets you specify the number of columns to delete If you want to delete only the contents of a row or column, enable the Cell contents only option. Rotating table cell contents and skewing cells You can rotate the contents of a table cell counterclockwise. Rotated text is placed in a text box. You can skew (slant) the top row or the left or right column of a table. You can also change the skew angle and specify other skew options.
None — lets you leave the top row unskewed Top — lets you specify the skew angle for the top row 7 From the Skew columns list box, choose one of the following: None — lets you leave the columns unskewed Left column — lets you specify the skew angle for the left column Right column — lets you specify the skew angle for the right column You can also Create a 90-degree angle with the first column and the top row Enable the Square first column check box.
You can allow a table row to continue across pages. You can also change the height of a table row and the number of text lines per row, and you can align a table between the left and right page margins. To create a table header row 1 Select a row or several rows. 2 Click Table } Format. 3 Click the Row tab. 4 Enable the Header row check box. Applying fills, lines, and color to tables You can change the fill, line style, and line color of a cell, a group of cells, or an entire table.
4 Click a fill style on the Fill palette. 5 Click a fill color on the Foreground or Background palettes. You can also Change the line style of a table cell Click a line style on the Left, Right, Top, Bottom, or Outside line palettes. Change the line color of a table cell Click a line color on the Color palette. Applying borders to tables You can add a border style to a table.
You can insert and copy formulas and functions in table cells and floating cells. You can also type formulas directly into cells if you precede the initial symbols, functions, or numbers with + or =. However, it is best to enter formulas directly only if you know how to use functions and you remember the names you want to reference in formulas. Formulas you enter are calculated automatically when you move the insertion point out of the cell that contains the formula.
Calculate table — calculates the table or floating cell in which the insertion point is positioned Calculate tables in document — calculates all tables and floating cells in the document To add values in a table quickly 1 Click the table cell below or to the right of the cells whose total you want to calculate. 2 Click Table } QuickSum. If you click in a cell instead of selecting a range of cells, the calculated sum overwrites any values, formulas, or text in the cell.
The following image is an example of an organization chart. You can edit and update charts and graphs. You can also edit the data that the chart is based on. You can use the data in a table to create a chart containing the same information. When you create a chart from a table, the two are associated. You can specify that charts associated with tables automatically update when you make changes to the data in the tables. For more information about charts, refer to the Corel Presentations online Help.
3 Click Insert } Organization chart. 4 Click in the drawing frame. 5 Click a chart type. 6 Click OK. 7 Double-click a box in the chart, and type a name and title to replace the placeholder name. 8 Click outside the chart to return to the document window. You can also create an organization chart by playing the wp_org.wcm macro. Click Tools } Macro } Play, and double-click wp_org.wcm. For information about macros, see “Playing macros” in the online Help. From here For more information about...
Applying borders and fills 12 Applying borders and fills lets you emphasize information, make it easier to read, and add visual appeal to a document. The following image shows 1) a graphic, 2) a graphic to which a border was applied, 3) a graphic to which a border and a fill were applied, and 4) a graphic to which a border, fill, and drop shadow were applied.
To add a border to a paragraph 1 Click in a paragraph. 2 Click Format } Paragraph } Border/fill. 3 Choose a border pattern from the Available border styles list. To apply the border only to the selected paragraph, enable the Apply border to current paragraph only check box. If you disable the Apply border to current paragraph only check box, the border surrounds the current paragraph and all subsequent paragraphs in the document. To add a border to a column 1 Click in a column. 2 Click Format } Columns.
To edit the border of a graphics box 1 Right-click a graphic, and click Border/fill. 2 Choose a border pattern from the Available border styles list. 3 Open the Color picker, and click a color. 4 Open the Line style picker, and click a line style. To edit the border of a paragraph 1 Click in a paragraph. 2 Click Format } Paragraph } Border/fill. 3 Choose a border pattern from the Available border styles list. 4 Open the Color picker, and click a color. 5 Open the Line style picker, and click a line style.
To remove a border from a paragraph or page 1 Click a paragraph or page border. 2 Click Format, and click one of the following: Paragraph } Border/fill — lets you change border options for a paragraph Page } Border/fill — lets you change border options for a page 3 Click Discontinue. Applying fills You can add or edit a fill. You can add gradient fills to a graphics box, column, paragraph, or page. To add or edit a fill 1 Right-click a graphic, and click Border/fill. 2 Click the Fill tab.
You can also Rotate the gradient Type a value in the Rotation angle box. Change the placement of shadows within the gradient Type values in the Horizontal and Vertical offset boxes. To add gradient fills for a paragraph or page 1 Click Format, and click one of the following: Paragraph } Border/fill — lets you change gradient fill options for a paragraph Page } Border/fill — lets you change gradient fill options for a page 2 Click the Fill tab.
Merging documents 13 When you perform a merge, you combine a form document and a data source to form a new series of documents. The merge reproduces copies of the form document, with each copy containing information from a specific record in the data source.
The following graphic shows a data text file containing 1) ENDFIELD codes and 2) ENDRECORD codes. When you create a data table file, fields and records are arranged in columns and rows. Each column contains a field. Each row contains a record. The following graphic shows a data table file containing 1) records, 2) fields, and 3) field names. You can retrieve data from other file formats and use them as data files in WordPerfect.
To create a data file for a merge 1 Click Tools } Merge. 2 Click Data source } Create data file. If you have typed in the active document, enable one of the following options in the Data File Source dialog box: Use file in the active window — uses the active document New document window — creates a new document 3 Click OK. 4 Type the name of a field in the Name a field box. If you want to create a data table file, enable the Format records in a table check box. 5 Click Add.
At the top of the document window, WordPerfect inserts the Merge toolbar to give you greater control over a merge. For more information about the Merge toolbar, see “Using the Merge toolbar” in the online Help. You can also create labels and you can merge text that is oriented sideways. To create a form document for a merge 1 Click Tools } Merge. 2 Click Form document } Create form document.
To insert a field in a form document for a merge 1 Click Insert field on the Merge toolbar. 2 Click where you want data to be filled in from a data source. 3 In the Field box, specify the field. 4 Click Insert. To create labels for a merge 1 Click Tools } Merge. 2 Click Form document } Create form document.
To associate a form document with a data source 1 Open a form document that has no association with a data source. 2 Click Go to data on the Merge toolbar. 3 Click one of the following: Select — associates a data file Create — creates and names a new data file or form file Address book — associates an address book ODBC — associates a ODBC data source For information about associating an ODBC data source, see “To associate a form document with an ODBC data source” in the online Help.
To perform a merge 1 Click Tools } Merge. 2 Click Form document, and choose the location of the form file to merge. 3 Click Data source, and choose the location of the data file to merge. 4 Click Output, and choose one of the following: Current document New document Printer 5 Click Merge. You can also Stop a merge in progress Press ESC. Save the merged file to disk Click Output } File on disk. Choose the folder, drive, and where you want to save the file.
6 In the Subject line box, type the subject line for the merged email message. 7 Click OK. 8 Click Merge. Sorting, viewing, and finding data in data files You can sort a data file. Using the Quick Data Entry feature in WordPerfect, you can scroll through the records and fields in a data file to view them. You can also find records that contain specific text. For more information about finding text, see “Finding and replacing text” in the online Help.
To specify conditions for a merge 1 Click Tools } Merge. 2 Click Perform merge. 3 Click Form document, and choose the location of the form file. 4 Click Data source, and choose the location of the data file. 5 Click Records. 6 Enable the Specify conditions option in the Selection method area. 7 Select a field from the Field list box. 8 Type the selection criteria in the Condition text boxes. If you want to see examples of selection criteria, click Example. 9 Click OK.
Publishing Web documents 14 WordPerfect 10 lets you publish documents to HTML and to PDF. HTML documents can be viewed on the Web. PDF documents are viewed using the Adobe Acrobat Reader. In this section, you’ll learn about publishing to HTML publishing to PDF building XML documents Publishing to HTML When you publish a document to HTML, WordPerfect saves it as a .HTM file. You can browse the web from WordPerfect, and you can preview your document in a browser from within WordPerfect.
To convert a graphic to GIF 1 Right-click the graphic, and click HTML properties. 2 Click the Publish tab. 3 Enable the GIF button. 4 Enable any of the following check boxes: Interlaced — lets the image appear interlaced Transparency — lets you choose a transparency color If you enable the Transparency box you can choose a transparency color by clicking the Transparent color button and clicking a transparency color on the color palette.
Selection — publishes highlighted text If you enable the Pages option, you must type the numbers for the first and last pages which you want to publish in the Publish page number boxes. Building XML documents You can use WordPerfect to create, edit, retrieve, validate, and save documents created with the Standard Generalized Markup Language (SGML) or the eXtensible Markup Language (XML).
Index: WordPerfect 10 A adding capitalization exceptions automatically. drop caps . . . . . . . . values in a table . . . . . . adjusting leading . . . . . . . . . table column widths . . . . . aligning objects . . . . . . . . . applying borders to tables . . . . . . color to tables . . . . . . . fills . . . . . . . . . . fills to tables . . . . . . . lines to tables . . . . . . . arranging graphics . . . . . . . . . associating form documents with data sources . B binding . . . . . borders adding . . .
creating . . . . . . . . . creating from tables . . . . . . creating organization . . . . . . organization . . . . . . . . using . . . . . . . . . . clipart inserting . . . . . . . . . closing documents . . . . . . . . . color adjusting image attributes . . . . . applying to tables . . . . . . . changing highlight color . . . . . creating . . . . . . . . . . creating using models . . . . . . previewing . . . . . . . . . color models creating colors . . . . . . . . working with color . . . . . . .
navigating . . . . . publishing to PDF . . . rulers . . . . . . selecting text . . . . tables . . . . . . two-page viewing . . . disabling Corel RealTime Preview . . Grammar-As-You-Go . . . Prompt-As-You-Go . . . Spell-As-You-Go . . . . discontinuing footers . . . . . . headers . . . . . . page numbers . . . . distributing objects . . . . . . document components understanding . . . . document layout choosing . . . . . document windows viewing footers . . . . viewing headers . . . . documents closing . . . .
fills adding . . . . . . . . . adding gradient . . . . . . applying to tables . . . . . . editing . . . . . . . . . flipping images . . . . . . . . . floating table cells entering formulas . . . . . . font colors . . . . . . . . . fonts changing . . . . . . . . changing color . . . . . . . changing relative size . . . . . changing size . . . . . . . changing style . . . . . . . changing with Corel RealTime Preview . modifying settings . . . . . . footers changing space above or below. . . discontinuing . .
H headers changing space above or below. discontinuing . . . . . editing . . . . . . . formatting . . . . . . in table rows . . . . . inserting . . . . . . inserting dates . . . . . inserting horizontal graphics line inserting items . . . . . inserting numbering . . . inserting the document filename inserting time . . . . . suppressing . . . . . . viewing . . . . . . . highlighting hiding . . . . . . . removing . . . . . . text . . . . . . . . HTML publishing . . . . . . hyphenating automatic . . . . . .
adjusting . . . . . . . . . . . . 69 lines applying to tables . . . . . . . . . . 108 changing height to a fixed size . . . . . . . 70 inserting in footers . . . . . . . . . . 56 inserting in headers . . . . . . . . . . 56 spacing . . . . . . . . . . . . . 69 linking . . . . . . . . . . . . . . 91 listing QuickCorrect words . . . . . . . . . . 87 lists bulleted . . . . . . . . . . . . . 77 creating custom symbols . . . . . . . . 78 numbering . . . . . . . . . . . . 79 M mail merging to . . . . . . . . . .
organization charts creating . . . . . . . . . . . . 112 playing macros . . . . . . . . . . . 112 outlines creating . . . . . . . . . . . . . 79 renumbering . . . . . . . . . . . 80 P page borders adding . . . . . . . removing . . . . . . page margins changing . . . . . . using guidelines . . . . . using ruler . . . . . . page numbers discontinuing . . . . . inserting. . . . . . . setting . . . . . . . suppressing . . . . . . page orientation . . . . . page size deleting definition . . . . editing . . . .
drop caps . . . . indents . . . . . resizing graphics . . . . . restarting endnote numbers at 1 . restoring images to original . . Ros/Col indicators selecting columns . . selecting rows . . . selecting tables . . rotating gradient fills . . . . images . . . . . table cell contents . . . . . . . . . . . . . . . . . . 63 65 . . . . . . . . 94 . . . . . . . . 76 . . . . . . . . 98 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
copying . . . . . . cutting . . . . . . . deleting . . . . . . pasting . . . . . . . using QuickSelect . . . . table formulas calculating . . . . . . table rows creating headers . . . . . deleting . . . . . . inserting . . . . . . setting number . . . . tables adding values . . . . . adjusting column widths . . applying borders . . . . applying color . . . . . applying fills . . . . . applying lines . . . . . calculating formulas . . . creating . . . . . . . creating charts . . . . . creating header rows .
publishing active documents to PDF . . . . . 132 publishing to HTML . . . . . . . . . 131 publishing to PDF . . . . . . . . . . 132 WordPerfect 10 getting started . . . . . . . . . . . 39 quitting . . . . . . . . . . . . . 43 welcome to . . . . . . . . . . . . 35 what’s different . . . . . . . . . . . 36 what’s new . . . . . . . . . . . .
Section 3 Quattro Pro 10
Table of contents: Quattro Pro 10 Welcome to Quattro Pro 10 . What’s new in Quattro Pro 10 . What’s different in Quattro Pro 10. Getting started . . . . . . . . . . . . . . . . . . . . . . . . Creating and opening notebooks . . . Entering labels and special characters . . Entering values . . . . . . . Filling cells and spreadsheet tabs automatically Creating simple equations . . . . Performing running calculations . . . Editing and formatting a spreadsheet Protecting data . . . . . .
Hiding rows and columns . . . . Using formatting tools to format a spreadsheet Wrapping text . . . . . . . Joining cells . . . . . . . Changing text font and appearance . . Working with fills, patterns, and borders . Aligning data . . . . . . . Working with numeric formats . . . Working with page breaks . . . . Creating headers and footers . . . . Customizing margins . . . . . Analyzing data . . . . . Using statistical analysis tools. . . Creating frequency distribution tables .
Welcome to Quattro Pro 10 1 Quattro Pro lets you create professional spreadsheet-based documents to help you manage data. It provides all the tools you need to produce tables, financial forms, lists, databases, charts, reports, or any other type of data-oriented document. With Quattro Pro, you can create a notebook that contains a single spreadsheet or an entire project, complete with spreadsheets, reports, and charts.
Multiple Undo/Redo Quattro Pro now allows you to reverse multiple past actions, and, if desired, reinstate the actions. As many as 200 past actions can be reversed with the multiple undo command. QuickFit New QuickFit menu options (Column QuickFit, Row QuickFit, Column/Row QuickFit) allow you to optimize the structure of your spreadsheet. AutoScroll AutoScroll is now featured as a standalone tool in Quattro Pro, independent of the IntelliMouse.
Edit menu changes All the menu options listed below are found in the Edit menu. Quattro Pro 9 Quattro Pro 10 Delete Delete cells Clear } Comments Clear } Delete comments Clear } Formats Clear } Format Links } Change link Links } Change links Find page break Find breaks View menu changes All the menu options listed below are found in the View menu.
Quattro Pro 9 Quattro Pro 10 External data } Database Desktop (removed) External data } Import database file External data } Import database File Insert file Format menu changes All the menu options listed below are found in the File menu.
Quattro Pro 9 Quattro Pro 10 Data tools } Cross tabs Data tools } CrossTab (new) Data tools } Combine files Workgroup } Review notebook } Color Workgroup } Review notebook } Select color Internet } Web queries online (moved to Help menu) Help menu changes All the menu options listed below are found in the Help menu.
Getting started 2 Before beginning your project, you should familiarize yourself with the concepts and desktop components that will help you create spreadsheet-based documents. Quattro Pro features many tools which provide you with quick access, seamless mobility, and powerful efficiency. You can also customize your workspace and tailor your toolbars to present a familiar working environment each time you launch your application.
you can create a chart, add maps and graphics, or produce a report. The spreadsheet you see when Quattro Pro opens is one of thousands available in each notebook. Objects sheet The last sheet of every notebook is the Objects sheet. The Objects sheet displays an icon for every chart in the notebook. This sheet also displays icons for custom dialog boxes you build. You can copy, rename, and print items in the Objects sheet.
Macros Macros are computer scripts that automate complex or repetitive command sequences. A macro is a sequence of commands that Quattro Pro runs automatically. Macros can perform keystrokes, mouse actions, and menu commands. You can use macros to automate tasks (such as printing a standard report), enter frequently used labels with a keystroke, or build complete applications to simplify Quattro Pro tasks for other users.
To use Click Database Expert Insert } External data } Expert Map Expert Insert } Graphics } Map Scenario Expert Tools } Scenario } New What-If Expert Tools } Numeric tools } What-If tables Working with toolbars Toolbars give you quick access to the features you frequently use. You can create your own toolbars from a wide assortment of toolbar buttons. Quattro Pro creates a personal toolbar to which you can drag or copy toolbar buttons.
To create a toolbar 1 Click Tools } Customize. 2 Open the Customization menu. 3 Click Toolbar. 4 Click New. 5 Type a name for the toolbar. 6 Click Commands. 7 Choose the commands you want from the Commands list. Each command appears under the appropriate menu name. 8 Drag the commands from the list to the toolbar. To edit a toolbar 1 Click Tools } Customize. 2 Open the Customization menu. 3 Click Toolbar. 4 Enable the check box beside the toolbar you want to customize. 5 Click Commands.
To have a toolbar title display on a floating toolbar, enable the Show title when toolbar is floating check box in the toolbar customization dialog box. To rename a toolbar 1 Click Tools } Customize. 2 Open the Customization menu. 3 Click Toolbar. 4 Select a toolbar. 5 Press F2. 6 Type a new name. You cannot rename system-defined toolbars. To delete a toolbar 1 Click Tools } Customize. 2 Open the Customization menu. 3 Click Toolbar. 4 Select a toolbar. 5 Click Delete.
To display text under all toolbar buttons Right-click a button on a toolbar, and click Customize } Notebook toolbar } Caption below image. To add a toolbar button that launches an application or document 1 Click Tools } Customize. 2 Open the Customization menu. 3 Click Commands, and choose Programs from the list box. 4 Click the Program command category tab. 5 Click Add. 6 In the Target list box, choose the file or application for which you want to create a button.
The QuickCell™ feature is also displayed on the application bar. With QuickCell, you can view a selected cell on the application bar to see its updated value as you change other cells elsewhere in the spreadsheet. To customize the application bar 1 Right-click the application bar, and click Customize } Application bar } Add new command. 2 Select View from the Commands list box. 3 Select a command from the list. 4 Drag the command to the desired position on the application bar.
Navigating in spreadsheets and notebooks You can navigate columns and rows on a spreadsheet using the arrow keys, the ENTER key, and the TAB key. You can also automatically scroll through a spreadsheet using the AutoScroll tool. As well, you can quickly navigate to the Objects sheet and cycle through open notebooks. Menu and dialog box options can be accessed using the keyboard.
To access menu options using the keyboard 1 Press and hold down the ALT key. 2 Type the underlined letter for the menu you want to open. 3 Use the arrow keys to move from menu to menu, and from option to option. 4 Press ENTER to choose a highlighted option. To access dialog box options using the keyboard Press the relevant key combination as outlined in the table below. To Do the following Select options Hold down ALT and type the underlined letter for the option you want.
Selecting cells, rows, and columns You can select cells individually or in rows, columns, blocks, or 3-D blocks. When you select a cell, a black-bordered rectangle appears to indicate the active cell. This rectangle is called the selector. You can set the selector to move when you press the ENTER key. You can select noncontiguous cells, allowing you to write formulas that refer to various selections in different locations.
To change 3-D spreadsheet range syntax 1 Click Tools } Settings. 2 Click Compatibility. 3 In the 3-D syntax area, click one of the following options: A..B:A1..B2 — expresses spreadsheet references first, followed by a colon and the cell coordinates. This syntax makes group references more concise. A:A1..B:B2 — refers to each corner of the 3-D selection with the spreadsheet reference included When you click a new cell, all existing 3-D references in formulas in open notebooks switch to the new syntax.
To lock titles on a spreadsheet 1 Select the top-left cell of the spreadsheet area you want to remain scrollable. 2 Click View } Locked titles. A blue line divides the locked area and the notebook data. The Locked titles option is only available in Draft view. You can display only row titles or only column titles as locked titles by selecting the row or column below or to the right of the last one to be displayed. To unlock titles, click View } Locked titles again.
When you insert a row within the boundaries of a named area or a cell referenced by a formula, the cell references expand to include the new row. You can insert multiple rows by selecting multiple row headings, then clicking Insert } Insert row. To insert a column 1 Select the column heading to the right of where you want the column inserted. 2 Click Insert } Insert column.
If the spreadsheet contains data, pressing END then the DOWN ARROW and RIGHT ARROW keys moves the cursor to the last cell of the block. Keep pressing this combination to move to the last cell in the spreadsheet. Adding, deleting, moving, and copying spreadsheets You can insert or delete single or multiple spreadsheets to or from your notebook. You can move sheets within a notebook or between notebooks to reorder them, using the mouse to drag the spreadsheet tab to another location.
You can also move a spreadsheet by clicking Edit } Move Sheets and specifying the sheets to move. To copy a spreadsheet 1 Hold down CTRL and click the tab of the spreadsheet you want to copy. 2 Drag the spreadsheet tab in any direction until a sheet icon appears. 3 Move the sheet icon by dragging right or left along the row of tabs. 4 Release the mouse button when the sheet icon is where you want to place the spreadsheet.
Pro. Property settings allow you to see at a glance all changes that can be made to individual items in the notebook. You can view statistical information about a Quattro Pro notebook. This includes the filename, directory path, date it was created, date it was last saved and by whom, and the revision number. The notebook summary feature lets you record information, such as a file’s title, subject, author, and keywords. You can also record comments pertaining to the file.
Subject Author Keywords Comments You can also access the Statistics and Summary tabs by clicking Format } Notebook properties. To change compatibility options 1 Click Tools } Settings. 2 Click Compatibility. To change the default file save type 1 Click Tools } Settings. 2 Click Compatibility. 3 Choose a file extension from the Default file type list. To change the default file open type 1 Click Tools } Settings. 2 Click Compatibility.
To change punctuation settings 1 Click Tools } Settings. 2 Click International. 3 Enable the Punctuation option. 4 Select a punctuation option. The options show the punctuation marks used to mark thousands and the decimal place, followed by the punctuation mark used to separate arguments in spreadsheet functions and macros (a1,a2). The last four options specify that a blank space separates thousands in numbers. To change available date formats 1 Click Tools } Settings. 2 Click International.
working with four different notebooks, each dealing with a quarterly report. You can display all four at once. You can select which windows you want open, and how you want to view the data in those windows. As well, there are several methods of rearranging windows on your desktop. You can also hide windows. You can change how you view your notebook without changing the notebook itself.
To select a notebook view 1 Click View. 2 Click one of the following views: Draft — does not display some document elements such as footers, page breaks, and margins, although they may exist in the notebook. Because not all features display, working in Draft view is often faster than working in Page view. Page — displays your notebook pages the way they will look when printed. Page view displays elements such as fonts and appearance features, headers, footers, footnotes, page breaks, and margins.
To split a window into two panes 1 Move the mouse pointer to the lower-right corner of the window over the pane splitter . The pointer changes to a black double-arrow. Depending on where you position the mouse pointer, the double-arrow points horizontally or vertically. 2 Do one of the following: To create horizontal panes, drag the vertical double-arrow upward. Release the mouse button where you want to split the panes. To create vertical panes, drag the horizontal double-arrow to the left.
You can hide scroll bars, tabs, and graphics. You may want to hide parts of the screen in just one notebook, for example, when you are creating a special presentation notebook or form. Displaying only the outlines of graphics (such as charts, clipart, and shapes) allows you to scroll and print faster. You can hide parts of the screen in all future notebooks by setting display options. You can also hide borders and grid lines on a spreadsheet. These options are useful when creating a form.
To hide grid lines on a spreadsheet 1 Click Format } Sheet properties. 2 Click the Display tab. 3 Disable any of the following check boxes: Horizontal Vertical Saving and closing notebooks Each notebook is saved as its own file. The default filename for the first notebook is NOTEBK1.QPW. The first time you save a notebook, you can accept this default filename or rename the file. You also have the option of applying a password to the notebook.
To save a notebook with a password 1 Click File } Save as. 2 Choose the drive and folder where you want to save the file. 3 Type a filename in the Filename box. 4 Enable the Password protect check box. 5 Click Save. 6 Type a password. 7 Type the password again for verification. To save a file with a password after you have saved it previously, click File } Save as, and select Password protect. To specify a default filename extension 1 Click Tools } Settings. 2 Click Compatibility.
If the selection includes hidden rows or columns, the hidden rows or columns are saved in the new file, and remain hidden when you open the file. Some cell names and charts saved in the extracted file may not be meaningful if they refer to cells that were not also extracted. You can delete them, reassign them, or ignore them. To close a notebook Click File } Close. If you have made any changes to the notebook you are prompted to save your work. You can close all open notebooks at once using Close all.
Creating a spreadsheet 3 Quattro Pro contains spreadsheets in a notebook. Once you have created a spreadsheet, you can enter data and perform calculations. For example, you can enter a list of items and the cost of each item and then calculate the total cost of all items.
To create a notebook using a project template 1 Click File } New from project. 2 Click the Create new tab. 3 Select Quattro Pro 10 from the Categories list box. 4 Choose a project from the Projects list. 5 Click Create. 6 Use the PerfectExpert panel to modify the project. To change the size of a notebook 1 Click Tools } Settings. 2 In the list of categories, double-click Workspaces, Application, and click Compatibility. 3 In the Notebook sizes area, type a value in the Sheets box.
as text (202-555-1212, a phone number). A label can begin with any letter, punctuation mark, or symbol, except the following characters: Character Description / forward slash + plus - minus $ dollar sign ( opening parenthesis # number sign . period = equals If you type one of these characters, Quattro Pro treats the information as a formula or value. You can force Quattro Pro to read values as labels by typing an alignment character before the value.
To insert special characters and symbols 1 Click a cell. 2 Click Insert } Symbol. 3 Choose a character set from the Set list box. 4 Choose a character from the Symbols list. 5 Click Insert. You can also insert special characters and symbols by clicking the WP characters button on the property bar. To repeat a character 1 Click a cell. 2 Type \ (backslash character), and type a character. 3 Press ENTER. To repeat a series of characters in a pattern 1 Click a cell. 2 Type \ (backslash character).
formats you set as defaults. Dates or times can be in many formats, such as 04-04-98, 04/04/98, and 01:42:30 PM. Quattro Pro stores all dates as serial integers and times as decimal fractions, so that it can calculate dates and times as values. The minimum serial integer is -109,571, which represents January 1, 1600; the maximum is 474,816, which represents December 31, 3199. The minimum decimal fraction for time is 0.99999 (for the time 23:59:59) and the maximum is 0.000 (for 00:00:00).
To enter a date using the spreadsheet DATE function 1 Click a cell. 2 Click Insert } Insert function. 3 Choose Date from the Function category list. 4 Choose DATE from the Function list. 5 Click OK. 6 Type the date (year, month, and day) between parentheses. 7 Press ENTER. Filling cells and spreadsheet tabs automatically Quattro Pro lets you automatically enter repeated labels and functions. Once the initial letters or sequence you are typing is recognized, the data is automatically inserted.
To fill cells automatically using seed values 1 Type a seed value in a cell. 2 Select the seed value cell and the blank cells you want to fill. 3 Click Edit } Fill } QuickFill. You can also fill cells automatically by clicking the QuickFill notebook toolbar. button on the To fill spreadsheet tabs automatically 1 Select an empty cell. 2 Click Edit } Fill } QuickFill. 3 Choose a list series from the Series name list box. 4 Choose an element from the Series elements list.
Performing running calculations Quattro Pro lets you perform calculations quickly by using preset calculations. You can also total cells in rows or columns. For example, you can calculate totals in a single row, or multiple rows or columns. The row or column cannot contain blank cells, and any labels in the selected cells are treated as zero values. You can also total all cells on multiple spreadsheets and total the subtotals in a column.
You can total several cells in a column by selecting the data plus one blank cell below. For example, to total the values in the cells A1..A3, select A1..A4. The total appears in cell A4. You can also total cells in a column or multiple columns. To total all cells on multiple spreadsheets 1 Select the cells that you want to total on each spreadsheet. 2 Select the same cells on a blank spreadsheet. 3 Click the QuickSum button on the notebook toolbar.
Editing and formatting a spreadsheet 4 Quattro Pro lets you edit and format cells, rows or columns, or an entire spreadsheet. For example, you can copy cells to different parts of a notebook, change the color of a cell or text within the cell, change the text orientation of a cell, and resize rows and columns. You can also create and edit headers, footers, and margins in a spreadsheet.
You can also set protection for individual objects. However, if you disable the sheet protection for objects, Quattro Pro ignores the status of unprotected objects. To protect all spreadsheet cells 1 Click Format } Sheet properties. 2 Click the Protection tab. 3 Enable the Enable cell locking check box. To unlock a cell in a protected spreadsheet 1 Select a cell. 2 Click Format } Selection properties. 3 Click the Constraints tab. 4 In the Cell protection area, enable the Unprotect option.
To edit the content and formatting of a cell 1 Click a cell. 2 Click Edit } Clear, and click one of the following: Cells — lets you erase the content and the formatting of a cell Values — lets you erase the content but not the formatting of a cell Format — lets you erase the formatting but not the content of a cell Clicking Edit } Clear } Format does not affect column width or row height.
Formula — finds data in a formula Value — finds data in a value Condition — compares cells in the spreadsheet with any conditions specified in the Find box 6 Click one of the following buttons: Find next Previous 7 Click Replace. You can also Search down columns before searching across rows Enable the Columns first check box. Find an exact match Enable the Match whole check box. Match the capitalization of the text in the Find box Enable the Case sensitive check box.
When you click an action from the list, all actions performed after that action will be undone. You can also undo multiple actions by clicking the Undo toolbar. flyout on the notebook To redo an action Click Edit } Redo. To redo multiple actions 1 Click Edit, and click the Redo flyout. 2 Click an action from the list. When you click an action from the list, all actions performed after that action will be redone. You can also redo multiple actions by clicking the Redo toolbar.
To create a spreadsheet group 1 Click Insert } Name } Name group of sheets. 2 Enter a group name in the Group name box. 3 Type the name of the first spreadsheet in the First sheet box. 4 Type the name of the last spreadsheet in the Last sheet box. You can also create a spreadsheet group by selecting any cell in the first sheet, holding down SHIFT and clicking the tab of the last spreadsheet to include in the group.
You can copy a cell by holding down CTRL as you drag. To move cells to another spreadsheet by dragging 1 Click Window } New view. 2 Click Window } Tile side to side. 3 In the window view that represents the destination spreadsheet, click the tab for the spreadsheet to which you want to drag the cell. 4 In the window view that represents the source of the cells, select a cell or cells. 5 Point to an edge of the cells until a four-way arrow displays. 6 Drag the cells to the destination area.
To move cells 1 Select the cells to move. 2 Click Edit } Cut. 3 Select the destination cells within the active spreadsheet. 4 Click Edit } Paste. To copy cells to a specified location 1 Click Edit } Copy cells. 2 In the From box, specify the cells to copy. 3 In the To box, specify the destination cells If you copy cells containing absolute references, enable the Model copy check box. Instead of specifying the cells you want to copy, you can press F3 and choose a named cell from the Cell names dialog box.
Columns whose widths you explicitly adjust are not controlled by the default width of the active spreadsheet. Before those columns can be affected by a change in the default width of the active spreadsheet, you must reset the column width of the active cell. You can also return row heights to the active cell default size, which is determined by the largest font used in the row. To change row height 1 Select a cell in each row you want to resize, or select the row borders.
You can also change the default column width by right-clicking a spreadsheet tab and clicking Sheet properties. To increase the column width while typing values 1 Click Tools } Settings. 2 In the list of categories, double-click Workspaces, Application, and click General. 3 Enable the Fit-As-You-Go check box. To restore the active cell default column width 1 Select a cell in each column whose width you want to restore to default. 2 Click Format } Selection properties. 3 Click the Row/column tab.
To increase the row height to fit the tallest entry 1 Select a row. 2 Click the Row QuickFit button on the toolbar. You can also double-click the row letter to increase row height. You can also increase the row height to fit the tallest entry in a selection of cells by selecting a partial row. To adjust the column width and row height simultaneously 1 Select a cell. 2 Click the Column/row QuickFit button on the toolbar.
To turn off QuickFormat, click the QuickFormat button on the toolbar. To apply a predesigned format 1 Select the cells to format. 2 Click Format } SpeedFormat™. 3 Choose a format from the Formats list. You can also apply a predesigned format by clicking the SpeedFormat button on the toolbar. You can revise a predesigned format by disabling any properties that you do not want applied to the cells. To add a format to the predesigned format list 1 Click Format } SpeedFormat.
To enter short lines of text in one cell 1 Click a cell. 2 Type a line of text. 3 Press ALT + ENTER. 4 Continue typing. 5 Press ENTER. To redistribute text over multiple rows or columns 1 Select the first cell to redistribute. 2 Click Format } Text reformat. 3 Select the cells in which you want the redistributed text to appear using the Range picker tool in the Cells box. The first cell you selected to reformat will be the upper-left cell.
To change text font and style 1 Select the cells with text to format. 2 Click Format } Selection properties. 3 Click the Cell font tab. 4 Choose a font face from the Face list. 5 Choose a font size from the Size list box. 6 Open the Color picker, and click a color. If a font face has a TrueType (TT) or Adobe Type Manager (a) symbol beside it, text displays in print as it does on the screen. Font faces with a printer symbol beside them print but may not display in the correct font face on the screen.
To fill the cell background 1 Select a cell. 2 Click Format } Selection properties. 3 Click the Fill/pattern tab. 4 Click a pattern button on the pattern palette. 5 Open the Pattern color picker and click a color. 6 Open the Background color picker and click a background color. To add color to a range of data 1 Click Format } Sheet properties. 2 Click the Conditional color tab. 3 In the Smallest normal value box, type the smallest value to which you want to apply conditional color.
To color-code a spreadsheet tab 1 Click Format } Sheet properties. 2 Click the Tab color tab. 3 Disable the Use system color check box. 4 Open the color picker and click a color on the color palette. You can also color-code a spreadsheet tab by right-clicking a spreadsheet tab, and clicking Sheet properties. To add a border to cells 1 Select the cells to which you want to add a border. 2 Click Format } Selection properties. 3 Click the Border tab.
You can also center data across multiple cells; for example, you can center a title across columns C, D, and E. You can also change the orientation of text in a cell by rotating it horizontally, vertically, or by a specific degree. To align data in a cell 1 Select a cell. 2 Click Format } Selection properties. 3 Click the Alignment tab.
To rotate text 1 Click a cell with text to rotate. 2 Click Format } Selection properties. 3 Click the Alignment tab. 4 In the Orientation area, enable one of the following options: Horizontal — orients text horizontally Vertical — orients text vertically Rotated — rotates text to the degree you specify If you enable the Rotated option, specifying 90 or -90 rotates the text vertically. Working with numeric formats Quattro Pro uses two types of numeric formats: number formats and date/time formats.
To hide zeros on a spreadsheet 1 Click Format } Sheet properties. 2 Click the Display tab. 3 Enable the No option in the Display zeros area. To format dates and times 1 Select a cell to format. 2 Click Format } Selection properties. 3 Click the Numeric format tab.
You can create a horizontal page break by selecting a row and clicking Insert } Page break } Create. You can also insert a hard page break by clicking where you want to insert a page break and pressing CTRL + ENTER. This only applies if you are not in edit mode. To convert soft page breaks to hard page breaks 1 Move the pointer over the displayed page break until it changes to a double arrow 2 Right-click the page break, and click Set hard page break. .
To link the contents of a cell to a header or footer 1 Click File } Page setup. 2 Click the Header/footer tab. 3 In the Header or Footer area, enable the Create check box. 4 Type the cell address preceded by a back slash. For example, \A:A1. You cannot enter text or insert positioning characters on the same line as the cell content. To adjust the space above or below a header or footer 1 Click File } Page setup. 2 Click the Header/footer tab. 3 Type a height value in the Height box.
To change margin settings 1 Click File } Page setup. 2 Click the Print margins tab.
Analyzing data 5 After you have entered, edited, and formatted data, you can perform many powerful functions to summarize data, answer specific questions, and solve problems. In this section, you’ll learn about using statistical analysis tools creating frequency distribution tables performing regression analysis performing matrix operations creating scenarios Using statistical analysis tools Quattro Pro lets you perform a number of advanced statistical, numerical, and financial analysis tasks.
Rank and percentile Sampling t-Test Z-Test To use an analysis tool 1 Click Tools } Numeric tools } Analysis tools. 2 Follow the steps in the Analysis Expert. Before you use an analysis tool, make sure the input cells you are analyzing are arranged properly and contain numeric data, not strings. As well, the analysis tools have varying restrictions on the contents of the input cells and size of the cell area.
To create an XY chart of a frequency distribution, specify the bin cells as the x-axis series and the results as the first series of values. Performing regression analysis Regression analysis answers the question “To what extent can one or more independent variables explain and predict a dependent variable?” By performing regression analysis, you can create a regression analysis table showing how sets of independent variables affect a certain set of dependent variables.
1034 1101 And you can express the results of the equations in this “4 by 1" constant matrix (the first variable is at the top of the list, the second is next, and so on): 10 20 15 6 You can use matrix multiplication and inversion to find the value of each variable in the second matrix that satisfies the constraints in the first matrix. Matrix multiplication is helpful when you need to multiply the elements of one matrix by the elements of a second and sum their products.
or variable values plugged into a model and the values that result. For example, a worst-case scenario shows what you can expect from the least desirable set of variable values; a best-case scenario uses the most desirable values as input. Scenarios are often used to find the optimum solution to a problem. Before using scenarios, you have to create a data model that includes formulas and supporting data. To create a scenario 1 Click Tools } Scenario } New.
Managing files and data 6 File management is an important part of any project. You can open many different file formats in Quattro Pro, and you can import, insert, or combine data. You can also link data between notebooks or between Quattro Pro and another application.
To open a file from the Internet 1 Click File } Open. 2 Type a URL in the Filename box. 3 Click Open. Quattro Pro makes a local copy of the file; you do not have to be continuously connected to the Internet to work with the file. To open a Quicken Interchange Format (.qif) file 1 Click File } Open. 2 Choose the drive and folder where the file is stored. 3 Choose Quicken Interchange Format (.qif) from the File type list box. 4 Double-click the filename. When you open a .
To save a Quattro Pro file in another format 1 Click File } Save as. 2 Choose a file type from the File type list box. 3 Type a filename in the Filename list box. 4 Click Save. The entire file is saved when saving the file in the Microsoft Excel versions 5, 7, and 97 file formats. When saving in any other formats, only the contents of the current sheet (or if it is empty, the first non-empty sheet) are saved. Sending files You can send notebooks to new locations. You can also send notebooks by email.
year-to-date figures from monthly notebooks to create a cumulative notebook showing year-to-date expense totals. To insert a file into a notebook 1 Close the file you want to insert. 2 Click Insert } Insert file. 3 Choose a filename. If you want to insert a file from another application, include its filename extension. 4 Type the cell location before which you want to place the inserted file in the Before sheet box.
To import unformatted text 1 In the source application, select the data to paste into Quattro Pro. 2 Click Edit } Copy. 3 In Quattro Pro, click Edit } Paste special. 4 Choose Unformatted text from the As box. 5 Enable the Paste option. To combine files by using math operations 1 Click File } Open. 2 Choose the drive and folder where the destination notebook is stored. 3 Double-click the filename. This notebook contains the existing values; data in this notebook will be altered.
You can import all the text in a file by clicking Browse and selecting an entire file. on the Text source box The Destination box lists the active cell in the spreadsheet. Instead of specifying all the destination cells, you can specify one cell in which to begin inserting the parsed cells. To customize parse settings for delimited text files 1 Click Tools } Data tools } QuickColumns. 2 Click the Range picker in the Text source box and select the source cells.
Join broken lines at ## characters — unwraps lines before parsing. For example, if the text was generated by an application that wrapped text lines that exceeded 80 characters, enable this check box and type 80. To adjust the column width for imported text 1 Click Tools } Data tools } QuickColumns. 2 Click Format. 3 In the column heading, point to the border until it changes to a double arrow. 4 Drag the border until the column reaches the required width.
This version of Quattro Pro supports OLE 2.0 as a container (client) and server. Quattro Pro also acts as a client and server for OLE 1.0 and DDE. Several Quattro Pro macros can help application developers initiate and conduct DDE exchanges or “conversations.” Application developers can use Quattro Pro macro commands and other features to create and control OLE objects in other applications that support OLE automation as a client. In Quattro Pro, you can link to an object in another application.
Press SHIFT while dragging — embeds the object Press CTRL while dragging — links the object To copy an object to another application 1 Select an object in Quattro Pro. 2 Click Edit } Copy. 3 Open the destination application. 4 In the destination application, select the Paste special option, and choose a Quattro Pro format. To resize an OLE object 1 Right-click an OLE object, and click Properties. 2 Click the OLE tab. 3 Disable the Automatic resizing check box.
Because link statements are not case-sensitive, you can type all parts of the link in either uppercase or lowercase. Do not include blank spaces in any part of the reference. To link notebooks by selecting cells 1 Click File } Open. 2 Choose the drive and folder where the notebook is stored. 3 Double-click the filename. 4 Select a cell. 5 Type a plus sign (+) in the cell. 6 On the application bar, click the name of the supporting file.
To link data between applications 1 In the source application, select the data you want to link to from Quattro Pro. 2 Click Edit } Copy. 3 In Quattro Pro, click the cell where you want to place the linked data. 4 Click Edit } Paste special. 5 Enable the Paste link option. 6 Choose a file format from the As box. You can link contiguous and noncontiguous selections.
Presenting spreadsheet data in a chart Quattro Pro lets you present data graphically by plotting it in a chart. 7 In this section, you’ll learn about creating charts adding titles to charts Creating charts Creating a chart lets you represent spreadsheet data graphically. You can create a chart automatically and have all the chart options chosen for you, or you can create a chart by using the Chart Expert, which guides you through the steps of creating a chart that best suits a data set.
You can also For more information about... In the online Help Index, type...
Summarizing data using CrossTab reports 8 CrossTab reports let you summarize large amounts of data from both spreadsheets created in Quattro Pro and external databases. In this section, you’ll learn about creating CrossTab reports creating CrossTab reports using OLAP data sources naming CrossTab reports formatting CrossTab reports updating and refreshing CrossTab report data Creating CrossTab reports You can use CrossTab reports to analyze and organize data located in notebooks and databases.
To build a CrossTab report 1 Click a spreadsheet cell containing data. 2 Click Tools } Data tools } CrossTab } Report. 3 Drag any fields from the list in the Fields area into any of the following positions of the Layout area: Rows Columns Data Pages 4 Type the report destination in the Destination box. Unless you select a destination, the CrossTab report will be placed in A1 of the next available, unprotected spreadsheet.
To import OLAP CrossTab reports 1 Click Tools } Data tools } CrossTab } Report. 2 Enable the OLAP report option. 3 Click OK. 4 In the CrossTab data sources dialog box, select the server you want. 5 In the Connect to provider dialog box, type a user ID and password. 6 Select a data source. 7 In the CrossTab report dialog box, click Import report. 8 In the Import templates dialog box, choose a report type. 9 In the Import report dialog box, choose a report.
To customize the appearance of a CrossTab report 1 Click Tools } Data tools } CrossTab } Options. 2 Enable any of the following check boxes: Format CrossTab report — applies a preset format to the fields and data, making the report easier to read Preserve data formatting — maintains the numeric format of the source data, such as currency Center labels across blocks of cells — centers the field names (labels) across the column of data. (By default, field names are right-aligned).
Index: Quattro Pro 10 ! .QIF . . . .QPX . . . .XLS . . . 3-D blocks . range syntax selecting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220 224 178 165 165 165 A accounting style lines . . . . . . actions redoing. . . . . . reversing . . . . . undoing . . . . . adding subtitles to charts . . . titles to charts . . . . aligning center . . . . . . CrossTab report data fields data . . . . . . footers . . .
C Calc-As-You-Go . . . . . . . . . . . 189 disabling . . . . . . . . . . . . 189 calculating columns . . . . . . . . . . . . 187 joined cells. . . . . . . . . . . . 203 subtotals . . . . . . . . . . . . 189 using QuickFunctions . . . . . . . . . 188 calculations preset . . . . . . . . . . . . . 188 running . . . . . . . . . . . . 189 simple . . . . . . . . . . . . . 187 viewing. . . . . . . . . . . . . 189 cell backgrounds filling . . . . . . . . . . . . . 204 cell borders . . . . . . . . . . . .
coloring data ranges . . . . spreadsheet tabs . . . colors adding . . . . . . changing text . . . . column width adjusting . . . . . changing . . . . . changing default . . . increasing . . . . . restoring default . . . columns adding . . . . . . CrossTab reports . . . deleting . . . . . delimiters . . . . . filling . . . . . . hiding . . . . . . inserting . . . . . joining cells . . . . navigating . . . . . parsing . . . . . QuickFill . . . . . resizing . . . . . restricting . . . . revealing . . . . .
data analysis . . . data models scenarions . . . . data ranges coloring . . . . data types changing color . . . database files opening . . . . saving . . . . . databases . . . . . multidimensional . . relational . . . . using OLAP. . . . date formats . . . . DATE function . . . dates current . . . . . entering . . . . formatting . . . . in footers . . . . in headers . . . . international settings . printing . . . . spreadsheet functions . DDE . . . . . . decimal format . . . default column width. .
saving . . . . . . . . . . . . . 221 File menu . . . . . . . . . . . . . 150 files backing up . . . . . . . . . . 178 - 179 combining . . . . . . . . . . . . 221 extracting . . . . . . . . . . . . 179 importing . . . . . . . . . . . 219,221 inserting. . . . . . . . . . 219,221 - 222 managing . . . . . . . . . . . . 219 new . . . . . . . . . . . . . 181 OLE. . . . . . . . . . . . . . 219 sending . . . . . . . . . . . . 221 filling cells . . . . . . . . . . . . . 205 using QuickFill . . . . . . . . . . .
group name . . . . . . . . . . . . 195 grouped spreadsheets deleting . . . . . . . . . . . . 196 grouping spreadsheets . . . . . . . . . . 195 - 196 H hard page breaks removing . . . . . . . . . . . . 210 setting . . . . . . . . . . . . . 210 header codes . . . . . . . . . . . . 210 headers adjusting height . . . . . . . . . . 211 creating . . . . . . . . . . . . 210 editing . . . . . . . . . . . . . 211 formatting . . . . . . . . . . . . 210 inserting . . . . . . . . . . . . 210 linking cells . . . . . .
L labels aligning . . . . . . . . . . . . 183 changing from values . . . . . . . . . 183 creating . . . . . . . . . . . . 183 text reformat . . . . . . . . . . . 202 wrapping . . . . . . . . . . . . 202 language international settings . . . . . . . . 170,173 LICS international settings . . . . . . . . . 173 linear model . . . . . . . . . . . . 215 linear relationship . . . . . . . . . . 215 lines adding grand total . . . . . . . . . . 206 adding total . . . . . . . . . . . 206 double . . . . . . . . . . .
hyperlinks . . . . . . . . . . . . 229 Internet links . . . . . . . . . . . 229 pasting . . . . . . . . . . . 228 - 229 supporting files . . . . . . . . . . 227 updating . . . . . . . . . . . . 227 using wildcards . . . . . . . . . . 228 notebooks changing size . . . . . . . . . . . 182 closing. . . . . . . . . . . . 178,180 components . . . . . . . . . . . 155 creating . . . . . . . . . . . 181 - 182 cycling through open . . . . . . . . . 163 dragging cells . . . . . . . . . . . 196 editing . . . . . . . .
columns . . . . . . . . . . . . 223 customizing . . . . . . . . . . . 224 delimited text . . . . . . . . . . . 224 fixed-width text . . . . . . . . . . 224 loading settings . . . . . . . . . . 224 rows . . . . . . . . . . . . 223,225 saving settings . . . . . . . . . . . 224 text files . . . . . . . . . . . . 222 Paste special . . . . . . . . . 193,197 - 198 pasting cells . . . . . . . . . . . . 197 - 198 in group mode . . . . . . . . . . . 196 notebook links . . . . . . . . .
columns . . . . . data . . . . . . rows . . . . . . revealing columns . . . . . rows . . . . . . screen components . . reversing action . . . . . . actions . . . . . rotating alignment . . . . . cells . . . . . . horizontally . . . . text. . . . . . . text vertically . . . . vertically . . . . . rotations . . . . . . row height adjusting . . . . . changing . . . . . increasing . . . . . restoring default . . . rows adding . . . . . . CrossTab reports . . . deleting . . . . . filling . . . . . . hiding . . .
soft page breaks . . . solving equations . . . . source data creating . . . . CrossTab reports . . spacing footers . . . . . headers . . . . special characters accessing . . . . copyright symbol . . iconic symbols . . . icons . . . . . inserting . . . . languages . . . . phonetic characters . repeat characters . . WordPerfect characters SpeedFormat . . . SpeedSelect selecting data . . . spreadsheet functions date . . . . . spreadsheet groups copying to . . . . creating . . . . deleting . . . . editing . . .
parsing . . . . . . . QuickColumns . . . . . . QuickColumns, importing text files text font changing . . . . . . . text orientation . . . . . . Text Reformat. . . . . . . text style changing . . . . . . . time international settings . . . . time formats . . . . . . . times entering . . . . . . . formatting . . . . . . . in footers . . . . . . . in headers . . . . . . . international settings . . . . titles across cells . . . . . . . adding to charts . . . . . charts . . . . . . . . locking . . . . . . . .
selecting . . . types . . . . zoom . . . . View menu . . . viewing calculations . . comments . . . margins . . . page breaks . . spreadsheet groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 173 173 151 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189 173 211 209 196 . . . . . . 229 . . . . . . . . . . . . . . . . . . . . . . . . 201 . 199 . 198 . 199 198,200 . 199 . 198 .
Section 4 Corel Presentations 10
Table of contents: Corel Presentations 10 Welcome to Corel Presentations 10 . . What’s new in Corel Presentations 10 . . What’s different in Corel Presentations 10 . Creating slide shows and drawings Using slide show views . . Opening new slide shows . Saving slide shows . . . Working with the Slide Outliner Adding and removing slides . Working with the Slide Sorter Creating portable slide shows . Creating and saving drawings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Working with titles and subtitles . . . Formatting the appearance of titles and subtitles Changing the line spacing in titles and subtitles . Working with objects . . . . Selecting objects . . . . . Resizing objects. . . . . . Flipping, rotating, and skewing objects . Applying color and outlines to objects . Applying effects to objects . . . Animating objects . . . . . Playing slide shows . Playing slide shows . . . . . . Drawing and editing shapes Drawing shapes . Editing shapes . . . . .
Working with datasheet cells . . . . . Working with rows and columns in datasheets . Using formulas and number fills in datasheets . Working with organization charts. . . . . . . . . . . . . . Creating and saving organization charts . . . . . Adding and editing text in organization charts . . . . Adding and replacing positions in organization charts . . Viewing organization charts . . . . . . . . Changing organization chart branch structures and orientation Printing in Corel Presentations .
Welcome to Corel Presentations 10 1 Corel Presentations lets you create high-quality slide shows and drawings that can include text, data charts, organization charts, and graphic objects. You can use Corel Presentations to produce professional-looking project proposals, interactive demonstrations, multimedia presentations, flyers, signs, banners, and more. Slide shows can be presented on large monitors, portable computers, overhead transparencies, 35mm slides, or printed in color or black-and-white.
With the last option, there is no guarantee that you can recover any work in your document after the last time you saved or that you can keep the program open. After you have made your selection, you can report the details of the problem to Corel with an attached program log. Your report will be a vital part of Corel’s product improvement efforts. Animation with sound You can now attach a sound file to an animation used in a slide show, to include sound with the animation.
What’s different in Corel Presentations 10 This section summarizes a few of the changes made in Corel Presentations 10. Enhanced Microsoft PowerPoint filter Both the import and export filters for Microsoft® Power Point® 95 and 97 have been enhanced to provide better support for such items as bulleted text, titles, subtitles, background layers, and fonts.
Creating slide shows and drawings 2 Corel Presentations 10 includes comprehensive slide show tools that allow you to create professional-looking slide shows and drawings.
You can also change the slide show view by clicking the Slide Editor, Slide Outliner, or Slide Sorter tab on the right side of the slide show window. Opening new slide shows A slide show project is a predefined slide show that includes a prepared layout and outline. All you need to do is type in data. You can design your own slide show or start a slide show from a predefined slide show project. To open a new blank slide show 1 Click File } New. 2 Choose a slide show from the Category list box.
The following image shows how the Slide Outliner can be used to view and create 1) a slide outline 2) a slide To create a slide show outline 1 Click View } Slide Outliner. 2 Type a title in the slide show, and press ENTER. 3 Type a subtitle in the slide show, and press ENTER. 4 Type any text in the slide show. 5 Click Insert } New slide. 6 In the New slide dialog box, click a slide layout on the Layout palette.
The following image shows how the Slide Sorter lets you rearrange the order of slides in a slide show. A slide show consists of a series of slides presented in succession using slide transitions. Slide transitions control how each slide is introduced, creating a smooth visual progression for the audience. The default transition displays slides and the objects on the slide at the same time, but you can choose to display them separately.
2 Click a slide. 3 Click Format } Slide properties } Transition. 4 Choose a transition effect from the Effects list. 5 Choose a transition direction from the Direction list. 6 In the Speed area, enable one of the following options: Fast Medium Slow If you want to apply the slide transition to an entire slide show, enable the Apply to all slides in slide show check box. You can also Show only transitions with Flash format Enable the Show only Flash-enabled transitions check box.
You can save Corel Presentations drawings in various file formats such as a WordPerfect graphic, Windows bitmap, JPG, and GIF. This allows you to use the drawings you create in other applications, such as WordPerfect documents, or in Web pages. To create a drawing 1 Click File } New from project. 2 Click the Create new tab. 3 Choose Corel Presentations 10 from the list box. 4 Choose Corel Presentations drawing from the list. 5 Click Create. To save a drawing for the first time 1 Click File } Save.
Setting up rulers, grids, and guidelines 3 You can use several visual aids, such as rulers, gridlines, alignment guides, and crosshairs, to help you place objects precisely on slides or drawings. In this section, you’ll learn about setting up rulers setting up grid lines setting up alignment guides Setting up rulers You can display or hide rulers on the horizontal and vertical axes in a slide show or drawing.
To display or hide alignment guides Click View } Grid/guides/snap } Display guides. A check mark beside the Display guides menu command indicates that the alignment guides are displayed. To create an alignment guide 1 Click View } Ruler. 2 Drag from the horizontal or vertical ruler to a position on the slide or drawing. The ruler must be displayed to create an alignment guide. From here For more information about... In the online Help Index, type...
Working with the Master Gallery 4 A master is a set of layouts and backgrounds. A layout is a slide with preset placeholders for objects such as titles, subtitles, bulleted lists, text, data charts, and organization charts. Each layout has a page format and color scheme that is consistent with the other layouts and backgrounds that are part of a master. A background can include a border, a gradient background, and other related images.
To use a master in the Master Gallery 1 Click Format } Master Gallery. 2 Choose a slide show category from the Category list box. 3 Click a master on the Selected style palette. Applying backgrounds and layouts to slides When you add a new slide to a slide show, you can apply preset backgrounds and layouts from the Background Gallery and the Layout Gallery.
When you insert a text object, such as a text box or a text line, into a slide show layout, you must type placeholder text in it. To create a slide show background 1 Click Edit } Background layer. 2 Click Insert } New background. 3 Type a background name in the Name box. 4 Click OK. 5 Insert any objects into the background. From here For more information about... In the online Help Index, type...
Working with text You can customize the appearance of slides with a variety of text objects. 5 In this section, you’ll learn about creating text objects setting text attributes formatting text in text objects Creating text objects You can create text objects by inserting text boxes, text lines, and TextArt®. Text boxes expand in length and text lines expand in width to contain text as you type. For information about TextArt, see “Working with TextArt images” in the online Help.
8 Type any text in the Type here box. 9 Click Insert symbol. Setting text attributes You can customize the text in a slide show or drawing by setting text attributes. You can change the font by using a variety of font types, sizes, and colors. For example, you can use Arial font, in 12 point size and in red. You can also apply a style, such as bold, italic, or underlined. As well, you can apply an outline to text. To change the font of text 1 Double-click a text object. 2 Select the text.
You can adjust the spacing between lines of text. To move text 1 Double-click a text object. 2 Select the text. 3 Drag the selected text to a new position inside the selected text object. To delete text 1 Double-click a text object. 2 Select the text. 3 Click Edit } Delete. To justify text 1 Click a text box.
Working with bulleted lists 6 You can create bulleted lists in Corel Presentations to effectively communicate sequential ideas within drawings and slide shows. In this section, you’ll learn about creating bulleted lists modifying bulleted list text attributes formatting bulleted lists changing line spacing in bulleted lists animating bulleted lists Creating bulleted lists Keep the following points in mind when you create any type of bulleted list: Express a single idea on each line.
To move an existing bulleted list item up one level 1 Double-click a bulleted list. 2 Click at the beginning of a list item. 3 Press SHIFT + TAB. Modifying bulleted list text attributes You can customize the appearance of text and bullets within a bulleted list, including the font size, color, and attributes of text, and the outline of font. To change the appearance of text in a bulleted list level 1 Click a bulleted list. 2 Click Format } Bulleted list properties. 3 Click the Fonts tab.
2 Click Format } Bulleted list properties. 3 Click the Bullets tab. 4 Choose a list level from the list. 5 Choose a position from the Justification list box. To change the shape of a bullet 1 Click a bulleted list. 2 Click Format } Bulleted list properties. 3 Click the Bullets tab. 4 Choose a list level from the list. 5 Choose a bullet shape from the Bullet shape list box. Changing line spacing in bulleted lists You can change the amount of line spacing in a bulleted list.
2 Click the Bulleted list layout on the Layout palette, and click OK. 3 Create the bulleted list, and click Format } Bulleted list properties. 4 Click the Bullet animation tab. 5 In the Animation type area, enable one of the following options: Animate object in place Animate object across screen If you are publishing the slide show using Flash, enable the Show only Flash enabled transitions check box. 6 Choose an animation effect from the Effects list.
Working with titles and subtitles 7 In Corel Presentations, when slides with layouts are inserted into a slide show, they are automatically created with placeholders for titles and subtitles. For more information about slide show layouts, see “Applying backgrounds and layouts to slides” on page 270.
To change the font outline of a title or subtitle 1 Click a title or subtitle. 2 Click Format, and click one of the following: Title properties Subtitle properties 3 Click the Fonts tab. 4 In the Appearance area, click Font properties. 5 In the Font properties dialog box, click the Outline tab. 6 Open the Color picker, and click a color. 7 Open the Style picker, and click a line style. 8 Open the Width picker, and click a line width.
Working with objects 8 All of the elements that you add to slides, including text, clipart, shapes, charts, and bitmapped images, are treated as objects in Corel Presentations 10. In this section you’ll learn about selecting objects resizing objects flipping, rotating, and skewing objects applying color and outlines to objects applying effects to objects Selecting objects You must select an object before you can arrange, edit, or move it.
To size an object proportionately 1 Click an object. 2 Drag a corner handle until the object is the size you want. You can also size an object proportionately by holding down ALT while dragging any handle until the object is the size you want. To stretch an object 1 Click an object. 2 Drag a side handle until you achieve the effect you want. Flipping, rotating, and skewing objects You can flip, rotate, and skew objects in the drawing window.
To apply a custom color to an object 1 Click an object. 2 Click one of the following buttons on the tool palette: Foreground fill Background fill 3 Click More. 4 In the Select color dialog box, choose a color model from the Color model list box. 5 Click a color on the color wheel. 6 Click a color on the color swatch. You can also choose a color by typing values in the Red, Green, and Blue boxes in the Color values area. To outline an object 1 Click an object.
To animate an object 1 Click an object. 2 Click Format } Object properties } Object animation. 3 In the Animation type area, enable one of the following options: Animate object in place — animates the object in place on the slide Animate object across screen — animates the object by moving it across the slide If you want to show animation in Flash format, enable the Show only Flash-enabled transitions check box. 4 Choose an animation effect from the Effects list.
From here For more information about... In the online Help Index, type...
Playing slide shows 9 Once you create a slide show, different options are available to play it in Corel Presentations 10. In this section, you’ll learn about playing slide shows Playing slide shows There are different ways to play slide shows in Corel Presentations. You can play a slide show by manually controlling the display of each slide. A slide show can also be played automatically, with each slide displayed in succession and where you can control the time delay between the display of each slide.
The time delay begins the second the first slide displays on the screen. Time delays also apply to animated images. For example, if you set a two-second time delay for a slide, the first animated object automatically displays two seconds after the slide appears. The next animated object follows two seconds later, and so on. Two seconds after the last animated object displays, the show advances to the next slide.
Drawing and editing shapes 10 You can enhance Corel Presentations slides and drawings with seven categories of preset shapes: line, basic, arrow, flowchart, star, callout, and action. In this section you’ll learn about drawing shapes editing shapes Drawing shapes Line shapes can be everything from a simple line to a polyline. You can draw lines and polylines, and you can draw curves.
To draw a curve 1 Click Insert } Shape } Line Shapes } Curve. 2 Click once in the drawing or slide show window. 3 Drag to start the curved line. 4 Click to create the first section of the curve. 5 Drag to continue the curve. 6 Double-click to complete the curve.
To size a shape by using a glyph 1 Click a shape. 2 Drag a glyph until the shape is the size you want. To change the shape of a line or polyline 1 Click a line or polyline. 2 Click Edit } Edit points. 3 Drag the edit points until the shape is the size you want. Edit points are specific to lines and polylines. If you want to access the edit points of a shape other than a line or polyline, you must first convert the shape to a polygon.
Working with bitmapped images You can create bitmapped images and add them to slide shows and drawings. 11 In this section, you’ll learn about creating and saving bitmapped images modifying bitmapped images creating original artwork using special effects Creating and saving bitmapped images You can create new, original bitmapped images using the Bitmap Editor. You can also save a new bitmapped image. To create a bitmapped image 1 Click Insert } Graphics } Bitmap.
Modifying bitmapped images Modifying bitmapped images in Corel Presentations can be done with precision. You can refine small details, make drastic changes, and intensify effects on the bitmapped image as a whole. You can select a specific area of the bitmapped image to modify. You can size the frame around the graphic, which is useful if you want to eliminate white space around a bitmapped image.
To size the frame around a bitmapped image To Do the following Size the frame around a bitmapped image Double-click the bitmapped image, and drag the side or corner handles to resize the frame. Size the frame around a rotated or skewed bitmapped image Click Tools } Convert to bitmap. Click OK. Double-click the bitmapped image, and drag the side or corner handles to resize the frame.
3 Click Format } Brush. 4 In the Brush attributes dialog box, choose a brush shape from the Brush shape list box. 5 Type a value in the Brush width box. 6 Click OK. 7 Open the Fill Pattern picker on the tool palette, and click a pattern. 8 Open the following pickers on the tool palette, and click a color: Foreground fill Background fill 9 Click the bitmapped image. To paint the complete area of a bitmapped image 1 Double-click a bitmapped image. 2 Click Insert } Flood fill.
8 Open the Background fill picker on the tool palette, and click a color. 9 Click the bitmapped image where you want to replace the color. To select a transparent color for a bitmapped image 1 Double-click a bitmapped image. 2 Click Format } Set transparent color. 3 Click a color on the palette. Using special effects Corel Presentations includes a variety of special effects that you can add to bitmapped images.
Adding multimedia effects You can add sounds and movies to slide shows in Corel Presentations 10. 12 In this section, you’ll learn about working with sounds in slide shows working with movies in slide shows Working with sounds in slide shows Once you have correctly installed and set up sound hardware on your computer, you can add Wave (.Wav) and MIDI (.Mid) sound files to slides. You can add an entire CD track or only sections of a track to slides by choosing specific starting and stopping points.
You can only play one .Mid and one .Wav file at the same time. You cannot play two sound files of the same type simultaneously. To get the best results from the MIDI sound files that are included with Corel Presentations, make sure that your system is set up correctly for your sound card. To add an entire CD track to a slide 1 Click Insert } Sound. 2 Click Browse beside the CD box. 3 In the Slide CD — Audio dialog box, type a track description in the Description box.
The following image shows that you can add movie files to slide shows. To add a movie file to a slide show 1 Click Insert Movie. 2 Choose the drive and folder where the file is stored. If you want to save the movie within the slide show, enable the Save movie within slide show document check box. 3 Choose a file type from the File type list box. 4 Type a filename in the Filename box. 5 Click Insert. To insert .Mov and .
Working with data charts 13 You can use Corel Presentations to create and update various types of data charts. In this section, you’ll learn about creating data charts sizing and moving data charts adding legends to data charts adding titles to data charts labeling data charts Creating data charts You can create different types of data charts in Corel Presentations using a collection of predesigned chart templates and color schemes.
Bar, and choose a bar shape from the Bar shape list Line Line and marker Marker, click a marker shape in the Marker shape area, and type a value in the Marker size box 7 In the Axis area, enable one of the following options: Primary (y1) Secondary (y2) It is recommended that you use no more than eight series when you create a bar chart. Sizing and moving data charts You can change the size of a data chart proportionally, and you can stretch or shrink a data chart.
Display the legend inside the data chart Enable the Place legend inside chart check box. Adding titles to data charts You can add a title and subtitle in a data chart. To add a data chart title 1 Double-click a data chart. 2 Click Chart } Title. 3 Click the Title options tab. 4 Enable the Display chart title check box, and type a chart title name in the box. 5 Enable an option in the Position area. To add a data chart subtitle 1 Double-click a data chart. 2 Click Chart } Subtitle.
From here For more information about... In the online Help Index, type...
Working with datasheets 14 The datasheet is a spreadsheet that is used to enter, edit, or format the data that a data chart displays. In this section, you’ll learn about manipulating datasheets adding and copying data in datasheets working with datasheet cells working with rows and columns using formulas and number fills Manipulating datasheets When you have finished entering data in a datasheet, you can hide the datasheet.
The following image shows what a datasheet looks like. You can also import spreadsheet data from files created in other applications into a data chart. If you link the imported data to a chart, any changes you make to the chart data in a spreadsheet application, such as Quattro Pro, are automatically updated in the Corel Presentations chart data every time you open the chart. As well, you can export a datasheet data. To enter or edit data 1 Click a cell on a datasheet. 2 Click Edit } Edit cell.
4 Choose a file format and delimiter type from the File type list box. 5 Type a filename in the Filename box. 6 Click Export. Working with datasheet cells The Corel Presentations datasheet consists of a series of cells in which you enter or edit chart data. You can select all of the cells in a datasheet. By highlighting each area with a color in the range highlighter, you can distinguish between datasheet data and the legend and label areas in the datasheet.
To delete a row or column 1 Click a datasheet cell. 2 Click Edit } Delete. 3 Enable one of the following options: Row Column 4 Type a value in the Number to delete box. Using formulas and number fills in datasheets You can apply formulas while working in a datasheet. You can perform several functions that are found in spreadsheet programs such as Quattro Pro. For a list of the available formulas, see “Reference: Working with datasheets” in the online Help. The results are reflected in the data chart.
Columns 4 In the Type area, enable one of the following options: Linear Growth Date, and choose a date/time interval from the list box beside it 5 In the Values area, type a value for the series in the Start box. 6 In the Step box, type a value to indicate the rate of increase for the series. When you enter two-digit years (dd/mm/yy) in a datasheet, 00 to 50 corresponds to the years 2000 to 2050, and 51 to 99 corresponds to the years 1951 to 1999.
Working with organization charts 15 Organization charts can be used to show an organization’s structure or the relationships of people and positions. For example, you can use organization charts to create family trees, show a chain of command, diagram a process, or illustrate a workflow.
Try to start each box the same way, for example, with either a position title or a person’s name. There are many different pre-defined organization chart layouts to choose from when you create an organization chart. The layout determines the structure and orientation of an organization chart. You can save an organization chart style so that you can use the same box options and attributes, font properties, and other chart characteristics for other organization charts.
To add a staff or subordinate position to an organization chart 1 Double-click an organization chart. 2 Click a box. 3 Click Insert, and click one of the following: Staff Subordinate(s) 4 Type a value in the Number to insert box. To add a coworker position to an organization chart 1 Double-click an organization chart. 2 Click a box. 3 Click Insert } Coworkers. 4 Type a value in the Number of coworkers to insert box.
In organization charts, manager positions are represented by the highest boxes in the chart, subordinate and staff positions by the next level of boxes, and coworker positions by the lowest level of boxes. To display or hide a subordinate position 1 Double-click an organization chart. 2 Click a subordinate position box.
To change a branch structure in an organization chart 1 Double-click an organization chart. 2 Click a manager or subordinate box. 3 Click Format } Branch structure. 4 Click the Structure tab. 5 Click one of the following: Single Staggered Left/top Right/bottom Multiple, and type a value in the Columns box 6 Click Close. To change a branch orientation in an organization chart 1 Click a manager or subordinate box. 2 Click Format } Orientation. 3 Click the Orientation tab.
From here For more information about... In the online Help Index, type...
Printing in Corel Presentations 16 Extensive printing options designed for both desktop and commercial printing are available in Corel Presentations 10. In this section, you’ll learn about printing slide shows and drawings Printing slide shows and drawings Before printing a slide show or drawing, you can preview the job to see how it will look when printed. You can print an entire slide show or drawing, a range of slides or pages, a specific slide or page, or selected objects on a slide or page.
You can also close the preview window by pressing ESC. You can also preview a print job by clicking the Mini preview button dialog box. in the Print To print a slide show or drawing 1 Click File } Print. 2 Click the Main tab. 3 In the Destination area, choose a printer from the Name list box. 4 Type a value in the Number of copies box. 5 Click Print. You can also Print the current page or slide only In the Print range area, enable the Current view option.
From here For more information about... In the online Help Index, type...
Internet and electronic publishing 17 You can use Corel Presentations 10 to publish slides and drawings to the World Wide Web. In this section, you’ll learn about publishing slides and drawings as HTML documents publishing to Portable Document Format (PDF) sending slide shows to other applications Publishing slides and drawings as HTML documents You can publish Corel Presentations slide shows as HTML documents, so that you can publish them to the World Wide Web, using Corel Internet Publisher.
Publishing to Portable Document Format (PDF) Publishing a slide show as an electronic document in Portable Document Format (PDF) preserves the typography, images, graphics, color, and formatting of the original publication. PDF also allows you flexibility to specify text formatting, color model, and compression options.
To send a slide show to WordPerfect 1 Click File } Send to } WordPerfect.
Index: Corel Presentations 10 ! .chs files . .mid files . .mov files . .mpeg files .wav files . .wpg files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . A . . . . . . . . . . . . . . . . . . 316 301 303 303 301 295 accessibility . . . . . . . . . . . . 257 action shapes drawing . . . . . . . . . . . . 292 adding coworker positions to organization charts . . . 317 data to datasheets . . . . . . . . . .
saving . . . . . . . . selecting areas . . . . . . selecting transparent colors . . selectively replacing colors . . sizing frames . . . . . . working with . . . . . . zooming . . . . . . . blank opening slide shows . . . . blur effect. . . . . . . . bold applying to text . . . . . branch orientation bottom to top . . . . . . changing organization charts . . left to right . . . . . . right to left . . . . . . top to bottom . . . . . . branch structures changing in organization charts . left/top . . . . . .
adding formulas . . . . . . . . . . 312 deleting from datasheets . . . . . . . . 312 inserting in datasheets. . . . . . . . . 311 working with in datasheets . . . . . . . 311 complete area painting bitmapped images . . . . . . . 298 configuring printer settings . . . . . . . . . . 321 contrast effect . . . . . . . . . . . 299 copies rotating objects . . . . . . . . . . 284 copying data in datasheets . . . . . . . . . . 309 unique colors in bitmapped images . . . . . 298 Corel Application Recovery Manager. .
highlighting ranges of cells . . importing spreadsheet data . . inserting columns . . . . . inserting rows . . . . . . manipulating . . . . . . moving . . . . . . . . moving to cells. . . . . . selecting all cells . . . . . sizing . . . . . . . . using formulas . . . . . . using number fills . . . . . viewing. . . . . . . . working with cells . . . . . working with rows and columns . deleting rows and columns from datasheets slide show layouts . . . . . slides . . . . . . . . text. . . . . . . . .
formatting appearance of titles and subtitles bulleted lists . . . . . text in text objects. . . . formulas adding to datasheet columns . adding to datasheet rows . . using in datasheets . . . frames sizing around bitmapped images freehand shapes drawing . . . . . . G GIF . . . . . glyphs using to size shapes gridlines displaying . . . hiding . . . . setting up . . . grids setting up . . . guidelines setting up . . . guides creating alignment . displaying alignment hiding alignment .
datasheets . . . . . . manually playing slide shows . . . Master Gallery using masters . . . . . masters applying to slides . . . . using . . . . . . . Microsoft PowerPoint filter . . MIDI sound files inserting into slides . . . mixed charts . . . . . . modifying bitmapped images . . . . bulleted list text attributes . mosaic effect . . . . . . movies adding movie files to slide shows saving within slide shows . . working with in slide shows . moving bulleted list items up levels . datasheets . . . . . .
P paint brush tool . . . . . . . . . . . 297 painting complete area of bitmapped images . . . . . 298 specific areas of bitmapped images . . . . . 297 PDF publishing . . . . . . . . . . . . 326 publishing slide shows. . . . . . . . . 326 support . . . . . . . . . . . . 259 PerfectExpert . . . . . . . . . . . . 259 pickup color tool . . . . . . . . . . . 298 pie charts . . . . . . . . . . . . . 305 playing portable slide shows . . . . . . . . . 290 slide shows . . . . . . . . . . .
working with in datasheets rulers displaying . . . . . hiding . . . . . . setting up . . . . . S . . . . . . . 311 . . . . . . . . . . . . . . . . . . . . . 267 267 267 saturation effect . . . . . . . . . . . 299 saving bitmapped images . . . . . . . . . . 295 drawings . . . . . . . . . . . . 265 drawings for the first time . . . . . . . . 266 movies within slide shows . . . . . . . . 303 organization chart styles . . . . . . . . 316 organization charts . . . . . . . . . 315 slide shows .
adding entire CD tracks . . . . adding parts of CD tracks . . . . applying backgrounds . . . . . applying layouts . . . . . . applying masters . . . . . . applying time delays . . . . . applying transitions . . . . . deleting . . . . . . . . inserting MIDI sound files . . . . inserting Wave sound files. . . . publishing as HTML documents . . publishing to the Web . . . . . removing . . . . . . . . selecting all objects . . . . . sorting . . . . . . . . . turning off transitions . . . . . smooth effect. . .
trace contour effect . . . . tracks adding parts to slides . . . adding to slides . . . . transforming polylines into circles . . . transitions applying to slides . . . . turning off slides . . . . transparent colors selecting for bitmapped images turning off slide transitions . . . . . . . . . . 299 . . . . . . . . . . . . 302 302 . . . . . . 291 . . . . . . . . . . . . 264 265 . . . . . . 299 . . . . . . 265 U underlining text. . . . . . . .
Section 5 Paradox 10
Table of Contents: Paradox 10 Welcome to Paradox 10 . . What’s new in Paradox 10? . . Introduction to relational databases Database terminology . . . Exploring Paradox . The desktop . . The Welcome screen. . . . Planning your database . . . . . . . . . . . . . . . . . . . . . Creating a report . . . Table of contents: Paradox 10 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353 . . . . . . . . . . .
Creating mailing labels . . . Adding text and graphics to reports Moving or deleting objects . . Changing the color of objects . . Adding a chart to a report . . Previewing a report . . . . Printing a report . . . . Working with queries . . Using Query By Example . . Saving queries . . . . Creating multi-table BE queries Creating advanced QBE queries Query operators . . . Working with ObjectPAL . . . . . . . . . . . . . . . . . . Object-based . . . . . Event-driven . . . . . Methods . . . . . .
Welcome to Paradox 10 1 Paradox is a powerful and easy-to-use relational database program that helps you organize, track and retrieve information through the creation of tables and records. You can also create sophisticated forms, charts, queries, and reports to display your information. You can run Paradox as a standalone system on a single computer, or as a multi-user system on a network.
Reports can now be published interactively and through ObjectPAL to many different file formats, including WordPerfect 6 and later, Microsoft Word 95, 97, and 2000, HTML, Rich Text Format, and plain text. HotKey assignment mechanism Allows the easy creation of hotkeys without the need for an ObjectPAL based solution.
The following image illustrates a database structure. Database terminology The following terms will give you a better understanding of database concepts and the features of Paradox. Term Definition Data The values (words or numbers) that are stored in your database. Record A horizontal row in a table that contains a group of related fields of data. Field A column of information in a table. A collection of related fields makes up one record.
Exploring Paradox 2 This chapter guides you through the main windows used in Paradox and identifies the various features you can use to create and maintain your database. The desktop The following image illustrates the components of the Paradox desktop. 1 - menu bar ¾ appears directly below the title bar and displays Paradox menus. Clicking a menu name displays a list of commands. 2 - toolbars ¾ appears below the menu bar and displays the main set of Paradox tools.
Using the Project Viewer Paradox treats each database as a project, and organizes the files that make up a project into folders. The Project Viewer is a file manager that allows you to browse through folders and to set the path where your files are located as your current working directory. The Project Viewer window is divided into two panes. The left pane lists the objects available in Paradox. The right panel displays the names of the files for the selected object type.
The Welcome screen The Welcome screen displays when you start Paradox. You can choose from six options.
Planning your database 3 A good plan is the key to creating an efficient, highly flexible database and to maintaining the integrity of your data. By following a few basic steps, you’ll save time and eliminate the problems that could arise from a poorly planned database. When you plan a database, you must identify all the information you want to retrieve. From this, you define and organize the data you want to store and maintain.
Link the tables Decide which fields are going to link your tables. If we use the example of a book collection database, the book table would use the International Standard Book Number (ISBN) as the unique key. The author table may also contain a unique key, such as author number, but must contain a linking field to tie the information back to the book table. By including only one additional field, the author ID in the book table, you can easily establish a link.
Working with tables and records 4 In a database, information is stored in tables. There are three aspects to every database table. Table structure ¾ the arrangement of fields, data types and sizes. By carefully designing your table fields, you build a solid framework to house your data in an orderly fashion. Special table properties ¾ the rules that dictate what and how data can be entered.
Type (symbol) Description Long Integer (I) Contains 32-bit signed whole numbers ranging from -2147483648 to 2147483647. BCD (#) Binary Coded Decimal numbers. Use when performing calculations that require a higher level of precision than the Number field provides. Maximum size: 32 characters. Date (D) Contains date information. Displays in a variety of formats. Time (T) Contains time-of-day information formatted as hh:mm:ss or as specified in your operating system’s preferences.
There are a few rules to follow when creating the field names for a table. Field names must be unique within the table, they must be less than 26 characters in length, and they cannot contain spaces or special characters, such as @, #, {}, [], (), $, %, ^, &, or *. To create a table structure using the Table Expert 1 Click File } New } Table. 2 Click Table expert. 3 Follow the steps of the Expert.
3 Click Add. 4 Type a picture name in the Pictures list. 5 Click Code syntax to view valid picture codes. 6 Type a code in the Picture code box. An example of a code would be: ####. 7 Type a sample value in the Sample value box. An example of a sample value would be: 1234. 8 Type a description for the picture in the Description box. To set a field as mandatory In the Create table dialog box, enable the Req’d check box for the appropriate field name.
To create a lookup table 1 Click Format } Restructure table. 2 Click the Table lookup tab. 3 From the Fields (Current Table) list, choose the field to which you want to assign the lookup. 4 From the Lookups defined area, click the right arrow to move the field name to the Field column. 5 From the Lookup tables list box, choose the table you want to use as the lookup table. 6 Click the left arrow to move the table name to the Lookup table column.
gives full rights to all table functions, including the ability to change and delete passwords All ¾ Insert & delete ¾ or restructured. records can be added, edited, and deleted. The table cannot be deleted records can be added or edited but not deleted. The table cannot be deleted or restructured. Data entry ¾ Update ¾ only non-key fields can be edited. Read Only ¾ the user can only view data.
When you establish referential integrity, Paradox checks the validity of a value before accepting it in the referential integrity table. Navigating between records Paradox provides you with several ways of navigating between records to view, enter, and edit data. The following toolbar buttons are also provided to navigate between records. Button Action First Record Move to the first record in the table. Previous Set Move up one record set (the number of records displayed in the table window).
To edit a record 1 Click File } Open } Table. 2 Choose the drive and folder where the table is stored. 3 Double-click a table. 4 Click View } Edit data. 5 Click the field you want to change. 6 Type new data into the field. To delete a record from a table 1 Click File } Open } Table. 2 Choose the drive and folder where the table is stored. 3 Double-click a table. 4 Click View } Edit data. 5 Click the record marker at the left-hand end of the record you want to delete. 6 Click Record } Delete.
To replace a field value 1 Click File } Open } Table. 2 Choose the drive and folder where the table is stored. 3 Double-click a table. 4 Click View } Edit data. 5 Click Record } Locate } Replace. 6 From the Field list box, choose the field you want to search. 7 In the Value box, type the value you want to search for. 8 Type the new value in the Replace with box. Adding and deleting table fields You can add or delete fields in your tables after you have created them.
2 - field heading 3 - vertical grid line To change the row size of a table 1 Click File } Open } Table. 2 Choose the drive and folder where the table is stored. 3 Double-click a table. 4 Point to a horizontal grid line. 5 When the pointer changes to a double-headed arrow, drag the cursor to resize the row. To change the column size of a table 1 Click File } Open } Table. 2 Choose the drive and folder where the table is stored. 3 Double-click a table. 4 Point to a vertical grid line.
Working with forms 5 Forms are database objects that provide you with an efficient way of viewing, adding and editing records in your tables. A form looks something like an application dialog box. It has fields that contain data stored in tables, and buttons that let you navigate between records. Forms can be designed to view one record at a time, or groups of records. You can also design a form to view and edit data in two or more linked tables.
The following image illustrates an example of a Quick Form. To create a quick form 1 Click File } Open } Table. 2 Choose the drive and folder where the table is stored. 3 Double-click a table. 4 Click Tools } Quick design } Quick form. To create a form using a data model 1 Click File } New } Form. 2 Click Data model. 3 Choose from the list box at the bottom of Data model dialog box. 4 Double-click a Data model. 5 Click OK. 6 Choose Field layout and Style options. 7 Click OK.
One-to-one ¾ a unique field in a table is linked to a unique field in another table. There is a direct relationship between the tables in which there is only one record in either table for the unique value. One-to-many ¾ a unique value in the linked field of a parent table is linked to a non-unique field in a child table. For example, a single customer may have many orders for products.
Adding objects to a form You can enhance the appearance and functionality of your form by adding design objects. You can add boxes, ellipses, or lines to physically divide groups of buttons or fields into separate areas and add text objects to label the areas. To view data in a table field that is not currently included on your form, you can add a field object. To make navigation and editing of table fields easier, you can add button objects.
To add a button object 1 Click File } Open } Form. 2 Choose the drive and folder where the form is stored. 3 Double-click a form. 4 Click View } Design form. 5 Click the Button tool . 6 Follow the steps of the Expert. If the Button Expert is not launched automatically, click Tools } Settings } Preferences. Click the Expert tab and enable the Run experts when creating objects on a document check box. Moving or deleting objects Each field, button, and text item on your form is treated as a separate object.
To change the color of an object 1 Click File } Open } Form. 2 Choose the drive and folder where the form is stored. 3 Double-click a form. 4 Click View } Design form. 5 Click an object to select it. You may have to click the object more than once. Selection handles appear around the object when it is selected. 6 Right-click the object, and click Properties. 7 Click the General tab. 8 Click a color n the palette. The Color property is only available for certain types of design objects.
You cannot retrieve a deleted record. Printing a form Although forms are intended for use primarily as screen-based documents, it is possible to print a form. When you print a form, Paradox prints only the current record, unless you open the form as a report. In this case, a series of form windows are printed, each containing a distinct record. To print a form's design 1 Click File } Open } Form. 2 Choose the drive and folder where the form is stored. 3 Double-click a form. 4 Click View } Design form.
Working with reports 6 A report is a document that allows you to present your data. Reports can be used to create mailing labels, financial statements, and invoices. Reports are the best way to prepare your data for printing. Paradox reports can display data from one or many tables, using a variety of layouts. There are two different modes or views in which you can work with a report. Design Report ¾ used to create the report and to make any changes to the report after it has been saved and named.
To create a Quick Report 1 Click File } Open } Table. 2 Choose the drive and folder where the table is stored. 3 Double-click a table. 4 Click Tools } Quick design } Quick report. To create a report using a data model 1 Click File } New } Report. 2 Click Data model. 3 Choose Data models from the list box at the bottom of Data model dialog box. 4 Double-click a data model. 5 Click OK. 6 Enable the Multi-record option. 7 Click OK. 8 Click View } Run report.
To add a text object 1 Click File } Open } Report. 2 Choose the drive and folder where the report is stored. 3 Double-click a report. 4 Click View } Design report. 5 Click the Text tool . 6 Click the position on the report where you want to place the text. 7 Follow the steps of the Expert. If the Text Expert is not launched automatically, click Tools } Settings } Preferences. Click the Expert tab and enable the Run experts when creating objects on a document check box.
To delete an object on a report 1 Click File } Open } Report. 2 Choose the drive and folder where the report is stored. 3 Double-click a report. 4 Click View } Design report. 5 Click the object. 6 Press DELETE. Changing the color of objects Color adds visual interest to a report and can serve to highlight certain information. To change the color of an object 1 Click File } Open } Report. 2 Choose the drive and folder where the report is stored. 3 Double-click a report. 4 Click View } Design report.
To move a chart 1 Click the chart. 2 Drag the chart to a different area of the report. Previewing a report When you are working with your report in the Report Design window, you can switch the view at any time to see what the document looks like with your information displayed on it. Button Action First Page Move to the first page of the report. Previous Page Move back one page. Next Page Move forward one page. Last Page Move to the last page of the report.
To print with Landscape paper orientation 1 Click File } Open } Report. 2 Choose the drive and folder where the report is stored. 3 Double-click a report. 4 Click File } Print. 5 Click Properties. 6 In the Orientation area, enable the Landscape option from . 7 Click OK. From here For more information about... In the online Help Index, type...
Working with queries 7 Paradox lets you use queries to retrieve data from your tables. You control how much information you want to retrieve by specifying fields and records that meet conditions you define. For example, you could design a simple query that finds all of the customers that made purchases of more than 1000 dollars in the past three months. The data retrieved by the query is presented in a temporary table. The data displayed in this table is a copy of the data from the original table.
Button Action Check Plus Display all values for this field Check Descending Display only unique values for this field in descending order Check Group Specifies a group for set operations To create a single-table query 1 Click File } New } Query. 2 Choose the drive and folder where the table is stored. 3 Double-click a table. 4 Click the check boxes for each of the fields you want to include in the Answer table. 5 Click Query } Run query.
Saving queries Paradox lets you save your queries so that you can use them again. Saving a query is particularly useful in the case of complicated queries. By re-running a saved query, you ensure that the same selection conditions are used each time you want to retrieve data from your tables. To save a query 1 Click File } Save. 2 Choose the drive and folder where you want to save the file. 3 Type the query name in the File name box.
To create a multi-table query based on a data model 1 Click File } New } Query. 2 In the Files of type list box, choose Data models. 3 Double-click a data model. 4 Enable the check boxes for each of the fields you want to include in the Answer table. 5 Click Query } Run query. For more information on including query fields, see “Using Query By Example” on page 377. Creating advanced QBE queries You can use special operators in your queries to perform calculations on fields.
Comparison operators Definition = Equal to > Greater than; can be used in combination with “<” to define a search range. < Less than; can be used in combination with “>” to define a search range. <= Greater than or equal to. <= Less than or equal to. Arithmetic operators Definition + Add numbers or join alphanumeric values.
Special operators Definition AS Both conditions must be met. , Create this field name (provided by the user following the AS operator) and add to Answer table. ! Requests that all values be displayed, regardless of match; Specifies the table from which all records are to be used in a joined table query. Reserved words Definition CALC Requests that the result be displayed in a new calculated field in the Answer table. CHANGETO A global editing tool used to change matching values.
Set comparison operators Definition EXACTLY Display only values that match all the values of a defined set and no others. From here For more information about... In the online Help Index, type...
Working with ObjectPAL 8 ObjectPAL (Object Paradox Application Language) is an object-based, event-driven, visual programming language. You can use ObjectPAL to customize applications with new buttons, menus, dialog boxes, prompts, warnings, and online Help. ObjectPAL can be used to extend the regular Paradox functions, or to create non-database applications. ObjectPAL and Paradox are tightly integrated; the more you know about Paradox, the more you can take advantage of it in your ObjectPAL programming.
Event-driven An event-driven interface is one that responds only to specific system or user actions, such as clicking the mouse button, moving the pointer over an object, or pressing a key. Anything you do in Paradox generates an event. Paradox recognizes certain actions or conditions within forms as events. When Paradox detects that an event has occurred, it executes the method associated with that event. There are different types of events that are appropriate for different types of objects.
Using the Debugger The debug environment includes the Debugger window, the Watches window, the Breakpoints window, the Tracer window, and the Call Stack. For example, you can choose to have the Debugger open automatically when you are in design mode or when you are running a form.
To access the ObjectPAL help Click Help } ObjectPAL reference. To access the ObjectPAL Tutorial Click Help } ObjectPAL tutorial. From here For more information about... In the online Help Index, type...
Paradox and the Internet 9 Paradox provides tools to convert your tables and reports to HTML documents so you can display your data on a Web page. You can use the HTML Table Expert and the HTML Report Expert to publish static or dynamic documents. Static publishing takes a snap shot of your table or report and publishes that information to a Web page. The Web page will not reflect any changes to your data unless you publish another, more up-to-date table or report.
To publish a report to HTML 1 Click File } Open } Report. 2 Choose the drive and folder where the table is stored. 3 Double-click a report. 4 Click File } Publish as } HTML. 5 Follow the steps of the Expert. Importing HTML information from the Internet The HTML Import Expert helps you import tables or lists from HTML files into an existing Paradox table or a new table that you create. If you create a new table, you can define the name, type, and size of each field directly from the Expert.
Compatibility with other applications 10 Paradox files can be made compatible with a variety of applications, with little formatting or modification required to the data. You can publish reports to text, HTML, and word processor formats, import data from Microsoft Excel or other applications into Paradox tables, export data from Paradox to other applications, copy data from a Paradox table and paste it into a Quattro Pro spreadsheet, and insert Paradox table data into a text document.
The Export feature allows you to move data from your Paradox tables to a text file, a WordPerfect document, a dBase table or a table created in an earlier version of Paradox. You can also export data to a spreadsheet program such as Quattro Pro, Lotus 1-2-3, or Microsoft Excel. In the case of text files, Paradox can import and export text in delimited or fixed-length formats.
When you copy one or more fields from a Paradox table and paste them into a Quattro Pro spreadsheet, the field name is copied along with the data contained in the field. To copy data from a Paradox table to a Quattro Pro spreadsheet 1 In a Paradox table, click the field you want to copy. To select a block of fields, click and drag over the fields you want to copy. 2 Click Edit } Copy. 3 In Quattro Pro, click the cell in which you want to paste the Paradox data. 4 Click Edit } Paste.
From here For more information about... In the online Help Index, type...
Index: Paradox 10 A accessibility . . adding records . . . table fields . . advanced queries . answer table . . . . . . . . . . . . 344 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 359 361 380 377 B boxes adding . buttons adding . . . . . . . . . . . . . 366 . . . . . . . . . . . . 367 . . . . . . . . 374 . . . . . . . . 361 . . . . . . . . 391 . . . . . . . . 392 . . . . . . . .
G graphics . . . . . . . . . . . . . 372 H hotKey assignment mechanism . . . . . . . . 344 HTML import expert . . . . . . . . . . . 390 importing . . . . . . . . . . . . 390 publishing . . . . . . . . . . 389, 391 report expert . . . . . . . . . . . 389 table expert . . . . . . . . . . . 389 I importing data . . . . . . . . . HTML . . . . . . . . . indexes secondary . . . . . . . . integrated development environment (IDE) debugger . . . . . . . . editor . . . . . . . . . object explorer .
enhancements . reports to HTML reports to RTF . tables to HTML. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 343 389 391 389 Q Quattro Pro importing from . . . . . . . . . . 391 linking and copying to . . . . . . . . . 392 queries . . . . . . . . . . . . . 377 advanced . . . . . . . . . . . . 380 creating . . . . . . . . . . . 377, 379 multi-table . . . . . . . . . . . . 379 saving . . . . . . . . . . . . . 379 single-table . . . . . . . . . . .
Section 6 CorelCENTRAL 10
Table of contents: CorelCENTRAL 10 Welcome to CorelCENTRAL 10 . What’s new in CorelCENTRAL 10 . . . . . Getting started with CorelCENTRAL . Starting and quitting CorelCENTRAL . Exploring the CorelCENTRAL work area. Using CorelCENTRAL Calendar . . . . . . . Using CorelCENTRAL Alarms Starting CorelCENTRAL Alarms Setting alarms . . . . Editing and deleting alarms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Welcome to CorelCENTRAL 10 1 CorelCENTRAL 10 is a suite of applications that help you manage time, tasks, appointments and email, and facilitate communication in a corporate environment. You can use CorelCENTRAL to plan your everyday schedule, write reminders to yourself, organize reference information, send and receive email messages, and manage business contact information.
use CorelCENTRAL Alarms independently of CorelCENTRAL to create alarms that sound at specific times and dates. CorelCENTRAL Address Book CorelCENTRAL Address Book is a powerful tool that lets you personalize and share your contact information. You can add and customize information in the CorelCENTRAL Address Book, and you can search for specific information. You can share address books with other users on a network and set read and write permissions to limit what they can do within it.
CorelCENTRAL Address Book groupware functionality lets you assign individual and group access rights to address books. CorelCENTRAL Admin You can use CorelCENTRAL Admin to create databases on local and remote Paradox databases and SQL servers. You can also create and maintain users, groups, and resources within databases. Virtually seamless compatibility Corel is committed to providing applications that have a high level of compatibility with other applications.
Getting started with CorelCENTRAL 2 CorelCENTRAL is a suite of applications that you can use to effectively plan your everyday schedule, write reminders to yourself, organize reference information, send and receive email messages, and manage all of your personal and business contact information. This section will introduce you to the concepts necessary to use the CorelCENTRAL applications.
CorelCENTRAL Card File CorelCENTRAL Memos CorelCENTRAL Mail You can also Start CorelCENTRAL from the Desktop Application Director (DAD) Click the CorelCENTRAL 10 icon on the Windows taskbar. Start an application from within any other CorelCENTRAL application. Click Tools, and click an application. To quit CorelCENTRAL Click File } Exit. Exploring the CorelCENTRAL work area The work areas in CorelCENTRAL applications include everything you see on your screen when you start each application.
Using CorelCENTRAL Calendar 3 CorelCENTRAL Calendar lets you plan your activities days, weeks, months, or even years in advance. With groupware functionality, CorelCENTRAL Calendar also helps you facilitate communication in a corporate environment. The default CorelCENTRAL Calendar is integrated with CorelCENTRAL Day Planner, so tasks and events that you schedule in the default CorelCENTRAL Calendar can also be viewed in CorelCENTRAL Day Planner.
In a corporate environment, you can use CorelCENTRAL Admin to create a shared corporate calendar database for each user, and to maintain users, resources and groups for each calendar. You can use a shared calendar to schedule work-related events and tasks with other users. You can also assign the appropriate rights, user name, and password for each user. When you start CorelCENTRAL Calendar again, the default calendar displays in the application window.
To set a default calendar 1 Click a calendar tab. 2 Click File } Set default calendar. A check mark beside Set default calendar indicates that the default calendar is displayed. If you want to close the default calendar, you must first disable the Set default calendar command, and set another calendar as the default. Selecting dates and times in a calendar There are several ways to select a date in CorelCENTRAL Calendar. You can use the Mini-calendar, or you can select a specific date.
To schedule a single task in a calendar 1 Click Calendar } New task. 2 In the Subject box, type a name for the task. 3 Click the Mini-calendar button in the Date box, and click a date. 4 Click the Mini-calendar button in the Due date box, and click a due date. If you want to include comments about the task, type text in the Notes box. You can also Set a priority level for the task Choose a priority level from the Priority list box. Track the progress of a task Type a value in the % complete box.
You can assign a task to an event. To schedule an event in a calendar 1 Click Calendar } New event. 2 Click the Events tab. 3 Type a subject in the Subject box. If you want to schedule a location, type text in the Room box. 4 Click the Mini-calendar button in the Date box, and click a date. 5 Choose a time from the Start list box. 6 Choose a duration from the Duration list box. If you want to include comments about the event, type text in the Notes box.
4 Click Repeat. 5 In the Repeat event dialog box, click the Weeks of year tab. 6 Click the Mini-calendar button in the From box, and click a date. 7 Click the Mini-calendar button in the To box, and click a date. 8 Choose a month from the Month list box. 9 Choose a week from the Week list box. If you want to schedule the event for specific days, enable any of the check boxes in the On day(s) area. To assign a task to an event 1 Right-click an event, and click Edit event. 2 Click the Tasks tab.
Using CorelCENTRAL Card File 4 CorelCENTRAL Card File is a versatile database application that you can use to store and organize personal information, inventories, reference material, and many other types of data. You can customize card files to store only the information that you need to record.
To open a card file template 1 Click File } Open. 2 Browse to X:\Program Files\Corel\WordPerfect Office 2002\Template, where “X” represents the drive where CorelCENTRAL is installed. 3 Double-click a card file template. To save a card file template in your profile 1 Click a card file template tab. 2 Click File } Save as.
To delete a card file 1 Click a card file tab. 2 Click File } Delete. 3 Choose a card file from the Available card files list. Using fields to organize card file data Fields are categories of information that you can use to record information in card files. You can create fields specific to the type of card file you are using.
To create a local field 1 Click a card file tab. 2 Click a card. 3 Click Cards } New local field. 4 Type a field name. You can also Duplicate a field Click a field. Click Cards } Duplicate field. Undo changes to a field Click Edit } Undo field changes. Delete a field Click a field. Click Cards } Delete field. To create a comment field 1 Click a card file tab. 2 Click a field. 3 Click Cards } New comment field. 4 Type a field name. 5 Click the initial field contents, and type text.
To link a field to a card file 1 Click a field. 2 Click Tools } Link to } Card file. 3 Click a card file tab. 4 Choose a group from the Groups list box. 5 Click a card. To link a field to a memo 1 Click a field. 2 Click Tools } Link to } Memos. 3 In the Link to memos dialog box, double-click a memo. To link a field to a file 1 Click a field. 2 Click Tools } Link to } File/application. 3 Type text in the Link text box. 4 In the Filename box, click the Browse button file is stored.
Using CorelCENTRAL Memos 5 CorelCENTRAL Memos lets you write and store notes about appointments, special events, or anything else that you want to record and organize. For example, you can write yourself a memo to remind you of what you need to accomplish on a given day. In this section, you’ll learn about starting and quitting CorelCENTRAL Memos working with memos categorizing memos Starting and quitting CorelCENTRAL Memos You can start CorelCENTRAL Memos from the Windows taskbar.
To view the contents of a memo Select a memo. The contents of the memo display in the Type in the memo text here box. To find a memo by using a text search 1 Click Edit } Find. 2 Type text in the Find box. 3 Click Find now. To copy or move memo text 1 Select a memo from which you want to copy or move text. 2 Select text from the Type in the memo text here box.
Using CorelCENTRAL Alarms 6 CorelCENTRAL Alarms lets you use your computer as an alarm clock to remind you of the events that you have scheduled in CorelCENTRAL Calendar and CorelCENTRAL Day Planner. You can also use CorelCENTRAL Alarms independently of CorelCENTRAL to create alarms that sound at specific times and dates. To hear alarms, you need a sound card properly installed on your computer. If you do not have a sound card, you will see a visual reminder when the alarm is set to sound.
12 hours 1 minute 3 days 3 hours 1 minute You can set a Quick alarm. You can also set an Advanced alarm, and apply a custom sound to it. If you do not apply a custom sound to an Advanced alarm, CorelCENTRAL Alarms uses the system default sound. To set a Quick alarm 1 Right-click the CorelCENTRAL Alarms icon on the DAD, and click Set alarm. 2 Click Quick. 3 In the Quick alarm dialog box, type a subject in the Subject box. 4 Choose a time from the Alarm after list box.
HotSyncing 3com PalmPilot and CorelCENTRAL 7 To perform a HotSync between PalmPilot and CorelCENTRAL, the 3Com PalmPilot Desktop software must be installed before CorelCENTRAL. By default, PalmPilot conduits are installed when you install CorelCENTRAL, but the PalmPilot software must be detected to enable the conduits. A conduit exists for every CorelCENTRAL application that you can HotSync with PalmPilot.
PalmPilot does not recognize CorelCENTRAL Address Book group, resource, or organization entries. Also, only the Mailing address segment of a CorelCENTRAL Address Book address entry transfers to PalmPilot when you HotSync. PalmPilot stores only three phone numbers, so you can only HotSync that many phone numbers from CorelCENTRAL Address Book. The following table lists corresponding CorelCENTRAL Address Book and PalmPilot fields.
PalmPilot only supports complete or incomplete tasks. A task that is less than complete in CorelCENTRAL will be considered incomplete in PalmPilot. PalmPilot To Do List items become CorelCENTRAL tasks when you HotSync, and CorelCENTRAL subtasks and tasks become To Do List items that are not subordinate to other tasks. To HotSync PalmPilot and CorelCENTRAL 1 Place the PalmPilot in its cradle. 2 Click Start on the Windows taskbar. 3 Click PalmPilot desktop } HotSync Manager.
Index: CorelCENTRAL 10 ! 3Com PalmPilot Citrix . . . . . . . CorelCENTRAL Address Book . CorelCENTRAL conduits . . HotSyncing with CorelCENTRAL Windows Terminal server . . . . . . . . . . . . . . . . . . . . . . . . . . . . 427 . 425 . 425 425,427 . 427 A alarm sounds custom . . . alarms Advanced . . custom sounds. editing . . . Quick . . . setting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
templates . . . using . . . . CorelCENTRAL Mail about . . . . CorelCENTRAL Memos creating . . . quitting . . . starting. . . . using . . . . creating card files . . . cutting memo text . . . . . . . . . . . . . . . . . . . . . 415 415 . . . . . . . . . 404 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 421 421 421 421 . . . . . . . . . 416 . . . . . . . . . 422 D DAD starting CorelCENTRAL Alarms . . . . . . 423 default calendars. .
CorelCENTRAL Memos . . . . . . . . . 421 . . . . . . . 416 . . . . . . . . . . . . . . 413 413 . . . . . . . . . . . . . . . . . . . . . 412 412 412 . . . . . . . 411 . . . . . . . 421 . . . . . . . . . . . . . . . . . . . . . 408 408 408 . . . . . . . . . . . . . . . . . . . . . 414 412 411 . . . . . . . . . . . . . . 415 415 . . . . . . . 408 . . . . . . . . . . . . . . . . . . . . .
