News for hackers. Stuff that matters.
Re:Scientists rename human genes to stop MS Excel from misre... by throw_m239339 on Thursday August 06, 2020 @12:31PM (#24072551)
Everyone uses Excel because it's a tool everybody learned at University or even highschool, nothing more, it's not because it's good at all.

It's a terrible app but Microsoft managed to shove it everywhere in education. Same for Words.

Unfortunately Libre Office and co tried to reproduce the terrible UX of both software, while coming up with inferior functionalities because they had to try to maximise compatibility with these MS tools, time not spent on providing actual useful stuff.

Access is a bit better and I wish more non programmers learned basic SQL instead of Excel.

Re:Scientists rename human genes to stop MS Excel from misre... by brandonmenc on Thursday August 06, 2020 @06:24PM (#24076069)
> Everyone uses Excel because it's a tool everybody learned at University or even highschool, nothing more

My anecdote is the exact opposite.

I was recently introduced to using Excel and actually writing some VBA inside of it when I helped a non-programmer with a complicated data processing task on a sheet they were populating from a database.

This was the first time I really used Excel, even though I've had continuous access to it since Windows 3.0.

Aside from some small annoyances, it was a generally pleasant experience. I also can't think of any tool that comes remotely close to the power and flexibility of Excel, particularly for people who are not programmers.

I kind of got hooked on it, and now I frequently use it for little data processing tasks that I used to do in a REPL - and the bonus is I can share those with people who are not programmers.

Re:Scientists rename human genes to stop MS Excel from misre... by brohee on Thursday August 06, 2020 @06:50PM (#24076251)
You may enjoy "Pure Functional Programming in Excel" by Felienne Hermans presented at GOTO 2016 https://www.youtube.com/watch?v=0yKf8TrLUOw
Re:Scientists rename human genes to stop MS Excel from misre... by listenallyall on Friday August 07, 2020 @09:55AM (#24081822)
> because they had to try to maximise compatibility with these MS tools,

Worst excuse ever. Excel had to maximize compatibility with Lotus 1-2-3 (in the 80s/early 90s, the dominant spreadsheet application by far) from Day 1. It wasn't just that the files were compatible, Excel included keystroke compatibility so 1-2-3 experts could continue navigating the UI with their old commands.

Unlike the LibreOffice team, Microsoft made a superior program in virtually every way, despite the burden of backwards compatibility with another program.

Re:Scientists rename human genes to stop MS Excel from misre... by tester756 on Thursday August 06, 2020 @03:36PM (#24074612)
So what in your opinion is "the right tool" to deal with spreadsheet type of tasks while maintaining things like easy to move to other PC and so on?
Re:Scientists rename human genes to stop MS Excel from misre... by MystK on Thursday August 06, 2020 @02:30PM (#24073960)
It may be a terrible app, but it's better than the competition. Does that mean it's the best one?