lotus

previous page: 14.3 DIF (Data Interchange Format) (spreadsheets)
  
page up: Spreadsheets FAQ
  
next page: 14.5 Quattro and Quattro Pro formats (spreadsheets)

14.4 Lotus 1-2-3 and Symphony formats (spreadsheets)




Description

This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

14.4 Lotus 1-2-3 and Symphony formats (spreadsheets)

these are capable formats, but their complexity makes them unusable
for all but the most dedicated user.

http://ftp.support.lotus.com/ftp/pub/product_information/wsff.zip

http://www.wotsit.org/download.asp?f=wks
http://www.wotsit.org/download.asp?f=wsff

14.4.1 WKS format

Stores: Values, Equations, Simple formatting

File format descriptions can be found via the following anonymous
ftp sites

ftp://ftp.simtel.net/pub/simtelnet/msdos/spredsht/wksffmt.zip

http://simtel.coast.net/Coast/msdos/lotus123.html [defunct]

FILE: wksffmt.zip SIZE: 22,575 DATE: 900626
DESCRIPTION:
Description of Lotus .WKS & .WK1 file formats

Lotus File Formats for 1-2-3, Symphony, and Jazz
by the people at Lotus Development Corporation
ISBN 0-201-16824-3
Lotus Books
Addison-Wesley
Published 1986

compares VisiCalc files to 1-2-3 files; details file formats
for 1-2-3 1A, 2; Symphony 1.0, 1.1; PIC; Jazz; includes
Turbo Pascal program to convert text into WKS.

Turbo Pascal program obviously not typeset directly from
working source, and independently has various out-of-bounds
errors; table on p127 claims hex 0=dec 1; p141 claims Jazz
had 8192 (and 8191) columns and 256 (and 255) rows.

14.4.2 WK1 format

Stores: Values, Equations, Formatting, Named Regions [?]

Also See WKS format

14.4.3 WK3 format

Stores: Values, Equations, Formatting, Named Regions [?]

Also See WKS format

 

Continue to:













TOP
previous page: 14.3 DIF (Data Interchange Format) (spreadsheets)
  
page up: Spreadsheets FAQ
  
next page: 14.5 Quattro and Quattro Pro formats (spreadsheets)