Lotus 1-2-3 Wk4 File Converter Download
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.
Lotus 1-2-3 Wk4 File Converter Download
Lotus 1-2-3 inspired imitators, the first of which was Mosaic Software's "The Twin", written in the fall of 1985 largely in the C language, followed by VP-Planner, which was backed by Adam Osborne. These were able to not only read 1-2-3 files, but also execute many or most macro programs by incorporating the same command structure. Copyright law had first been understood to only cover the source code of a program. After the success of lawsuits which claimed that the very "look and feel" of a program were covered, Lotus sought to ban any program which had a compatible command and menu structure. Program commands had not been considered to be covered before, but the commands of 1-2-3 were embedded in the words of the menu displayed on the screen. 1-2-3 won its 3-year long court battle against Paperback Software International and Mosaic Software Inc. in 1990. However, when it sued Borland over its Quattro Pro spreadsheet in Lotus v. Borland, a 6-year battle that ended at the Supreme Court in 1996, the final ruling appeared to support narrowing the applicability of copyright law to software; this is because the lower court's decision that it was not a copyright violation to merely have a compatible command menu or language was upheld, but only via stalemate. In 1995, the First Circuit found that command menus are an uncopyrightable "method of operation" under section 102(b) of the Copyright Act. The 1-2-3 menu structure (example, slash File Erase) was itself an advanced version of single letter menus introduced in VisiCalc. When the case came before the Supreme Court, the justices would end up deadlocked 4-4. This meant that Borland had emerged victorious, but the extent to which copyright law would be applicable to computer software went unaddressed and undefined.
Microsoft's early spreadsheet Multiplan eventually gave way to Excel, which debuted on the Macintosh in 1985. It arrived on PCs with the release of Windows 2.x in 1987, but as Windows was not yet popular, it posed no serious threat to Lotus's stranglehold on spreadsheet sales. However, Lotus suffered technical setbacks in this period. Version 3 of Lotus 1-2-3, fully converted from its original macro assembler to the more portable C language, was delayed by more than a year as the totally new 1-2-3 had to be made portable across platforms and fully compatible with existing macro sets and file formats. The inability to fit the larger code size of compiled C into lower-powered machines forced the company to split its spreadsheet offerings, with 1-2-3 release 3 only for higher-end machines, and a new version 2.2, based on the 2.01 assembler code base, available for PCs without extended memory. By the time these versions were released in 1989, Microsoft had eroded much of Lotus's market share.
Macros in version one and add-ins (introduced in version 2.0) contributed much to 1-2-3's popularity, allowing dozens of outside vendors to sell macro packages and add-ins ranging from dedicated financial worksheets like F9 to full-fledged word processors. In the single-tasking MS-DOS, 1-2-3 was sometimes used as a complete office suite. All major graphics standards were supported; initially CGA and Hercules, and later EGA, AT&T, and VGA. Early versions used the filename extension "WKS". In version 2.0, the extension changed first to "WK1", then "WK2". This later became "WK3" for version 3.0 and "WK4" for version 4.0.
Lotus 1-2-3 file formats use various filename extensions including 123, wks, wk1, wk2, wk3, wk4, some of these may open in the desktop applications of Collabora Online, LibreOffice and Apache OpenOffice, these can then be saved into the OpenDocument format or other file formats.
That is an accurate reflection of my experience of excel so far. The only other advice from a user forum is to purchase 3rd party software from an unknown source to do what i thought excel might be able to do. Given that my confidence in excel to do anything useful has been dented - would i be better off to un-install microsoft excel and buy a new spreadsheet program from lotus ? Any views ? Has anyone ever managed to get excel to recognise a lotus file ? If so, how is it done please ?
I've never used 123, but I did find this in the Excel 2002 help file...'----------------------------------------------------About opening and saving files from other programsSome of the content in this topic may not be applicable to some languages.You can open a file created in another program, such as Lotus 1-2-3 or Quattro Pro, in Microsoft Excel the same way you would openan Excel file. You can then save the file in its original file format or as an Excel workbook using the standard Excel savecommands. Files saved as Excel workbooks might not retain all of their original formatting, and features and formatting of an Excel2002 workbook might not be available in other programs.Changing the default file format for saving workbooksIf you work with others who use earlier versions of Excel or other spreadsheet programs, you can change the default file format usedto save workbooks you create in Excel 2002.Supported Lotus 1-2-3 and Quattro Pro versionsExcel can directly open files from Lotus 1-2-3 versions up through 4.0 (*.wk?) and Quattro Pro for Windows versions 5.0 and 7.0 byusing the Quattro Pro converter. To open a file from a later Quattro Pro version in Excel, either save the file in an earlierQuattro Pro format, or save the file in another format, such as Lotus 1-2-3 (*.wk?). Although you can open Quattro Pro for MS-DOSand Quattro Pro for Windows files, there are some limitations to opening the worksheets.If you didn't install the converter for Quattro Pro files when you installed Excel, you must install it before you can open files inthat format. You can't use the Quattro Pro file converter to save files. You will need to install the Quattro Pro converters fromthe Microsoft Office Web site.'-------------------------------------Regards,Jim ConeSan Francisco, CA wrote in message news:1e4a201c454d1$27472ad0$a001...@phx.gbl...
the official advice from microsoft is that if your version of excel won't open a file created in lotus the only solution is to go out and buy a converter from a 3rd party if you reallly want to use excel 2002. I think this is one of the saddest examples i've seen a pathetic response. The impression one gets is that microsoft have set out to make life really difficult for anyone who tries to use a competitors product (lotus) in combination with their own thereby hoping to force excel users to drop lotus altogether. If this were to be the case - it suggests a level of business ethics and morality somewhere below that of spammers and porn merchants. I sincerely hope i am wrong - god help all of us if their response indicates the true ethical standing of microsoft.
> Thanks for your reply - since then i've had an "official" response from microsoft direct - i'll happily post a copy if you like ->> the official advice from microsoft is that if your version of excel won't open a file created in lotus the only solution is to goout and buy a converter from a 3rd party if you reallly want to use excel 2002.>> I think this is one of the saddest examples i've seen a pathetic response. The impression one gets is that microsoft have setout to make life really difficult for anyone who tries to use a competitors product (lotus) in combination with their own therebyhoping to force excel users to drop lotus altogether. If this were to be the case - it suggests a level of business ethics andmorality somewhere below that of spammers and porn merchants. I sincerely hope i am wrong - god help all of us if their responseindicates the true ethical standing of microsoft.
'Convert XLS' is a simple to use, yet powerful Excel converter utility specifically designed for Excel, fixed width textand CSV (character/comma delimited) files.If you need to convert/manipulate one or thousands of files, located in one or many folders this is the tool! Conversions can be done 10-20times faster without using MS Excel.
WK4 is a standard spreadsheet file that stores data in cells organized into rows and columns. Each cell can contain arbitrarily long strings of characters, numbers, or formulas (a formula is a function that returns a value based on input data). WK4 files were also supported by older version of Microsoft Excel. Lotus 1-2-3 was developed in 1982 and is no longer used.
The inability to open and operate the WK4 file does not necessarily mean that you do not have an appropriate software installed on your computer. There may be other problems that also block our ability to operate the Lotus 1-2-3 Version 4.x Spreadsheet Format file. Below is a list of possible problems.
BIFF 2/3 XLS are single-sheet streams of binary records. Excel 4 introducedthe concept of a workbook (XLW files) but also had single-sheet XLS format.The structure is largely similar to the Lotus 1-2-3 file formats. BIFF5/8/12extended the format in various ways but largely stuck to the same record format.
Running make init will refresh the test_files submodule and get the files.Note that this requires svn, git, hg and other commands that may not beavailable. If make init fails, please download the latest version of the testfiles snapshot from the repo
As explained in Test Files, on Windows the release ZIP file mustbe downloaded and extracted. If Bash on Windows is available, it is possibleto run the OSX/Linux workflow. The following steps prepares the environment: