37
110
Quattro Pro basics
notebook. This sheet also displays icons for custom dialog boxes you build. You can copy, rename, and print items in
the Objects sheet. The Objects sheet property bar has buttons for creating, editing, and displaying charts and for
building custom dialog boxes.
Project templates
Project templates let you create a new notebook based on a pre-designed project. Many of the Quattro Pro project
templates provide a basic format and structure for common spreadsheets and data entry forms. You can also create
your own project templates.
Values
A value is a number, date, formula, or the result of a formula. Quattro Pro automatically determines whether data is
a value or a label. As you type your data in a cell, the READY indicator on the application bar changes to LABEL or
VALUE, depending on the type of data you enter.
Labels
Labels contain alphanumeric data, such as titles, phone numbers, or addresses. Quattro Pro interprets and formats
labels differently than it does values. Values are calculable; labels are not.
Formulas
Formulas are mathematical equations. Formulas usually refer to numbers in other cells in order to calculate a value,
such as the difference between the values in two cells or the total of values in a column. You can use mathematical
functions and numbers in formulas.
Functions
Spreadsheet functions are built-in formulas that automate many of the calculations you perform in a spreadsheet. For
example, @AMAINT is a spreadsheet function that calculates the accumulated interest paid on a loan after a specified
number of payments. All spreadsheet functions are preceded by an @ sign.
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.
Working with toolbars
Toolbars give you quick access to the features you frequently use.
The following standard toolbars come with Quattro Pro:
• Notebook — provides tools for entering and editing data
• Selection formatting — provides tools for manipulating the current selection
• Data manipulation — provides tools for working with notebook cells and selections
• Drawing tools — provides tools for drawing or inserting objects in a graphics window, and for arranging objects
on a layer on top of the notebook
38
Part Three: Quattro Pro
111
• Outlining tools — provides tools for grouping data in collapsible and expandable sets of information
• Auditing tools — provides tools for tracing dependent cells, precedents, and even errors in large, complex
notebooks
• Review — provides tools for reviewing shared notebooks
• Experts and numeric tools — provides tools for quickly creating maps, charts, and budgets, and for performing
computations
• CrossTab report — provides tools for manipulating cross-tab reports
• Visual Basic® — launches the Visual Basic Editor and Visual Basic Design Mode
To display a toolbar
1
Right-click any toolbar.
2
Click the toolbar you want to display.
To move a toolbar
1
Point to the two vertical gray lines at the left of a toolbar.
2
Drag the toolbar to a new position.
Working with the application bar
The application bar displays mode and status indicators. For example, if you press Caps lock, the application bar
display shows that Caps lock is on.
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 use the QuickCell feature
1
Click a cell on the spreadsheet.
2
On the application bar, click QuickCell.
You can also
Clear the QuickCell value
Click a blank cell on the spreadsheet, and click QuickCell.
Disable QuickCell
Right-click the application bar, click Customize
Application bar Add new command, and drag the
QuickCell button from the application bar to the
spreadsheet window.
VB.NET PDF: Basic SDK Concept of XDoc.PDF XDoc.PDF for .NET allows VB.NET developers to edit hyperlink of PDF document, including editing PDF url links and quick navigation link in bookmark/outline.
adding an email link to a pdf; add a link to a pdf in preview
29
112
Quattro Pro basics
Working with Quattro Pro Experts
Quattro Pro Experts guide you step by step through many spreadsheet tasks. You can access Quattro Pro Experts from
a toolbar or from a menu. The following Experts are available:
• PerfectExpert — helps you quickly perform many common Quattro Pro tasks
• Analysis Expert — helps you make many analysis calculations, such as advanced regression, correlation, covariance,
exponential smoothing, F-test, moving average, sampling, T-test, and Z-test
• Budget Expert — guides you in creating five different budget templates for both home and business use
• Consolidate Expert — lets you combine cells using statistical operators (SUM, AVG, COUNT, MIN, MAX, STD, STDS,
VAR, VARS), after which you can sort the combined data
• External Data Expert — lets you easily import data from a database, such as a Paradox® or dBASE database. It also
supports Query By Example (QBE) and Open Database Connectivity (ODBC).
• Map Expert — builds a map from selected cells of data
• Scenario Expert — lets you create and display groups of scenarios (data conditions and results) based on models
in your notebook
• What-If Expert — lets you create tables that show the effect of changing one or two variable cells referenced in a
formula
To access a Quattro Pro Expert from a toolbar
1
Right-click a toolbar, and click Experts and numeric tools.
2
From the Experts and numeric tools toolbar, click the Expert you wish to use.
You can point to a toolbar button to see a description of a particular Expert.
Quitting Quattro Pro
You can quit Quattro Pro.
To quit Quattro Pro
• Click File Exit.
If you have changed any files, you are prompted to save your work.
37
Part Three: Quattro Pro
113
Navigation and display
In this chapter:
• “Navigating notebooks and spreadsheets” on page 113
• “Working with windows and views” on page 114
• “Zooming data and viewing screen components” on page 115
• “Hiding and revealing rows and columns” on page 116
For additional topics, please see “Viewing and navigating notebooks and spreadsheets” in the Quattro Pro
Help.
Navigating notebooks and spreadsheets
You can cycle through open notebooks. You can navigate columns and rows on a spreadsheet. You can also
automatically scroll through a spreadsheet.
In addition, you can quickly navigate to the Objects sheet.
To cycle through open notebooks
• On the application bar, click the button that displays the notebook's name.
You can also move through open notebooks by pressing Shift + F6 to cycle forward or Ctrl + F6 to cycle
backwards.
To navigate a spreadsheet
• Press the relevant key, as outlined in the table below.
You can also move across rows by pressing Tab.
To automatically scroll through a spreadsheet
1
On the notebook toolbar, click AutoScroll .
The cursor changes to the AutoScroll arrow.
2
Move the AutoScroll arrow in the direction you want to scroll.
The scrolling speed increases as you move the arrow farther away from the AutoScroll tool.
You can disable AutoScroll by clicking anywhere on the spreadsheet.
To
Do the following
Move down columns after entering data
Press Enter or the Down arrow.
Move up columns after entering data
Press the Up arrow.
Move across rows after entering data
Press the Left arrow or Right arrow.
40
114
Navigation and display
To go to the Objects sheet
• Click the Quick tab button at the bottom left of the notebook window.
To return to the original spreadsheet, click the Quick tab button again.
Working with windows and views
A Quattro Pro window displays a Quattro Pro file, or a file imported into Quattro Pro. While working in Quattro Pro,
you can have several windows open. For example, suppose you are 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. In addition,
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. For example, you can use Draft
view when quickly entering data, or you can use Page view when you want to change margins and see how
information will fit on a printed page. You can also use Zoom to make the notebook display larger or smaller.
To select a notebook window
• On the application bar, click the button that displays the window's name.
The window with the highlighted title bar is active.
You can toggle back and forth between Quattro Pro and a non-spreadsheet window, such as the spelling
checker, by pressing Alt + F6.
To arrange notebook windows
When possible, tiled windows are given equal room on the screen.
To hide a notebook window
1
Click the window.
2
Click Window Hide.
To show a hidden notebook window, click Window Show.
To select a notebook view
1
Click View.
2
Click one of the following views:
To
Do the following
Tile windows vertically
Click Window Tile top to bottom.
Tile windows horizontally
Click Window Tile side by side.
Have windows overlap
Click Window Cascade.
35
Part Three: Quattro Pro
115
• Draft — does not display some document elements such as footers, page breaks, and margins, although they
may exist in the notebook
• Page — displays your notebook pages the way they will look when printed
• Page breaks — displays soft and hard page breaks
• Objects — displays the Objects sheet, the last sheet in the notebook
The view that is currently selected when you exit Quattro Pro is the view that will appear when you open
Quattro Pro again.
You can drag graphics or charts while in Draft view or Page view.
To see multiple pages while in Page view, click View Zoom, and choose 50 percent (%) or less. To change
margins while in Page view, drag a blue margin line to set the current margin for a column or row of pages.
Zooming data and viewing screen components
Zoom lets you see an entire printed page or focus in on the detail of a few cells. You can set zoom for an entire
notebook or for individual sheets. The default setting is 100%. Percentages less than 100% show more columns and
rows; percentages greater than 100% show fewer. You can also use the Zoom to fit option to automatically fill the
screen with the current selection.
To zoom in and out of a notebook
1
Click View Zoom.
2
Select a zoom level.
3
Enable the Notebook option.
The zoom level does not affect printed output.
To restore the screen to its normal display, choose 100%.
If you select one cell and choose Selection, Quattro Pro finds the boundaries of the data, then zooms only that
cell.
To fit data on the screen by zooming
1
Select the cell or cells to zoom.
2
Right-click a toolbar, and click Data manipulation.
3
Click Zoom to fit .
25
116
Navigation and display
Hiding and revealing rows and columns
Quattro Pro lets you hide rows or columns from view on the screen. Hidden rows and columns do not print. Although
they are hidden from view, they are still used in calculations. Columns move left to fill in the space left by the hidden
column, and rows move up; however, row numbers and column letters do not change. For example, if you hide
column B, the columns on the screen are labeled A, C, D, and so on.
You can reveal rows and columns that are hidden.
To hide rows or columns
1
Select the rows or columns to hide.
2
Right-click the rows or columns, and click Hide.
To reveal hidden columns
1
Click Edit Select all.
2
Click Format Selection properties.
3
Click the Row/column tab.
4
Enable the Reveal option in the Column options area.
You can also reveal a hidden column by placing the pointer slightly to the right of where the hidden column
should be and dragging.
You can reveal hidden rows by enabling the Reveal option in the Row options area.
42
Part Three: Quattro Pro
117
Microsoft Excel compatibility
In this chapter:
• “Simulating the Microsoft Excel workspace” on page 117
• “Sharing spreadsheets with Microsoft Excel users” on page 117
For additional topics, please see “Compatibility with Microsoft Excel” in the Quattro Pro Help.
Simulating the Microsoft Excel workspace
If you recently switched from Microsoft® Excel® to Quattro Pro, you may not be familiar with the Quattro Pro
workspace. While there are many similarities between the two applications, you may find it easier to simulate the
Microsoft Excel workspace.
In addition, you can display the Compatibility toolbar, which gives you immediate access to tools such as saving
documents to Microsoft Excel and publishing to HTML.
To work in the Microsoft Excel workspace
1
Click Tools Settings.
2
Click Workspace.
3
Enable the check box beside the Microsoft Excel workspace in the available workspaces list.
Quattro Pro features, including toolbars and menus items, are rearranged to simulate where you would find their
equivalents in Microsoft Excel.
To display the Compatibility toolbar
1
Click View Toolbars.
2
Enable the Compatibility toolbar check box in the Toolbar list.
Sharing spreadsheets with Microsoft Excel users
Quattro Pro makes it possible for you to share your Quattro Pro spreadsheets with Microsoft Excel users and for them
to share their workbooks with you.
To save a Quattro Pro notebook as a Microsoft Excel file
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
Choose a Microsoft Excel file type from the File type list box.
To open a Microsoft Excel workbook in Quattro Pro
1
Click File Open.
19
118
Microsoft Excel compatibility
2
Choose the drive and folder where the workbook is stored.
If you can’t see the file, choose All files from the File type box.
3
Double-click the workbook's filename.
You can open Microsoft Excel version 3, 5, 7, 97, 2000, 2002 (XP), 2003, 2007, 2010, and 2013 workbooks
in Quattro Pro. You can also open Microsoft Excel Open XML workbooks (.xlsx) and Microsoft Excel Open XML
Macro-enabled workbooks (.xlsm).
When opening Microsoft workbooks in Quattro Pro, some information may not display as it did in Microsoft
Excel.
To automatically save to the Microsoft Excel format
1
Click Tools Settings.
2
In the list of categories, double-click Compatibility.
3
Choose XLS from the Default file type list box.
39
Part Three: Quattro Pro
119
Notebook basics
In this chapter:
• “Creating and opening notebooks” on page 119
• “Adding and deleting spreadsheets” on page 120
• “Moving and copying spreadsheets” on page 121
• “Renaming spreadsheets” on page 121
Creating and opening notebooks
When you start a new spreadsheet in Quattro Pro, you must first create a notebook. You can create a notebook from
the default template or from a list of project templates:
• When you create a notebook from the default template, you must format the data yourself and perform your
own calculations.
• Project templates prompt you for data and then format and calculate it automatically.
You can also open a notebook.
To create a notebook from the default template
• Click File New.
To create a notebook from a project template
1
Click File New from project.
2
Click the Create new tab.
3
Select Quattro Pro 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 open a notebook
1
Click File Open.
2
Choose the drive and folder where the notebook is stored.
3
Click a filename
4
Click Open.
Documents you may be interested
Documents you may be interested