Microsoft KB Archive/49763

From BetaArchive Wiki

Works: Converting Lotus Jazz Spreadsheets PSS ID Number: Q49763 Article last modified on 05-12-1993 PSS database name: M_WorKs

1.00 1.10 2.00


The information in this article applies to:
- Microsoft Works for the Macintosh, versions 1.x and 2.0



To open a Lotus Jazz Spreadsheet into Microsoft Works versions 1.x and 2.00, the Jazz Spreadsheet must first be saved as a text file. However, the Jazz Spreadsheet cannot be directly saved to a text file. The data must first be copied into a Jazz Word Processor document and then saved as text.

Use the following procedure to convert a Spreadsheet file from Jazz to Microsoft Works:

In Jazz

  1. Open the Spreadsheet document in Jazz.
  2. From the Edit menu, choose Select All.
  3. From the Range menu, choose Format.
  4. Select the Formula Text option and click OK.
  5. From the Edit menu, choose Copy.
  6. Close the Spreadsheet document.
  7. Open a new Word Processor document.
  8. From the Edit menu, choose Paste. Ignore how the text is formatted because the tabs do not line up properly.
  9. From the File menu, choose Save As and type a name for the document.
  10. Select Text Only and then click the Save button.

Note: Any Jazz formulas with different names or syntax do not translate properly. See the comparison chart below for differences between Jazz and Works functions. If your spreadsheet contains any ranges in formulas, see the section below on converting Jazz references.

In Works

  1. Open Works.
  2. Select the Spreadsheet icon in the Open dialog box.
  3. Click the Import button.
  4. Select the file and click the Open button.

Converting Jazz Ranges in Works

Ranges in Jazz use a different syntax than Works. For example, Jazz uses “A1..A3” to indicate a range, while Works uses “A1:A3”. Proper syntax can easily be converted within Works. If a Jazz spreadsheet used ranges in its formulas, open the text document created above in Jazz into a Works Word Processor document (see above instructions).

After opening the document, do the following:

  1. From the Search menu, choose Replace. In the Find What box, type “..” (without the quotation marks). In the Replace With box, type “:” (without the quotation marks).
  2. Click the Replace All button.
  3. You can repeat steps 1 and 2 to convert some of the Jazz functions to the appropriate Works functions.
  4. From the File menu, choose Save As.
  5. Select Export File and enter a name for the document.
  6. Click the Save button.
  7. To open the saved text file into the Spreadsheet, follow the instructions above for opening text files into Works.

Additional reference words: convert import export mswksdb mswksss mswksconv 3rdparty

Copyright Microsoft Corporation 1993.