Corel wordperfect office 2002 Manuel D’Utilisation
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.
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.
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.
4 Click Tools } Data tools } Combine files.
5 Click Browse
5 Click Browse
and select the source notebook.
This notebook contains the incoming values; no changes are made to this notebook.
6 In the Source area, enable one of the following options:
Entire file — combines all data in the two files
Cell(s) — combines only data in the cells which you specify
7 In the Operation area, enable one of the following options:
Copy — inserts the exact contents of the source notebook
Add — adds the incoming values to the existing values
Subtract — subtracts the incoming values from the existing values
Multiply — multiplies the incoming values by the existing values
Divide — divides the existing values by the incoming values
Importing text into columns
You can import a text file and rearrange the text into columns at the same time.
As well, you can customize how delimited and fixed-width text files are parsed. You can adjust
As well, you can customize how delimited and fixed-width text files are parsed. You can adjust
the widths of imported columns and change their formatting options. You can also change the
format of imported rows, even skipping rows of your choice.
To import text into columns
1 Click Tools } Data tools } QuickColumns™.
2 Click the Range picker
2 Click the Range picker
in the Text source box and select the source cells.
3 Click the Range picker in the Destination box and select a location for the imported data.
4 From the Parse settings list box, choose one of the following:
4 From the Parse settings list box, choose one of the following:
Automatic — automatically determines how best to parse the imported text file
Delimited auto — automatically parses imported delimited text files
Fixed width auto — automatically parses imported fixed-width text files
If you want to view how data displays in the spreadsheet, click Format.
Managing files and data
223