News for hackers. Stuff that matters.
Re:Office is too slow, so Microsoft is making it load at Win... by BarryMilo on Thursday May 01, 2025 @06:46AM (#43855969)
It's crazy to me how because 1% of Excel users need pivot tables or something we're all stuck on it. LibreOffice is enough for the vast majority of use cases.
Re:Office is too slow, so Microsoft is making it load at Win... by aleph_minus_one on Thursday May 01, 2025 @08:36AM (#43856885)
> It's crazy to me how because 1% of Excel users need pivot tables or something we're all stuck on it.

Finance and insurance industries are full of Excel powerusers.

> LibreOffice is enough for the vast majority of use cases.

Often (from my job experience I can at least attest this for the finance and insurance sectors), Excel is an integrated part of many large workflows. Changing from Excel to LibreOffice would mean rewriting important parts of central business applications, so you better have a really good reason why you want to do the switch from Excel to LibreOffice.

Re:Office is too slow, so Microsoft is making it load at Win... by ponector on Thursday May 01, 2025 @09:12AM (#43857240)
We are working on backend for life insurance. They have a separate pricing team who creates calculations for different insurance products. The results are usually presented as excel files with heavy scripting inside. Really heavy! Have you seen 100mb excel files? I did!

On the funny note: as powerful excel is, it cannot open two files with the same name from different folders! Or at least my version can't.

Re:Office is too slow, so Microsoft is making it load at Win... by strongpigeon on Thursday May 01, 2025 @11:57AM (#43859453)
I used to work on Excel extensibility. I’ll never forget when we were talking with one of the top 5 insurance companies in the US and they showed us this huge VBA macro and told us they processed the top 10% of their claims using this file. That moment made me realize Excel powers at least 10% of the world economy.
Re:Office is too slow, so Microsoft is making it load at Win... by smallerize on Thursday May 01, 2025 @09:31AM (#43857432)
Oh yeah, because references to the book name would conflict. If you open a new instance of Excel (e.g. shift-click the taskbar icon), you can open one file in each, but they can't reference each other.
Re:Office is too slow, so Microsoft is making it load at Win... by pete1302 on Thursday May 01, 2025 @04:05PM (#43862734)
I have seen 600mb+ geodata based, script bloated, slow as hell, make your MB Air commit sucide type of excel every day for 4 months, working on a project.
Re:Office is too slow, so Microsoft is making it load at Win... by hannob on Thursday May 01, 2025 @09:45AM (#43857597)
I mean, it's not as if Libreoffice was created yesterday. Its predecessor OpenOffice is now 25 years old. Your question becomes: Why did you choose the expensive version where you never know what it will cost next year in the first place?
Re:Office is too slow, so Microsoft is making it load at Win... by aleph_minus_one on Thursday May 01, 2025 @10:18AM (#43858016)
Concerning

> Why did you choose the expensive version

Big companies have (sometimes hard negotiated) volume contracts with Microsoft, which makes Excel much cheaper to them than to, say, small companies. Thus Excel is not really expensive for them.

Concerning

> where you never know what it will cost next year in the first place

For open source software there exists a similar risk that you don't know into which direction the product will develop.

In the past, Microsoft has been quite reliable in keeping backwards compatible, and continue selling office for decades.

In my observation, the zigzag course that Microsoft starting doing with Windows (but is now also doing with office), and, relatedly, deviating from the course of being very insanely dependable in delivering the software that companies need from them, is what by now got big companies at least have a look at what possible alternatives to Microsoft products could be.

Re:Office is too slow, so Microsoft is making it load at Win... by tech234a on Thursday May 01, 2025 @12:07PM (#43859615)
As a counterpoint, Microsoft is in the process of discontinuing Publisher and plans to remove it from M365 installations next year.
Re:Office is too slow, so Microsoft is making it load at Win... by dijit on Friday May 02, 2025 @06:03AM (#43867931)
> For open source software there exists a similar risk that you don't know into which direction the product will develop.

You know what's really interesting to me about this argument point?

It is actually the proprietary solution that is at risk of this, and we feel it daily. The next version of Microsofts own flagship product (Windows) is nearly universally denigrated, but people are forced to upgrade.

With FOSS, there's significantly less risk, if the product changes direction you and your other company friends can just use old versions or in the worst case.. fork it.

Re:Office is too slow, so Microsoft is making it load at Win... by const_cast on Thursday May 01, 2025 @05:20PM (#43863502)
Excel is also used and abused. In finance and insurance, often Excel isn't used as a spreadsheet and visualization application. It's used as a database and application engine.

This is really bad for a lot of reasons. Of course it's painfully slow, but it's also incredibly brittle and foot-gunny. Excel IS NOT a competent database engine or application engine. It makes JS and C++ look sane and safe.

Excel shouldn't be switched out to LibreOffice. It should be switched out to a proper application with a proper database. What, finance bros don't know how to navigate a database. Tough fucking luck! In the 70s, secretaries could do that. They better figure it out. Because these existing "systems" are a disaster waiting to happen.

Re:Office is too slow, so Microsoft is making it load at Win... by freeAgent on Thursday May 01, 2025 @09:11AM (#43857233)
You are vastly underestimating the number of people who use pivot tables and even more “advanced” Excel functionality like Power Pivot/Query.
Re:Office is too slow, so Microsoft is making it load at Win... by jeroenhd on Thursday May 01, 2025 @10:02AM (#43857802)
Entire departments run on the "pivot table" button. Most companies have at least one person who needs some Excel feature that isn't available in the common alternatives.

I've worked on software that communicated with other software using custom Excel spreadsheets exported by yet different software, modified by humans. Every stage of the process was specs-incompliant and was using edge case features, but this process oversaw transport for goods worth millions every day. I tried my very best not to reach for a Windows VM, but there was nothing that could work on these files.

For the vast majority of times, bikes are good enough for the majority of travels, yet there are cars everywhere.

Re:Office is too slow, so Microsoft is making it load at Win... by skrebbel on Thursday May 01, 2025 @10:08AM (#43857883)
> For the vast majority of times, bikes are good enough for the majority of travels, yet there are cars everywhere.

Wow that was a very Dutch comment! I wonder whether it resonates with the Americans here :D

Re:Office is too slow, so Microsoft is making it load at Win... by kermatt on Thursday May 01, 2025 @10:10AM (#43857925)
> software that communicated with other software using custom Excel spreadsheets exported by yet different software, modified by humans

This sums up my entire experience of "Enterprise applications".

Re:Office is too slow, so Microsoft is making it load at Win... by Maxion on Thursday May 01, 2025 @03:41PM (#43862420)
For any modern SaaS to be enterprise grade, it has to have an excel export feature.
Re:Office is too slow, so Microsoft is making it load at Win... by Qem on Thursday May 01, 2025 @10:40AM (#43858306)
LibreOffice has dynamic tables, an equivalent to pivot tables, for many years already.
Re:Office is too slow, so Microsoft is making it load at Win... by Nemo_bis on Thursday May 01, 2025 @01:43PM (#43860941)
They're also just called "pivot tables" in some locales.
Re:Office is too slow, so Microsoft is making it load at Win... by TinkersW on Thursday May 01, 2025 @02:54PM (#43861892)
I tried using LibreOffice on Windows, and it was super slow and kept crashing. It is also so ugly & annoying to use that it must be intentional.

I really don't understand how this market is dominated by an abusive platform(MS Office) & a broken POS(LibreOffice).

Re:Office is too slow, so Microsoft is making it load at Win... by Maxion on Thursday May 01, 2025 @03:42PM (#43862432)
The only way for a competitor to have a chance at breaking in to the market, they need to be able to open any xls or xlsx file.
Re:Office is too slow, so Microsoft is making it load at Win... by __mharrison__ on Thursday May 01, 2025 @07:14PM (#43864420)
Excel powers the world and is the most common programming environment.

Programmers don't like to hear that truth.

Re:Office is too slow, so Microsoft is making it load at Win... by jodrellblank on Thursday May 01, 2025 @11:20PM (#43865876)
> "because 1% of Excel users need pivot tables or something"

It's crazy to me how often Open Source pushers have the vibe "I don't use computers, I don't know what anyone does with computers, but I'm still dismissive and superior". I almost made this comment earlier today in reply to [1] which was another "You have problems with Linux? I daily-drive Linux for years and I've never had any problems" comment and the issues were common/well-known things - fractional scaling in Gnome, HDMI, screen sharing in Slack, crashes in Google Meet, crashes in Chrome, KDE unstable, missing desktop software they use, audio too buggy, constant crashes in another program after days of work.

Nothing anyone would be surprised at, except a Linux user who - apparently - never does anything with their computer and is baffled that other people do. I decided my comment was too trolling and didn't finish it, but here you are bringing that vibe again: you don't know what Excel does or why people use it, but you're confident that you know better; prompting me to actually call it out.

The first thing I looked for when I installed LibreOffice most recently, I found a thread[2] asking: "In excel you can create a table simply by using insert->table. Is there a way to create tables in calc, as well?" and the first visible reply is them explaining that they don't want to create a table in Write, they want Excel's "insert table" feature in Calc. Why would they have to explain that again already, their question was two short lines. Presumably the people replying don't know that feature exists. There are some people being helpful and suggesting ways to get similar effects, but of course there's "Why do you want to insert a table into a Calc spreadsheet? It doesn’t seem like a feature that I’d use much" ("I don't know what the feature does but I know I don't want it"), a couple people commenting explanations of what Excel's tables are and why they are useful including a link to a video demonstration ... followed by someone saying "It already works, they are called database ranges" - no, that's different. Someone who doesn't know what they are, didn't read the explanations or watch the video and still thinks they know better. Crazy.

One of the earlier repliers comes back with "LibreOffice has a database component which is by far more powerful than any fake tables on a calculator’s grid." doubling down on "I don't understand it, didn't read the explanations, don't respect you enough to consider that you know anything about what you want or do on a computer, I still know better" and with namecalling it 'fake'. Crazy.

Note, to avoid the obvious tangent, that I'm not demanding people implement features for me in free software. As the thread ends by kerosene5 "Instead of spending so much time poo pooing the feature request, you could explore it. It really is a good feature. I just downloaded and opened my bank transactions and the very FIRST thing I did was look how to convert it to a table. . . . back to Excel."

It's not "1% of Excel users need pivot tables or something" it was the very FIRST thing they wanted, and multiple people in that thread want, and the second thing I wanted. No this is not the only feature Excel has that LibreOffice hasn't; if you want to know why people aren't using Open Source software? Try actually looking and listening instead of whatever that is you are doing.

[Edit: THIS IS YOU: https://news.ycombinator.com/item?id=43855927 ! Of course it is. Of course it is].

[1] https://news.ycombinator.com/item?id=43855663

[2] https://ask.libreoffice.org/t/creating-tables-in-calc/1433

Re:Office is too slow, so Microsoft is making it load at Win... by dartharva on Friday May 02, 2025 @08:03AM (#43868617)
Hear, hear!
Re:Office is too slow, so Microsoft is making it load at Win... by BarryMilo on Friday May 02, 2025 @09:15AM (#43869331)
My god the amount of projection in your comment. It seems you've mistaken me for everyone who ever commented in favor of migrating off of Excel.

I"m aware that there are things I'm unaware of. Perhaps I don't know how to use Excel, I'm "no true Excel user" if you will, and therefore my opinion is invalid. Like you I'm baffled not by the technical side of things but by our reaction to it. People say "it powers 10% of the world's economy" but not "and it's a problem".

It's a problem. My point is not that LO is better, it's that we should work to remove our dependency on closed-source software for universal office work. Governments should be doing that. But no, let's just say "the other one sucks" and continue to act like depending on a single for-profit company for all our economies is a good thing.

Not sure how my other comment relates to this. Is it arrogant to have preferences?

Re:Office is too slow, so Microsoft is making it load at Win... by jodrellblank on Sunday May 04, 2025 @09:21PM (#43891140)
Your other comment related because it shows the amount of projection in my comment was just the right amount.

> "Is it arrogant to have preferences?"

No, it's arrogant to not know what people are doing but still tell people that you know better what tools would be good to do what they are doing.

> "My point is not that LO is better, it's that we should work to remove our dependency on closed-source software for universal office work"

If that is what you had said, I wouldn't have replied.