Corel Quattro Pro 6.0 import filter

OpenOffice.org Calc

Document - ID	Specification Owner	Last Change	Status
	Shilpa Sreeramul	2005-09-06	Final
Conforms to	
Applies to	Calc
Task ID(s)	i41688
Category	feature

Abstract

The Corel Quattro Pro 6.0 (spread sheet) files cannot be viewed in OpenOffice.org. Filter is written so that the Quattro Pro files can be viewed in OpenOffice.org Calc (OOo). Only the files with extension .wb2 can be opened in OOo Calc.

i-Team Members (The specification owner is part of the i-Team)

	Name	E-mail Address
User Experience	Christian Jansen (CJ)	cj@openoffice.org
Development	Shilpa Sreeramulu (SS)	shilpas@openoffice.org
Development	Michael Meeks (MM)	mmeeks@openoffice.org
Quality Assurance	Oliver Crämer (OC)	oc@openoffice.org
Documentation	Uwe Fischer (UFI)	ufi@openoffice.org

Approved for Implementation

	Approved by	Date
User Experience	Christian Jansen	August 23, 2005
Development	Shilpa Sreeramulu	August 31, 2005
Quality Assurance	Oliver Crämer	September 6, 2005
Documentation	Uwe Fischer	August 31, 2005
String Review	n/a	n/a

Document Change History

Rev. Level	Change	Initials	Date
1	Initial spec created	SS	August 09, 2005
2	Reviewed and approved	CJ	August 23, 2005
3	Supported features listed on request of CJ and OC	SS	August 31, 2005

Contents

Glossary	1

1	Motivation	1

2	User Scenarios	1

3	Goals	1

4	Requirements and Dependencies	1

4.1	Requirements	1

4.2	Technical Dependencies	1

5	Competitive Analyses	2

6	Detailed Specification	2

6.1	G11n	3

6.2	Error Conditions	3

6.3	Migration	3

7	Future Tasks	3

8	Notes	3

9	References	3

Glossary

Term	Description
OOo 2.0	OpenOffice.org 2.0
Qpro	Corel Quattro Pro 6.0
Opcodes	Every file has a particular format in which it is stored. This file i stored in the binary format containing sequence of bytes. There are specific bytes which indicate the operation to be done. such bytes are called opcodes.

Motivation

To view the Corel Qpro 6.0. files in OOo 2.0.

User Scenarios

Users are not able to view the Qpro 6.0 files in OOo.

Goals

Import filters to be supported so that the basic features like strings, numbers, formulas and fonts in Qpro 6.0 files are rendered in OOo Calc. When ever a user tries to open a Qpro file that contains strings, numbers or formulas with different font styles applied to it in Calc, the file must open properly with the .wb2 extension and there must be no loss of data.

Requirements and Dependencies

Requirements

The Qpro file that contains the strings with different font attributes like bold,italic,underlined and numbers with the different font attributes and all the formulas that are supported in Qpro to be supported in OOo. The requirement was to open a Qpro file with all the above listed features smoothly in OOo Calc. We support only the import functionality and not the export filter, which means that we would be able to save a Qpro file only in the Calc format and not in its original format.

Technical Dependencies

None

Competitive Analyses

The Various spreadsheets like Microsoft Excel and Gnumeric support the Qpro file format.

Detailed Specification

Over View

This is a feature that makes Quattro Pro files inter operable with OOo Calc. This filter is an import filter that allows a user to open a file quattro pro file with the extension .wb2 in OOo. When a Qpro file which contains strings,numbers or formulas is opened in OOo Calc, then all the above type of data must be visible in Calc. Also there must be no loss of data.

CJ: A detailed list of what can be imported would be great.
We also have a support for the font styles to all the above type of data namely Bold font, italic and underlined. These font styles can be applied to strings, numbers as well as formulas. When Qpro files with such data are viewed in OOo Calc, we must be able to see the different font styles also

There is an entry in the filter list box namely “Quattro Pro 6.0”, using which the user can select the file type and open the files. This filter can be added to the spreadsheet group of file type list.

String list

Item	English	German	Comments
	Quattro Pro 6.0 (*.wb2)	Quattro Pro 6.0 (*.wb2)	

Details

There is no impact of this feature on any other code in OOo. The Qpro file format is simple. There are different opcodes indicating different types of cells like string cell, number cell and so on. The filter parses the input file stream, looks for the various opcodes and calls the necessary function for different type of cells.

There is an exclusive function written to handle the formula cells. All the operators and operands are pushed on to a stack and then popped out finally to calculate the final value.

The strings of different length, numbers( floating point and integers ), formulas supported in Qpro 6.0 are getting rendered in OOo Calc. Also the different font types and font styles namely italic, bold and underlined supported in Qpro 6.0 are also rendered. The Cell alignment, both horizontal and vertical and wrapping of cell contents also gets displayed in Calc.
Our current support is only for import filter for Qpro files. We cannot save a file back in Qpro format. If we have to save the file, we need to save in OOo format only.

The Following are the list of features that are supported.

Strings : All Qpro files containing strings with the bold, italic and underlined formats can be opened in Calc.

Numbers : Integers and floating point numbers can be imported, but the different number formats like Percentage, scientific etc are not yet supported.

Formulas : The reference link given below gives the file format details for Qpro. As given in that there are about 162 formulae supported in Qpro. All those formulas listed there are supported.

Alignment and Orientation : The cell contents with the alignment centre, right, left, top, bottom can be rendered in Calc. The top-to-bottom and left-to-right orientation of cell contents can be rendered in Calc.

Wrapping : The cell contents when wrapped in Qpro can be viewed in the similar style in Calc also.

Tab Order

n/a

Key Board Shortcuts

No keyboard shortcuts

G11n

n/a

Error Conditions

No new error conditions inserted.

Migration

There are no migration issues involved.

Future Tasks

Notes

References

http://www.corel.com/

http://web.archive.org/web/20021020204833/http://www.corel.com/partners_developers/ds/co32sdk/docs/qp7/qpf1copy.htm

Corel Quattro Pro 6.0 import filter

Page 3

http://specs.openoffice.org/calc/filters/qpro/qpro6.sxw

Eike Rathke

2004-12-15T16:39:32