Lotus 1-2-3

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
Line 18: Line 18:
 
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF4.TXT The Formula Compiler]
 
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF4.TXT The Formula Compiler]
 
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF5.TXT 1985 addendum]
 
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF5.TXT 1985 addendum]
 +
 +
== End of support ==
 +
IBM officially ceased its support for Lotus 123 on 30 September 2014 (see the [http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS913-091 announcement here]). This also applies to its SmartSuite and Organizer products.
  
 
== Support by modern spreadsheet software ==
 
== Support by modern spreadsheet software ==
Line 36: Line 39:
 
* [http://www.zdnet.com/goodbye-lotus-1-2-3-7000015385/ Goodbye, Lotus 1-2-3]
 
* [http://www.zdnet.com/goodbye-lotus-1-2-3-7000015385/ Goodbye, Lotus 1-2-3]
 
* [ftp://ftp.lotus.com/ Lotus FTP site] (Archived version [https://archive.org/details/2012_11_24_ftp_lotus_com here]) - many resources on Lotus products, including documentation, sample files, software.
 
* [ftp://ftp.lotus.com/ Lotus FTP site] (Archived version [https://archive.org/details/2012_11_24_ftp_lotus_com here]) - many resources on Lotus products, including documentation, sample files, software.
 +
 
[[Category:IBM]]
 
[[Category:IBM]]

Revision as of 14:06, 2 November 2014

File Format
Name Lotus 1-2-3
Ontology
Extension(s) .wks,.wk1,.wk2,.wk3,.wk4
MIME Type(s) application/vnd.lotus-1-2-3
Released 1983-01-26

Lotus 1-2-3 was regarded as the "killer app" of the IBM PC in its early days, just as VisiCalc was for the Apple II platform. Both were spreadsheets which used a similar interface, still familiar to modern spreadsheet users, consisting of a matrix of rows and columns where the columns have letters and the rows have numbers, and a cell can be addressed by an address such as "B2".

After years of dominance of the spreadsheet market for PC/MS-DOS, 1-2-3 failed to successfully move over to the Windows platform, and was eclipsed by Microsoft Excel. Making 1-2-3 part of a new "Lotus SmartSuite" didn't help bring it back to prominence. When 1-2-3 was finally officially discontinued in 2013 (by IBM, which now owns Lotus), the general reaction was "What, they still made 1-2-3 until now? I thought it died a long time ago."

The original 1-2-3 files had a .wks extension. Version 2.0 originally used a .wk1 extension, but that was soon changed to .wk2, and from then on the number in the extension corresponded to the program version number. Lotus Symphony (the '80s version, not the unrelated 2000s version which used a variant of Open Office format) used a similar file format.

Contents

Format specs

End of support

IBM officially ceased its support for Lotus 123 on 30 September 2014 (see the announcement here). This also applies to its SmartSuite and Organizer products.

Support by modern spreadsheet software

Support of the Lotus 1-2-3 formats has shown a steady decline over recent years. Although older versions of Microsoft Excel were able to read (some of?) these formats, Excel 2010 doesn't support any of them anymore, as shown in this overview of unsupported formats on Microsoft's website. Meanwhile, OpenOffice only supports the old (.wk1, .wks and .123) versions of the format (source here). No specific info could be found on LibreOffice, but the situation is probably identical to OpenOffice.

Sample files

Import/export info

Other links

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox