You can open Microsoft Excel workbooks in Quattro Pro without truncating data, and Quattro Pro supports many of the features of Microsoft Excel.
In this section, you'll learn about
opening and saving Microsoft Excel workbooks in Quattro Pro
working with Microsoft Excel 97 menus and tabs in Quattro Pro
For more information about moving between Microsoft Excel and Quattro Pro, see "Reference: Moving between Microsoft Excel and Quattro Pro."
Opening and saving Microsoft Excel workbooks in Quattro Pro
You can open Microsoft Excel version 3, 5, 7, 97, 2000, and XP workbooks in Quattro Pro. If you modify the workbook, you can save it as a Quattro Pro notebook so that you don't lose Quattro Pro formulas or features not supported in Microsoft Excel.
Microsoft Excel workbooks that contain custom spreadsheet names may not open in Quattro Pro if characters used in the names are not recognized by Quattro Pro. If this happens, Quattro Pro displays a dialog box warning you about the invalid spreadsheet name. You can change the spreadsheet name to make it compatible with Quattro Pro.
You can also save a Quattro Pro notebook as a Microsoft Excel file; however, some file format features unique to Quattro Pro may be lost.
For a list of conversion considerations, see "Reference: Moving between Microsoft Excel and Quattro Pro."
To open a Microsoft Excel workbook in Quattro Pro
1 Click File Open.
2 Choose the drive and folder where the workbook is stored.
3 Double-click the workbook's filename.
To save a Microsoft Excel workbook as a Quattro Pro notebook
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.
By default, the file is given a .qpw filename extension.
Tip
You can save a Microsoft Excel workbook, opened in Quattro Pro, as a .xls file by clicking File Save.
To fix invalid spreadsheet names
1 Open a Microsoft Excel file in Quattro Pro.
In the Quattro Pro dialog box, the invalid spreadsheet name displays in the Invalid name box.
2 Enable one of the following options in the Rename options area:
Fix invalid spreadsheet name-changes the spreadsheet name to include only valid Quattro Pro characters. The new name displays in the New name box.
Do not fix invalid spreadsheet name-keeps the original spreadsheet name
If you want to make additional changes to the name, type them in the New name box, using valid Quattro Pro characters.
Notes
If you enable the Do not fix invalid spreadsheet name option and try to use the Microsoft Excel spreadsheet name, you cannot initiate formulas and macros.
If you enable the Fix invalid spreadsheet name option but have used the original spreadsheet name in cell references, you must search for these references and replace them with the new name.
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.
Working with Microsoft Excel 97 menus and tabs in Quattro Pro
You can use Microsoft Excel 97 menus and tabs in Quattro Pro if you are switching to Quattro Pro from Microsoft Excel 97. This lets you work in a familiar environment until you are accustomed to the Quattro Pro menu structure.
You can change spreadsheet tabs in a Quattro Pro notebook to adopt the Microsoft Excel 97 spreadsheet naming convention.
To use Microsoft Excel 97 menus and tabs in Quattro Pro
1 Click Tools Settings.
2 Click WorkSpaces.
3 Enable the Microsoft Excel check box in the WorkSpaces list.
To switch to the Microsoft Excel naming convention for spreadsheet tabs
1 Click Tools Settings.
2 In the list of categories, double-click Workspace, Application, and click Compatibility.
3 In the Sheet tab display area, enable the Display as numbers check box.
Reference: Moving between Microsoft Excel and Quattro Pro
Quattro Pro translates most Microsoft Excel formats, navigational tools, print options, formulas, and spreadsheet functions. Occasionally, some information in a workbook cannot be imported or exported or may not display in the same way after the conversion process.
Microsoft Excel features and Quattro Pro equivalents
Many features in Microsoft Excel are similar to those in Quattro Pro, despite different naming conventions. The following table can assist you in moving from Microsoft Excel to Quattro Pro.
Microsoft Excel features... Quattro Pro reference...
Templates Working with project templates
Calculation methods Working with formulas
AutoFit To increase the column width while typing values
AutoSum Performing running calculations
AutoFill Filling cells and spreadsheet tabs automatically
AutoFormat Using formatting tools to format a spreadsheet
Mail enabled To send a notebook by email
Wizards Working with Quattro Pro Experts
Center across block To center text across multiple cells
Nameable sheet tabs Naming spreadsheets
Function Wizard Composing formulas
Goal Seeker Using goal seeking
Nonlinear Solver Finding optimum solutions for linear and nonlinear problems
Multi-Variable Backsolver Finding optimum solutions for linear and nonlinear problems
Array formulas Working with arrays
Floating text boxes Creating text box graphics
Notebook drawing layer Drawing shapes and lines
Trace mode To set a trace cell for a Quattro Pro macro
Break points Setting macro breakpoints
Visual Dialog Builder Working with custom dialog boxes and controls
Built-in full debugger Debugging Quattro Pro macros
Toolbar Designer To create a toolbar
Search/replace To find and replace data
Queried import Querying external databases
Sort databases Sorting data
Cell-Based auditing Tracing errors in formulas
Password-protect file Using password protection
Cell notes To add a cell comment
External range links Creating notebook links
Automatic file backup To back up your notebooks automatically
Microsoft Excel spreadsheet data imported by Quattro Pro
Quattro Pro reads Microsoft Excel version 3, 5, 7, and 97 workbook files and imports the following Microsoft Excel data:
values and labels
most cell formatting
embedded charts
links to different workbooks or files
most functions
arithmetic formulas
chart spreadsheets (converted to floating graphs)
OLE objects contained in Microsoft Excel spreadsheets
Hyperlinks
Hyperlinks saved in Microsoft Excel files do not work in Quattro Pro.
Spreadsheet and file types
Quattro Pro imports and exports only .xls workbook files. In Microsoft Excel version 5 and later, this includes multiple-spreadsheet support. Quattro Pro does not recognize Microsoft Excel chart pages or macro pages, chart files (.xlc), templates (.xlt), add-ins (.xla, .xll), or toolbars (.xlb).
Password protection
Microsoft Excel password protection is not supported. Quattro Pro displays a warning if a user attempts to open a protected Microsoft Excel file.
Visual Basic for Applications
Quattro Pro cannot read, write, or interpret Visual Basic for Applications (VBA) scripts written from within Microsoft Excel. Quattro Pro cannot translate its own VBA scripts into Microsoft Excel-compatible scripts.
Microsoft Excel macros
Quattro Pro does not support Microsoft Excel macros.
Microsoft Excel functions
Quattro Pro converts any Microsoft Excel function that it does not support to a value, and shades it red. Before converting a Microsoft Excel file to Quattro Pro, make sure no cells in the Microsoft Excel file are shaded red or contain red text.
Note
If Quattro Pro does not understand any of the Microsoft Excel commands, the commands and any associated comments appear as comments in the converted file.
Microsoft Excel cell attributes and styles imported by Quattro Pro
When you open a Microsoft Excel file in Quattro Pro, most cell properties, styles, and named blocks are imported and translated automatically.
Cell properties and styles
Styles are imported from and exported to .xls files. When importing files to Quattro Pro, the style names and formatting are translated into Quattro Pro styles. The formatting includes the following cell attributes:
font (style, size, bold, italic, underline, color)
line drawing (single, double, thick, color)
cell width
numeric format (transfers to the most closely resembled format)
row heights (can be imported into Quattro Pro, but cannot be exported into Microsoft Excel)
Shrink to fit
The Microsoft Excel Shrink to fit feature is not supported by Quattro Pro.
Currency formats
Not all Microsoft Excel currency formats are supported by Quattro Pro; conversely, not all Quattro Pro currency formats are supported by Microsoft Excel.
Named blocks
Quattro Pro imports Microsoft Excel named ranges, including 2-D and 3-D ranges. Quattro Pro also exports its named 2-D and 3-D ranges into Microsoft Excel spreadsheets.
Microsoft Excel print options, windows, and charts imported by Quattro Pro
When you import Microsoft Excel files, most print options, window configurations, and charts translate seamlessly into Quattro Pro. When exporting a Quattro Pro notebook to an .xls file, charts are converted to the nearest Microsoft Excel equivalent.
Print options
The following print options are imported into Quattro Pro from Microsoft Excel files:
orientation
margins (top, left, right, bottom)
header size (inches)
footer size (inches)
header text
footer text
print grid lines
Chart types
Microsoft Excel charts that match Quattro Pro chart types convert; otherwise, Quattro Pro converts the Microsoft Excel chart to the Quattro Pro chart that it most closely resembles, adding properties where it can to make the chart look as much as possible like the Microsoft Excel chart. Bitmap images and textures added to Microsoft Excel charts do not convert. They become solid colors in Quattro Pro.
Microsoft Excel chart types not supported by Quattro Pro
stacked line chart and 100% stacked line chart
bar of pie chart and pie of pie chart
100% stacked area chart and 3-D 100% stacked area chart
no direct support for color radar chart
no direct support for contour chart
no direct support for scatter chart
no direct support for multiple-series donut chart
Microsoft Excel chart attributes not supported by Quattro Pro
title-vertical alignment and orientation
minor gridlines
limited support for bar overlapping
limited pattern support for axis or gridlines
limited support for gradient fill styles
limited support for legend positioning
fill settings for XY titles
Microsoft Excel 97 chart items possibly missing when converting to Quattro Pro
When opening Microsoft Excel 97 workbooks in Quattro Pro, embedded charts may display problems. The data is converted, but the following items may be missing from the chart:
any lines, labels, or attributes related to the secondary y-axis
both the primary and secondary y-axis scales
Spreadsheet objects transferred between Microsoft Excel and Quattro Pro
With some exceptions, OLE objects and other objects such as graphs can be transferred between Microsoft Excel and Quattro Pro.
OLE 2.0 links and objects
Quattro Pro loads OLE 2.0 links embedded in an .xls file. However, Quattro Pro does not export OLE 2.0 links when saving in a Microsoft Excel format.
Quattro Pro imports OLE 2.0 objects embedded in Microsoft Excel spreadsheets. However, Quattro Pro does not export OLE 2.0 objects when saving in a Microsoft Excel format.
Inserted graphs
Quattro Pro maps an inserted Microsoft Excel graph to the nearest Quattro Pro style. Quattro Pro also exports its inserted graphs, mapping them to the nearest match in Microsoft Excel.
Draw layer objects
Draw layer objects are imported into Quattro Pro's draw layer. Draw layer objects include arrows, text boxes, buttons, line segments, rectangles, filled rectangles, rounded rectangles, and ellipses. Polygons and freehand drawings are not imported.
In situations where there is no comparable spreadsheet AutoShape, shape, or drawing tool within Microsoft Excel or Quattro Pro, the shape will be replaced with the best possible fit or deleted. Text callout shapes will lose the text within them on import.
Quattro Pro's draw layer objects are not exported to .xls files.
Maps
Importing and exporting maps between Quattro Pro and Microsoft Excel is not supported. Map source data is retained, but the map chart is deleted.
Microsoft Excel formulas and functions imported by Quattro Pro
Quattro Pro maps as many Microsoft Excel formulas to spreadsheet functions as possible when it opens a Microsoft Excel file. Those without a Quattro Pro equivalent are translated as values, and the background color of the cell changes to red. When you save a file in a Microsoft Excel format, Quattro Pro translates spreadsheet functions to the nearest equivalent Microsoft Excel function. For a complete list of all the Microsoft Excel functions Quattro Pro supports, see "Microsoft Excel functions supported by Quattro Pro." For a list of Microsoft Excel functions that Quattro Pro does not support, see "Microsoft Excel functions not supported by Quattro Pro."
Array formulas
Array formulas are not imported.
Hidden formulas
When importing Microsoft Excel files, Quattro Pro converts Microsoft Excel hidden formulas to a protected cell with the format hidden. Quattro Pro does not, however, export hidden formulas.
User-defined functions
When Quattro Pro opens Microsoft Excel spreadsheets containing user-defined functions, they are converted to values, and the cells are shaded red. Quattro Pro does not export user-defined functions.
Note
There may be slight differences between function outcomes in Microsoft Excel and Quattro Pro due to the rounding of decimal places. The cells in each application should be formatted identically to ensure matching results.
Microsoft Excel analysis tools not imported by Quattro Pro
Scenario Manager data
Microsoft Excel Scenario Manager data is ignored in Quattro Pro.
Solver information
Microsoft Excel Solver information is not imported to Quattro Pro Optimizer.
Microsoft Excel functions supported by Quattro Pro
Quattro Pro imports the following Microsoft Excel spreadsheet functions:
ABS
ACCRINT
ACCRINTM
ACOS
ACOSH
ADDRESS
AND
ASIN
ASINH
ATAN
ATAN2
ATANH
AVERAGE
BESSELI
BESSELJ
BESSELK
BESSELY
BETADIST
BETAINV
CEILING
CELL
CHAR
CHIDIST
CHIINV
CHITEST
CHOOSE
CLEAN
CODE
COLUMN
COLUMNS
COMPLEX
CONCATENATE
CONFIDENCE
CONVERT
CORREL
COS
COSH
COUNT
COUNTA
COUNTIF
COUNTBLANK
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
COVAR
CRITBINOM
CUMIPMT
CUMPRINC
DATE
DATEVALUE
DAVERAGE
DAY
DAYS360
DB
DCOUNTA
DCOUNT
DDB
DEGREES
DELTA
DEVSQ
DISC
DMAX
DMIN
DOLLAR
DOLLARDE
DOLLARFR
DSTDEV
DSTDEVP
DSUM
DURATION
DVAR
DVARP
EFFECT
EOMONTH
ERF
ERFC
EVEN
EXACT
EXP
EXPONDIST
FACT
FACTDOUBLE
FALSE
FDIST
FIND
FINV
FISHER
FISHERINV
FIXED
FLOOR
FREQUENCY
FTEST
FV
GAMMADIST
GAMMAINV
GAMMALN
GCD
GEOMEAN
GESTEP
GROWTH
HARMEAN
HOUR
HYPGEOMDIST
IF
IMABS
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSIN
IMSQRT
IMSUB
IMSUM
INDEX
INDIRECT
INT
INTERCEPT
INTRATE
IPMT
IRR
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISTEXT
KURT
LARGE
LCM
LEFT
LEN
LINEST
LN
LOG
LOG10
LOGEST
LOGINV
LOGNORMDIST
LOWER
MATCH
MAX
MDETERM
MDURATION
MEDIAN
MID
MIN
MINUTE
MINVERSE
MIRR
MMULT
MOD
MODE
MONTH
MROUND
MULTINOMIAL
N
NA
NEGBINOMDIST
NETWORKDAYS
NOMINAL
NORMDIST
NORMINV
NORMSDIST
NORMSINV
NOT
NOW
NPER
NPV
ODD
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
OFFSET
OR
PEARSON
PERCENTILE
PERCENTRANK
PERMUT
PI
PMT
POISSON
POWER
PPMT
PRICE
PRICEDISC
PRICEMAT
PROB
PRODUCT
PROPER
PV
QUARTILE
QUOTIENT
RADIANS
RAND
RANDBETWEEN
RANK
RATE
RECEIVED
REPLACE
REPT
RIGHT
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
ROW
ROWS
RSQ
SECOND
SIGN
SIN
SINH
SKEW
SLN
SLOPE
SMALL
SQRT
SQRTPI
STANDARDIZE
STDEV
STDEVP
STEYX
SUBSTITUTE
SUBTOTAL
SUM
SUMIF
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
SYD
T
TAN
TANH
TBILLEQ
TBILLPRICE
TBILLYIELD
TDIST
TIME
TIMEVALUE
TINV
TODAY
TRANSPOSE
TREND
TRIM
TRIMMEAN
TRUE
TRUNC
TTEST
TYPE
UPPER
VALUE
VAR
VARP
VDB
WEIBULL
WEEKDAY
WORKDAY
XIRR
XNPV
YEAR
YEARFRAC
YIELD
YIELDDISC
YIELDMAT
ZTEST
Microsoft Excel functions not supported by Quattro Pro
The following Excel functions are not supported by Quattro Pro. Only the values are imported, and the cells are shaded red to indicate that the formula was not imported.
