Quattro Pro

What works

File menu (with enhanced file dialogues disabled)

New - New from Project - Open - Close - Save - Save As
Properties - Workspace
Page Setup - Print - Print Preview- Publish to Internet (HTML)
Recent File List

Edit menu

Undo - Redo
Cut - Copy - Paste - Paste Special (workbook selection)
Copy Cells - Convert to Values - Move Sheets - Delete
Clear - Fill - Select All
Links
Find and Replace - Go To
Find Page Break

View menu

Draft - Page - Page Breaks - Objects
Toolbars - Property Bar - Application Bar - Comments - Formulas
Group Mode - Split Window - Locked Titles
Zoom

Format menu

Selection - Sheet - Notebook
Text Reformat
QuickFit - SpeedFormat
Object Order

Insert menu

Cells - Row - Column - Sheet
Chart - Symbol - Date - Shape - Comment - Function - Form Control - Name
File
Page Break

Tools menu

Spell Checker
QuickCorrect
Macros Online
QuickFilter - Sort
Hyperlink
Customize - Settings

Window menu

Cascade - Tile Top to Bottom - Tile Side by Side
New View - Arrange Icons - Hide - Show
Windows List

Help menu

PerfectExpert - Corel Web Site - Corel on the Web
About Quattro Pro

What does not

File menu (with enhanced file dialogues enabled)

Open - Save As
Publish to Internet (XML)
Exit

Edit menu

Paste Special (workbook selection) [paste row/col sizes leads to crash later on]
Paste Special (OLE)
<>

Format menu

Notebook > NBPalette [deadlock on attempt to edit colour]
Styles

Insert menu

Graphics
Object

Help menu

Help Topics - Ask the PerfectExpert - Microsoft Excel Help

Workarounds

What was not tested

File menu

Version Control
Send to

Edit menu

OLE Links

Insert menu

XML Tag
External Data

Tools menu

Dragon Naturally Speaking
Macro - Visual Basic
Outline - Auditing - Numeric Tools - Data Tools
Consolidate - Scenario - Slide Show - Workgroup - Internet

Hardware tested

Graphics:

• GPU:
• Driver:

Additional Comments

Appeared to work equally well with Microsoft Excel format documents but this was not tested thoroughly.

By default, Quattro Pro uses 'enhanced' (Explorer-like) file dialogues. These do not work under Wine. Quattro Pro will probably crash opening an existing spreadsheet or saving a new one unless the enhanced dialogues are disabled first.

Start Quattro Pro. Select Settings... under the Tools menu. Select File Options... Uncheck the "Use enhanced file dialogs" box. Click OK.

This is obvious when Quattro Pro is run from a console. It may give problems when Quattro Pro is run by clicking on an icon.

This seems to be an OLE issue as it does not occur when dcom98, the native Windows OLE implementation, is used. If you choose to use dcom98, you probably forgo any hope of support from WineHQ.

On the downside, with dcom98, PerfectExpert becomes almost as annoying as an animated paper clip.

Quattro Pro backs up open workbooks a regular intervals. Following a crash, Quattro Pro may attempt to recover from workbook backups. It issues a message box prompt that requires user response. This message box may be hidden behind Quattro Pro's own splash screen giving the impression that Quattro Pro or Wine has hung.

See the WordPerfect Office 2000 AppDB entry for the note "Apparent Hang with only Splash Screen Displayed" for guidance on how to reveal a message box hidden behind a splash screen.

The Menu Bar has 8 menus. Sometimes, Quattro Pro starts with only 4. This so far has only been observed with the Perfect Expert User Assistant.

If the Perfect Expert dialogue is displayed, click the Work On tab and select the workbook you want.

If you want to start with a clean workbook, do not use the Create New tab. Instead, click the Close button.

Deselecting Options > Show This Dialogue at Startup has no effect.

It is possible to turn off the Perfect Expert by fiddling with the Wine registry but this has to be done each time Quattro Pro is started. The following shell script should do the trick:

#!/bin/bash
WINE=${WINE:-wine};
WINEPREFIX=${WINEPREFIX:-$HOME/.wine};

function noUA()
{
     echo 'REGEDIT4';

     echo "[HKEY_CURRENT_USER\\Software\\Corel\\QuattroPro\\$1\\Configuration]";
     echo '"UA Show At Startup"=dword:00000000';
     echo '"UA State"=dword:00000000';
}

�noUA 9 > ${WINEPREFIX}/noUA.reg;

${WINE} regedit ${WINEPREFIX}/noUA.reg;

exit;