Vladimir Savić❣️
#VisiCalc reconstructed https://zserge.com/posts/visicalc #programming #retrocomputing🖥
GripNews🌕 重建 VisiCalc：電子試算表的技術實作解析
➤ 從零開始重現經典電子試算表的核心架構
✤ https://zserge.com/posts/visicalc/
本文探討了世界上第一款電子試算表軟體 VisiCalc 的核心設計理念，並透過實作一個精簡的試算表模型來重現其功能。作者詳細闡述瞭如何構建數據結構以儲存儲存格狀態、開發遞迴下降剖析器來解析數學公式，以及透過簡單的迭代演算法處理儲存格間的相互依賴關係。這份指南展示瞭如何以極簡的代碼邏輯，實現試算表這種影響深遠的軟體架構，體現了軟體工程中「少即是多」的精髓。
+ 這篇文章非常精彩！當年 6502 匯編語言下的 VisiCalc 確實是軟體工程的奇蹟，透過這種簡單的迭代重算邏輯，竟能推動整個個人電腦產業的商業化進程。
+ 遞迴下降剖析器的教學很清晰，對於理解 Excel 等現代軟體如何處理公式非常有幫助。雖然現代軟體會用依賴圖（Dependency Graph）來優化，但這種迭代法在概念上真的直觀多了。
#軟體工程 #電腦科學史 #編程實踐 #VisiCalc
➤ 從零開始重現經典電子試算表的核心架構
✤ https://zserge.com/posts/visicalc/
本文探討了世界上第一款電子試算表軟體 VisiCalc 的核心設計理念，並透過實作一個精簡的試算表模型來重現其功能。作者詳細闡述瞭如何構建數據結構以儲存儲存格狀態、開發遞迴下降剖析器來解析數學公式，以及透過簡單的迭代演算法處理儲存格間的相互依賴關係。這份指南展示瞭如何以極簡的代碼邏輯，實現試算表這種影響深遠的軟體架構，體現了軟體工程中「少即是多」的精髓。
+ 這篇文章非常精彩！當年 6502 匯編語言下的 VisiCalc 確實是軟體工程的奇蹟，透過這種簡單的迭代重算邏輯，竟能推動整個個人電腦產業的商業化進程。
+ 遞迴下降剖析器的教學很清晰，對於理解 Excel 等現代軟體如何處理公式非常有幫助。雖然現代軟體會用依賴圖（Dependency Graph）來優化，但這種迭代法在概念上真的直觀多了。
#軟體工程 #電腦科學史 #編程實踐 #VisiCalc
N-gated Hacker News🖥️ Ah, yes, the riveting tale of how spreadsheets—those glorified tables that haunt our work lives—came to be. #VisiCalc, the "GameBoy game" of its time, apparently revolutionized #computing with its primitive charm and jaw-dropping 16K RAM requirement. 🙄 One can only imagine the thrill of rebuilding a 1979 relic while the rest of us are busy enjoying the luxury of actual modern technology. 😂
https://zserge.com/posts/visicalc/ #spreadsheets #techhistory #nostalgia #HackerNews #ngated
https://zserge.com/posts/visicalc/ #spreadsheets #techhistory #nostalgia #HackerNews #ngated
Hacker News
Paolo AmorosoSerge Zaitsev @zserge explains how to develop a minimal VisiCalc clone in C.
Christopher DrumRE: https://mastodon.social/@stonetoolsblog/116184728275122986
I've been good friends with #VisiCalc over the past five years, but I've always turned my nose up at #Lotus123 for some reason. "Thinks he's so special. He's not special. Just a copycat wannabe jerk and..." well, I'll save all that for therapy.
I finally broke down and learned it, and you know what? I didn't hate it. I liked it, even. Maybe I even... loved it?!
#retrocomputing
Stone Tools🪨 Lotus 1-2-3 on the PC w/DOS 🛠️
Did you know that #Lotus123 is still referenced in Microsoft #Excel documentation to this day, but not #visicalc I finally spent some time getting to know VisiCalc's literal killer. When I struggled to get a chart made, I turned to the only one who could help me: an AI. From 1986!
#retrocomputing #spreadsheet
Paul 
Here's some tech nostalgia for you: "... comprehensive documentation of the original #VisiCalc source code for the Apple II, focusing on creating a fully annotated version of the 6502 assembly code."
Olly 👾
Spreadsheets Apple II Style.
It is hard to remember a time when no one had a spreadsheet. Sure, you had big paper ledgers if you were an accountant. But most people just scribbled their math on note paper or, maybe, an engineering pad. [Christopher Drum] wanted to look at what the state of the art in 1978 spreadsheet technology could do. So he ran VisiCalc.
https://stonetools.ghost.io/visicalc-apple2/
#apple2 #visicalc #spreadsheet #apple #retro #computing #media #history #tech #news
David JONESI'm using #Visicalc to plan a personal project. Some thoughts:
Getting a DOS emulator working on macOS is increasingly annoying.
Visicalc is great :).
Driving from the keyboard is _wonderful_.
Seems to only work in 80x25 mode even when i switch in DOS.
Annoying bug when saving where it fails to overwrite an existing file (in fact, deletes it).
The date and time in the emulated DOS seems to be wrong, probably not accounting for suspend/resume.
Lacks conventional cut-and-paste (it predates it).