Login
You're viewing the functional.cafe public feed.
  • Nov 18, 2026, 7:45 PM

    RE: mastodon.social/@arstechnica/1

    The part that worries me is Excel.

    If every copy of Powerpoint on the planet stopped working tomorrow, nothing of any consequence would happen. You can replace Word with LibreOffice and get on with your life. Excel, though... between a quarter and a third of the world's money goes through an Excel spreadsheet every day. The joke about how every organization no matter how large is ultimately just half a dozen load-bearing spreadsheets in a trenchcoat is no joke at all.

    💬 25🔄 196⭐ 267

Replies

  • Nov 18, 2026, 7:49 PM

    @mhoye and there are literal places where regulations require Windows Excel and you can’t even use Mac Excel. They have different edge case behavior.

    It’s terrifying.

    💬 3🔄 0⭐ 22
  • Nov 18, 2026, 9:29 PM

    @petrillic @mhoye

    On top of that, LibreOffice kinda needs to up its document-scripting game. I used to be good at VBA, but I haven't been able to figure out how to actually do anything with scripts in Calc. Maybe it's just me...

    (...and then there's LibreBase, which is just arrgghh... but that's getting a bit off-topic.)

    [/opinion]

    💬 0🔄 0⭐ 5
  • 💬 0🔄 0⭐ 16
  • Nov 19, 2026, 4:23 AM

    @petrillic @mhoye Can you give an example of a regulation that requires Excel please? I'd like to be able to refer to this in a lecture I'm giving soon.

    💬 1🔄 0⭐ 3
  • 💬 1🔄 0⭐ 5
  • 💬 1🔄 0⭐ 0
  • 💬 1🔄 0⭐ 2
  • Nov 19, 2026, 9:10 AM

    @dryak @AngelaScholder @petrillic @robinadams @mhoye

    I would be shocked if LibreOffice came close enough to work for anything that used some of the weirder Excel features.

    I was at Microsoft when they were on a big push to improve Excel Online. The original version ran a complete Windows VM running Excel for each open spreadsheet. I think they worked out that if 1% of users switched to the online version it would bankrupt the company. They improved that hosting density a lot but had problems with latency.

    In Google Sheets, all of the calculations run in JavaScript in the browser. Excel Online did the same thing but only for a preview. You’d see some instances where changing a cell would trigger a big recalculation, all of the cells would get updated and then, a few seconds later, get updated with the correct values.

    The team next to mine had a big project to rewrite Excel’s calc engine in TypeScript. This was a neat project, but also very hard. There was no specification of the behaviour other than ‘what this 1980s C function does’. A somewhat terrifying codebase that included an 8087 emulator. The reimplementation came close, but the telemetry that compared its results to original version was still showing errors. I think their final solution was to compile the original calc engine to WebAssembly and embed it in the page.

    EDIT: Although there is no good test suite, the Enron lawsuits entered an enormous number of Excel sheets into evidence, which means that they’re now public. The ‘Enron Corpus’ is the closest thing anyone has to a test suite for Excel. I suspect the ‘NVIDIA Corpus’ will be similar in a few years.

    💬 0🔄 7⭐ 19
  • Nov 19, 2026, 11:32 AM

    @dryak

    though to be fair, even Excel isn't bug compatible with Excel. I've opened old Excel files in newer Excel and things change—fonts are off, sizings are odd, etc. Usually the formulae are correct and the numbers right, but long ago I stopped assuming files could carry forward without hiccups.

    @mhoye

    💬 0🔄 0⭐ 1
  • 💬 1🔄 1⭐ 10
  • 💬 0🔄 1⭐ 6
  • Paulthreedaymonk@sonomu.club
    Nov 18, 2026, 7:57 PM

    @mhoye Yeah, LibreOffice's spreadsheet is missing a lot of Excel's functionality, especially around arrays. The closest competitor in terms of feature support is probably Google Sheets, but that's not much of an escape from enLLMshittification.

    💬 1🔄 0⭐ 12
  • Nov 19, 2026, 4:37 PM

    @threedaymonk @mhoye is LibreOffice itself free of vibe coding?

    I'm asking, not snarking; I've become increasingly and uneasily aware of vibe coding intruding deeply into traditional FOSS spaces as well as the expected proprietary dev shops and stacks.

    💬 1🔄 0⭐ 1
  • 💬 0🔄 0⭐ 1
  • 💬 3🔄 1⭐ 11
  • Nov 18, 2026, 8:12 PM

    @steevmi1 Absolutely. Money is far from being the only thing of value stored in Excel.

    💬 0🔄 0⭐ 3
  • 💬 1🔄 0⭐ 1
  • 💬 1🔄 0⭐ 2
  • Nov 19, 2026, 1:39 PM

    @steevmi1 @gumnos @mhoye I can reliably make Excel eval text in CSVs as expressions just by loading the CSV. CSV files are data not code unless you're working in Excel. I'm not sure if this is legacy Lotus-123 behavior but I expect CSV values surrounded by quotes to be treated as text strings and absolutely not as expressions to be evaluated.

    Excel is an attractive hazard and not fit for purpose.

    💬 3🔄 0⭐ 0
  • Nov 19, 2026, 1:53 PM

    @arclight

    Hah, just hit this working a case for $DAYJOB yesterday, in which the exported-from-Excel CSV file had values like

    ="long string of digits"

    to prevent long numbers (IMEI/SIM numbers) from getting converted to floating-point. Which is good, but mean that my CSV-handling importer had to strip off the wrapper that had been causing the value-extraction to give the wrong data. :sigh:

    💬 0🔄 0⭐ 1
  • Nov 19, 2026, 2:02 PM

    @arclight @steevmi1 @gumnos

    Unfortunately for a generation of scientists in institutions largely captured by the managerial class, Excel was the only tool immediately to hand that did not require a round trip through a procurement process with a constrained budget in one hand and a publication deadline in the other.

    💬 1🔄 0⭐ 3
  • 💬 0🔄 0⭐ 1
  • 💬 0🔄 0⭐ 1
  • 💬 0🔄 0⭐ 0
  • Nov 18, 2026, 8:31 PM

    @mhoye I went to a Google Cloud event about a year ago in London and spoke to a few people who came from orgs "all in" on the Google platforms, aside from their Finance team...because of Excel.

    While there are perfectly good replacements (some of which are ribbon-less, so arguably better), Excel is ubiquitous.

    And it is not so much just the spreadsheet - VBA still haunts (too) many workplaces that have have yet to appreciate office scripts.

    💬 1🔄 0⭐ 5
  • Nov 18, 2026, 9:37 PM

    @plwt @mhoye One of my clients is an accounting firm, and they have to use their clients' systems. One of those clients has an Excel add-in that includes it's own private copy of Chromium that seems to be used solely for authentication to their ERP, which then runs entirely through Excel (with some custom forms here and there, but it's mostly just a huge spreadsheet).

    💬 0🔄 0⭐ 4
  • Nov 18, 2026, 9:12 PM

    @mhoye

    maybe it's not a bad thing? :)

    asbestos was a hugely used building material until it wasn't. 1/2 :)

    💬 1🔄 1⭐ 3
  • 💬 1🔄 0⭐ 1
  • 💬 1🔄 0⭐ 0
  • 💬 1🔄 0⭐ 1
  • 💬 0🔄 0⭐ 0
  • Nov 18, 2026, 9:30 PM

    @mhoye @arstechnica I use LibreOffice. I just finished my Master’s degree earlier this year and for several classes there was a lot of business type data analysis I needed to do. I either could not do it at all in Calc or I technically could but it was much more difficult (hand writing formula instead of Excel’s easy clicky clicky).

    Calc works great as a basic spreadsheet tool. It’s sorely lacking compared to Excel for built in data analysis tools.

    💬 0🔄 0⭐ 5
  • 💬 0🔄 0⭐ 0
  • Nov 18, 2026, 9:41 PM

    @mhoye OFFS, I run office, but I run it entirely offline via a licensed copy of Office, which they still sell, I believe. I refuse to use their Office 365...

    💬 0🔄 0⭐ 2
  • 💬 0🔄 0⭐ 2
  • Nov 18, 2026, 10:15 PM

    @mhoye excel is probably the only thing I think I like from Microsoft. Even then, I don't know if like is the right word but I can do everything on it that I need to. I use a NIST addin a lot but otherwise I wouldn't really need excel per say.

    I've tried libraoffice calc but it's a whole ordeal to do things that excel handles easily. Maybe it's just a familiarity thing but calc feels clunky.

    Are there any legitimate equals for Excel for spreadsheet use, making some charts and occasional macros when needed? I think Google docs was mentioned above however I view it as all the same problems as excel when it comes to a big tech product.

    If I didn't actually need to look at the data line by line I'd code something but sometimes I need to look at data individually as I don't know what I'm looking for until I find it. Being able to control click a few columns then keyboard short cut a chart is super useful.

    I did it once during a video call screen share. One of the guys on the other end said "seeing you manipulate excel time axis values makes me unsure whether to be impressed or feel sorry for you". Arguably the nicest thing anyone has ever said about me.

    💬 0🔄 0⭐ 0
  • Nov 18, 2026, 10:25 PM

    @mhoye And you can replace Excel and PowerPoint with LibreOffice too. I have done. It takes a bit of acclimatisation but it’s worth it.

    💬 0🔄 0⭐ 1
  • 💬 0🔄 0⭐ 2
  • 💬 1🔄 0⭐ 1
  • 💬 1🔄 0⭐ 3
  • 💬 1🔄 0⭐ 2
  • Nov 18, 2026, 11:34 PM

    @mlanger @waltbaldwin @mhoye I can do just about anything I can do with Libre Office that Word offers. I don't know about their spreadsheet functionality as I rarely use them.

    💬 0🔄 0⭐ 1
  • Nov 18, 2026, 11:59 PM

    @LJ @waltbaldwin @mhoye I found a few issues with some feature I was trying to use. I can't remember now what it was. But I was very glad to see that it supports cross referencing, which I use a lot in manuals that I write. Things like "learn more in the section titled blah blah on page blah." You can set it up to manually replace the blahs with section names and page numbers that change automatically when needed.

    My problem is that I used Microsoft Word for too long and I know it too well.

    💬 0🔄 0⭐ 1
  • Nov 18, 2026, 11:23 PM

    @mhoye Microslop Shareholders when their bank accounts vanish because Copilot deleted an entire database for no reason:

    Surprised Pikachu
    💬 0🔄 0⭐ 2
  • Nov 19, 2026, 3:55 AM

    @mhoye Look, just because I processed a large amount of revenue numbers through Excel...........

    (Shit. this is bad.)

    💬 0🔄 0⭐ 4
  • Nov 19, 2026, 3:55 AM

    @mhoye #LibreOffice has a spreadsheet, saved in CSV is fully compatible with all Microsoft Excel versions and is actually MORE transportable that one Microsoft version is to another Microsoft version. Give #opensource a chance, folks... more transportable, more private...and well, made by people for people

    💬 0🔄 0⭐ 3
  • Nov 19, 2026, 4:00 AM

    @mhoye many moons ago I worked for a government contractor in Federal budgeting. We had a product that helped agencies do their budgets. At EVERY SINGLE AGENCY we ever pitched the product to, there was a senior employee in charge of The Spreadsheet. Without it, no budget. Without that employee, no Spreadsheet. And the employee was nearing retirement and everyone was freaking TF out

    💬 0🔄 0⭐ 4
  • Nov 19, 2026, 4:11 AM

    @mhoye A major reason I haven't fully retired my old laptop in favor of the new to me one is that the old one has a legit copy of office 2011 that doesn't need to phone home for anything. Even if I want to give it away I feel like that is such a good thing that I'm reluctant to wipe the drive.

    💬 2🔄 2⭐ 16
  • Nov 19, 2026, 5:15 AM

    @SRLevine @mhoye Try Libre Office. It's free and has all the functionality of MS Office, except Outlook. To replace that, go to Fastmail.com.

    💬 0🔄 0⭐ 0
  • 💬 0🔄 0⭐ 1
  • 💬 0🔄 1⭐ 4
  • 💬 0🔄 0⭐ 0
  • 💬 0🔄 0⭐ 1
  • Nov 19, 2026, 10:50 PM

    @mhoye An uncomfortable thought experiment just came to me: let's assume a spherical cow and that copilot becomes, ahem, 'perfectly aligned' and 'good' at softwaring.

    What kind of quiet damage arises from it helpfully fixing a load-bearing bug in those load-bearing spreadsheets?

    💬 0🔄 0⭐ 0
  • Null Hypothesisnull_hypothesis@mas.to
    Nov 20, 2026, 6:34 AM

    @mhoye @arstechnica
    While not for everybody, knowing how to draft Jupyter notebooks can feel far superior to kludging through with Excel.

    💬 0🔄 0⭐ 0
  • Nov 20, 2026, 10:37 AM

    @mhoye If PowerPoint stopped working the US would lose the ability to wage war. So I'm not seeing the downside here.

    💬 0🔄 0⭐ 0