Lotus 1-2-3

From Just Solve the File Format Problem
(Difference between revisions)
Jump to: navigation, search
(Category:Lotus)
(Sample files)
 
(2 intermediate revisions by 2 users not shown)
Line 15: Line 15:
  
 
== Format specs ==
 
== Format specs ==
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF1.TXT Spec introduction]
+
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF1.TXT Spec introduction] [https://web.archive.org/web/20180129005324/http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF1.TXT (archived)]
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF2.TXT Summary of record types]
+
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF2.TXT Summary of record types] [https://web.archive.org/web/20180130195323/http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF2.TXT (archived)]
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF3.TXT Cell format encoding]
+
* [http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF3.TXT Cell format encoding] [https://web.archive.org/web/20180130195328/http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF3.TXT (archived)]
* [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] [https://web.archive.org/web/20180130195348/http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF4.TXT (archived)]
* [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] [https://web.archive.org/web/20180130195353/http://www.schnarff.com/file-formats/lotus-1-2-3/WSFF5.TXT (archived)]
  
 
== End of support ==
 
== End of support ==
Line 30: Line 30:
 
* [http://www.opf-labs.org/format-corpus/office/spreadsheet/wk1/ Version 2.0 (WK1) samples]
 
* [http://www.opf-labs.org/format-corpus/office/spreadsheet/wk1/ Version 2.0 (WK1) samples]
 
* [http://www.opf-labs.org/format-corpus/office/spreadsheet/wk3/ Version 3.0 (WK3) samples]
 
* [http://www.opf-labs.org/format-corpus/office/spreadsheet/wk3/ Version 3.0 (WK3) samples]
* [ftp://ftp.lotus.com/product_information/123weval.zip ZIP file on Lotus FTP site with some WK1 and WK3 files]
+
* [ftp://ftp.lotus.com/product_information/123weval.zip ZIP file on Lotus FTP site with some WK1 and WK3 files] [https://archive.org/download/2012_11_24_ftp_lotus_com/2012.11.24.ftp.lotus.com.zip/ftp.lotus.com%2Fproduct_information%2F123weval.zip archived]
 +
* {{DexvertSamples|document/lotus123}}
  
 
== Import/export info ==
 
== Import/export info ==

Latest revision as of 15:21, 28 December 2023

File Format
Name Lotus 1-2-3
Ontology
Extension(s) .wks, .wk1, .wk2, .wk3, .wk4, .123
MIME Type(s) application/vnd.lotus-1-2-3
PRONOM x-fmt/116, x-fmt/117, x-fmt/114, x-fmt/115
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

[edit] Format specs

[edit] 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.

[edit] 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.

[edit] Sample files

[edit] Import/export info

[edit] See also

[edit] Other links

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox