I’ve only ever used Libre(open) Office Calc since I’ve never paid for or bothered to pirate office before. What can Excel do that Calc can’t?
I’ve never done anything crazy heavy with it, but functions and stuff work fine for me I guess.
I’ve never done anything crazy heavy with it, but functions and stuff work fine for me I guess.
> What can Excel do that Calc can’t?
For one, a working copy paste. Seriously, I’ve lived with a copy paste bug in LibreOffice Calc (Windows) for years (it wasn’t yet fixed as of a few months ago). It will either paste an older copy or not paste anything even though I just hit Ctrl+C (sometimes multiple times) within Calc. This is one of the most irritating things about Calc.
Fonts and formatting is another thing that Calc miserably fails at in relation to copy paste. Multiple cells will look very different even though the font, size, etc., will appear the same in the dropdowns below the menus (when these cells are in focus). LibreOffice Calc, in many ways, portrays the worst of what one would expect from an open source project (I say this as a supporter/donor of Document Foundation).
The other part about what Excel can do that Calc can’t is that Microsoft (at least with the MS365 subscription version) has been adding more functions to improve older functions and features. I don’t remember everything, but SEQUENCE and XLOOKUP are two functions that come to mind on this aspect. LibreOffice Calc lags behind Excel on functions by several years.
LibreOffice Calc, though it’s a lot newer/younger than Excel, also has ~weird~ different keyboard shortcuts compared to Excel (e.g. adding a new line within a cell is Ctrl+Enter whereas it’s Alt+Enter in Excel; there are many more like this).
Nevertheless, I use Calc because I can’t bother to pay Microsoft and since Excel might be the only application that could be of value to me in its Office offerings (MS Word is total crap, PowerPoint isn’t as keyboard friendly as I’d like it to be, and Outlook is another total piece of crap).
Excel does have more functions but 90% of people don't need those. If you do, you do.
Weird. I've used Calc extensively on Windows and Linux and have never come across this
[1]: https://support.apple.com/guide/numbers/autofill-cells-tan0e...
In Excel the function is called Flash Fill.
If you haven't before, try Flash Fill. It seemed like black magic back when LLMs were not a thing.
Calc is ok if you want to work with small spreadsheets and don’t care about the occasional bug.
A few important concrete examples would be much more interesting. In fairness, you did somewhat, but I would be interested in some more details.