Want to feel old? Excel just entered its 40th year
(2024/10/22)
- Reference: 1729589654
- News link: https://www.theregister.co.uk/2024/10/22/excel_enters_its_40th_year/
- Source link:
Microsoft Excel, the true successor to the throne of COBOL. Version 1.0 was released on the last day of September 1985, four decades ago.
Since the original US English version of Windows 1.0 went to manufacturing at the end of November that year, this means that the default spreadsheet for Microsoft Windows is itself older than Windows. (The European version of Windows didn't appear until [1]May 1986 , but that doesn't really matter, nobody cared about it either.)
[2]
Excel 2 wasn't pretty, but it was prettier than 1-2-3 – click to enlarge
As the old joke goes, like an "incel", it still [3]incorrectly assumes what constitutes a date, to the [4]vexation of geneticists – and their [5]eventual surrender .
Yes, Excel 1 was a [6]Mac application , and originally a Mac-only application. The first Windows version only followed a few years later, when in 1987 Microsoft [7]ported Excel 2 to Windows .
The tender, greenhorn Reg FOSS desk supported it for multiple customers on Windows 2. Even though Windows 2 itself was a bit of a joke, Excel was a compelling enough app that customers tolerated it just to get a graphical spreadsheet, and it even shipped with a copy of Runtime Windows, a special, heavily cut-down version of Windows 2 with no shell, which let you execute a Windows application from DOS. It loaded enough of Windows to start the app as the sole UI, and when you quit the app, it exited back to DOS again.
[8]
Experience the raw power of two files at once, side by side – click to enlarge
Excel didn't pioneer the market. Spreadsheets have been the key tool of the microcomputer industry for pretty much as long as there has been a microcomputer industry. Arguably, the [9]first one was VisiCalc , which is the app that made Apple's initial fortune by selling an awful lot of Apple II computers. [10]According to Steve Jobs , anyway. (Yes, we did slightly miss [11]Spreadsheet Day . Feel free to complain in the comments.)
Then came IBM's PC, imitating one key element of the Apple II by incorporating lots of internal expansion slots, and thus inspiring a famous Apple advertisement.
[12]
Apple Wall Street Journal advertisement – click to enlarge
There was a version of VisiCalc for the new IBM operating system, MS-DOS 1.0, and thanks to co-creator Dan Bricklin you can [13]download it for free , all 27 KB of it. It didn't take full advantage of the machine's hardware, though, and remained nearly as limited as its eight-bit Apple forebear.
That opening was exploited by [14]Lotus with 1-2-3 , which, if you're determined enough, you can [15]run under DOSBox . Or, of course, thanks to Tavis Ormandy, [16]run it natively on Linux instead. For its time, it was very powerful. The name came from the way it integrated number-crunching, extremely basic database facilities (you could define ranges and search or sort), and graphing.
[17]
It also bypassed MS-DOS and hit the metal of the IBM PC directly for better performance. That had multiple side effects. As well as selling a lot of IBM PCs, 1-2-3's stringent compatibility requirements also led to the creation and flourishing of the clone industry. And, thrown in, the [18]Lotus-Intel-Microsoft specification for [19]Expanded Memory – the only way to access more than 640 KB from MS-DOS on the early 8088 and 8086 PCs.
[20]Python in Excel goes live – but only for certain Windows users
[21]Techie told 'Bill Gates' Excel is rubbish – and the Microsoft boss had it fixed in 48 hours
[22]Facebook prank sent techie straight to Excel hell
[23]Election Excel blunder declared a 'low point' for Austrian social democracy
A brief play with 1-2-3 for DOS – or Linux – will effectively demonstrate why [24]Excel rapidly displaced it . Excel was dramatically easier to understand and use, and although there were other graphical spreadsheet programs out there – you can [25]still buy Quattro Pro – Excel got in early and established its dominance. Forty years later, Excel formulas effectively constitute [26]the world's most widely used programming language .
IBM [27]discontinued Smartsuite a decade ago , including the final release of 1-2-3 for Windows. Like WordPerfect, after a rocky start (and the wasted effort of OS/2 versions), it developed into a perfectly serviceable Windows app… but too little, too late.
[28]
Downloadable CD images can be found in a few places out there, and in response to a reader query, we tried it a couple of years ago and it installs and runs fine on Windows 11, except for online help.
Lotus also had a far more radical spreadsheet, the [29]multidimensional Improv , billed as Spreadsheets Done Right. It started out on the NeXT Computer, then was successfully translated to Windows… where it flopped. I evaluated version 1.0 for Windows for my then employer, and it was a vision of a smarter future – but if you already knew how to navigate the conventional 1970s-style rectangular grid of cells, it was too late. The [30]mental damage was already done.
[31]
Excel, meanwhile, will still [32]cost you a few hundred bucks , of course. That may be the best tribute to its staying power. ®
Get our [33]Tech Resources
[1] https://microsoft.fandom.com/wiki/Windows_1.0
[2] https://regmedia.co.uk/2017/11/22/excel-about.png
[3] https://www.instagram.com/nickpalmisciano/p/CCcwOr9g3Wv/
[4] https://www.theregister.com/2016/08/25/excel_hell_messes_up_20_per_cent_of_genetic_science_papers/
[5] https://www.theregister.com/2020/08/06/excel_gene_names/
[6] https://www.versionmuseum.com/history-of/microsoft-excel
[7] https://www.theregister.com/2017/11/24/microsoft_excel_30_years_old/
[8] https://regmedia.co.uk/2017/11/22/excel_edit_screenshot.png
[9] http://www.bricklin.com/firstspreadsheetquestion.htm
[10] https://qz.com/1103867/visicalc-and-apple-aapl-steve-jobs-said-that-the-spreadsheet-was-key-to-apples-early-success
[11] https://www.theregister.com/2020/10/16/happy_spreadsheet_day/
[12] https://regmedia.co.uk/2013/01/14/apple_ad_welcome_ibm_seriously.jpg
[13] http://www.bricklin.com/history/vcexecutable.htm
[14] https://www.theregister.com/2013/01/26/mitch_kapor_lotus_123_anniversary/
[15] https://www.theregister.com/2013/01/28/lotus_1_2_3_rebooted/
[16] https://www.theregister.com/2022/05/25/lotus_123_for_linux_appears/
[17] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/applications&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2Zxd3xgrroCZoV3csRxdzrwAAAIE&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[18] https://www.phatcode.net/res/218/files/limems40.txt
[19] https://foldoc.org/Expanded+Memory+Specification
[20] https://www.theregister.com/2024/09/18/python_in_excel_general_release/
[21] https://www.theregister.com/2024/08/09/on_call/
[22] https://www.theregister.com/2024/07/22/who_me/
[23] https://www.theregister.com/2023/06/06/austria_election_excel_blunder/
[24] https://www.theregister.com/2013/01/31/when_lotus_met_excel/
[25] https://www.wordperfect.com/en/pages/old-brands/quattro-pro/
[26] https://www.theregister.com/2020/12/04/microsoft_excel_lambda/
[27] https://www.theregister.com/2014/10/02/so_long_lotus_123_ibm_ceases_support_after_over_30_years_of_code/
[28] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/applications&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Zxd3xgrroCZoV3csRxdzrwAAAIE&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[29] https://instadeq.com/blog/posts/no-code-history-lotus-improv-spreadsheets-done-right-1991/
[30] https://www.cs.scranton.edu/~mccloske/dijkstra_quotes.html
[31] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/applications&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Zxd3xgrroCZoV3csRxdzrwAAAIE&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[32] https://www.theregister.com/2024/10/04/office_2024/
[33] https://whitepapers.theregister.com/
Since the original US English version of Windows 1.0 went to manufacturing at the end of November that year, this means that the default spreadsheet for Microsoft Windows is itself older than Windows. (The European version of Windows didn't appear until [1]May 1986 , but that doesn't really matter, nobody cared about it either.)
[2]
Excel 2 wasn't pretty, but it was prettier than 1-2-3 – click to enlarge
As the old joke goes, like an "incel", it still [3]incorrectly assumes what constitutes a date, to the [4]vexation of geneticists – and their [5]eventual surrender .
Yes, Excel 1 was a [6]Mac application , and originally a Mac-only application. The first Windows version only followed a few years later, when in 1987 Microsoft [7]ported Excel 2 to Windows .
The tender, greenhorn Reg FOSS desk supported it for multiple customers on Windows 2. Even though Windows 2 itself was a bit of a joke, Excel was a compelling enough app that customers tolerated it just to get a graphical spreadsheet, and it even shipped with a copy of Runtime Windows, a special, heavily cut-down version of Windows 2 with no shell, which let you execute a Windows application from DOS. It loaded enough of Windows to start the app as the sole UI, and when you quit the app, it exited back to DOS again.
[8]
Experience the raw power of two files at once, side by side – click to enlarge
Excel didn't pioneer the market. Spreadsheets have been the key tool of the microcomputer industry for pretty much as long as there has been a microcomputer industry. Arguably, the [9]first one was VisiCalc , which is the app that made Apple's initial fortune by selling an awful lot of Apple II computers. [10]According to Steve Jobs , anyway. (Yes, we did slightly miss [11]Spreadsheet Day . Feel free to complain in the comments.)
Then came IBM's PC, imitating one key element of the Apple II by incorporating lots of internal expansion slots, and thus inspiring a famous Apple advertisement.
[12]
Apple Wall Street Journal advertisement – click to enlarge
There was a version of VisiCalc for the new IBM operating system, MS-DOS 1.0, and thanks to co-creator Dan Bricklin you can [13]download it for free , all 27 KB of it. It didn't take full advantage of the machine's hardware, though, and remained nearly as limited as its eight-bit Apple forebear.
That opening was exploited by [14]Lotus with 1-2-3 , which, if you're determined enough, you can [15]run under DOSBox . Or, of course, thanks to Tavis Ormandy, [16]run it natively on Linux instead. For its time, it was very powerful. The name came from the way it integrated number-crunching, extremely basic database facilities (you could define ranges and search or sort), and graphing.
[17]
It also bypassed MS-DOS and hit the metal of the IBM PC directly for better performance. That had multiple side effects. As well as selling a lot of IBM PCs, 1-2-3's stringent compatibility requirements also led to the creation and flourishing of the clone industry. And, thrown in, the [18]Lotus-Intel-Microsoft specification for [19]Expanded Memory – the only way to access more than 640 KB from MS-DOS on the early 8088 and 8086 PCs.
[20]Python in Excel goes live – but only for certain Windows users
[21]Techie told 'Bill Gates' Excel is rubbish – and the Microsoft boss had it fixed in 48 hours
[22]Facebook prank sent techie straight to Excel hell
[23]Election Excel blunder declared a 'low point' for Austrian social democracy
A brief play with 1-2-3 for DOS – or Linux – will effectively demonstrate why [24]Excel rapidly displaced it . Excel was dramatically easier to understand and use, and although there were other graphical spreadsheet programs out there – you can [25]still buy Quattro Pro – Excel got in early and established its dominance. Forty years later, Excel formulas effectively constitute [26]the world's most widely used programming language .
IBM [27]discontinued Smartsuite a decade ago , including the final release of 1-2-3 for Windows. Like WordPerfect, after a rocky start (and the wasted effort of OS/2 versions), it developed into a perfectly serviceable Windows app… but too little, too late.
[28]
Downloadable CD images can be found in a few places out there, and in response to a reader query, we tried it a couple of years ago and it installs and runs fine on Windows 11, except for online help.
Lotus also had a far more radical spreadsheet, the [29]multidimensional Improv , billed as Spreadsheets Done Right. It started out on the NeXT Computer, then was successfully translated to Windows… where it flopped. I evaluated version 1.0 for Windows for my then employer, and it was a vision of a smarter future – but if you already knew how to navigate the conventional 1970s-style rectangular grid of cells, it was too late. The [30]mental damage was already done.
[31]
Excel, meanwhile, will still [32]cost you a few hundred bucks , of course. That may be the best tribute to its staying power. ®
Get our [33]Tech Resources
[1] https://microsoft.fandom.com/wiki/Windows_1.0
[2] https://regmedia.co.uk/2017/11/22/excel-about.png
[3] https://www.instagram.com/nickpalmisciano/p/CCcwOr9g3Wv/
[4] https://www.theregister.com/2016/08/25/excel_hell_messes_up_20_per_cent_of_genetic_science_papers/
[5] https://www.theregister.com/2020/08/06/excel_gene_names/
[6] https://www.versionmuseum.com/history-of/microsoft-excel
[7] https://www.theregister.com/2017/11/24/microsoft_excel_30_years_old/
[8] https://regmedia.co.uk/2017/11/22/excel_edit_screenshot.png
[9] http://www.bricklin.com/firstspreadsheetquestion.htm
[10] https://qz.com/1103867/visicalc-and-apple-aapl-steve-jobs-said-that-the-spreadsheet-was-key-to-apples-early-success
[11] https://www.theregister.com/2020/10/16/happy_spreadsheet_day/
[12] https://regmedia.co.uk/2013/01/14/apple_ad_welcome_ibm_seriously.jpg
[13] http://www.bricklin.com/history/vcexecutable.htm
[14] https://www.theregister.com/2013/01/26/mitch_kapor_lotus_123_anniversary/
[15] https://www.theregister.com/2013/01/28/lotus_1_2_3_rebooted/
[16] https://www.theregister.com/2022/05/25/lotus_123_for_linux_appears/
[17] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/applications&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=2&c=2Zxd3xgrroCZoV3csRxdzrwAAAIE&t=ct%3Dns%26unitnum%3D2%26raptor%3Dcondor%26pos%3Dtop%26test%3D0
[18] https://www.phatcode.net/res/218/files/limems40.txt
[19] https://foldoc.org/Expanded+Memory+Specification
[20] https://www.theregister.com/2024/09/18/python_in_excel_general_release/
[21] https://www.theregister.com/2024/08/09/on_call/
[22] https://www.theregister.com/2024/07/22/who_me/
[23] https://www.theregister.com/2023/06/06/austria_election_excel_blunder/
[24] https://www.theregister.com/2013/01/31/when_lotus_met_excel/
[25] https://www.wordperfect.com/en/pages/old-brands/quattro-pro/
[26] https://www.theregister.com/2020/12/04/microsoft_excel_lambda/
[27] https://www.theregister.com/2014/10/02/so_long_lotus_123_ibm_ceases_support_after_over_30_years_of_code/
[28] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/applications&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Zxd3xgrroCZoV3csRxdzrwAAAIE&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[29] https://instadeq.com/blog/posts/no-code-history-lotus-improv-spreadsheets-done-right-1991/
[30] https://www.cs.scranton.edu/~mccloske/dijkstra_quotes.html
[31] https://pubads.g.doubleclick.net/gampad/jump?co=1&iu=/6978/reg_software/applications&sz=300x50%7C300x100%7C300x250%7C300x251%7C300x252%7C300x600%7C300x601&tile=4&c=44Zxd3xgrroCZoV3csRxdzrwAAAIE&t=ct%3Dns%26unitnum%3D4%26raptor%3Dfalcon%26pos%3Dmid%26test%3D0
[32] https://www.theregister.com/2024/10/04/office_2024/
[33] https://whitepapers.theregister.com/