The one place where Google Sheets falls behind Excel or LibreOffice is in macros.

A bit of background: Sheets is implemented as a bunch of JavaScript to control the layout of your spreadsheet data on your local device (Chromebook, Windows or MacOS machine), and your data lives on Google's servers. This means that you run into some annoying issues trying to run macros similar to what you'd do with Excel, where the assumption is made that all data is on your local machine, the same place where your macro is running. 

Let's say that I'm running a macro on my local computer that goes out to several different websites to scrape data (prices, whatever) and put it into my spreadhsheet. That's easily done when my spreadsheet, the data, and the macro are all in the same place - on my machine. I can store all the passwords and URL's to get to the other pages where I want to scrape data on my machine, and the macro can prompt me locally or pick the passwords out of the local keychain to access the data. 

It's not quite so easy with Google Sheets. I've got applications where I need to do this, and boy oh boy have I tried, because in this one situation I have, there is no alternative other than Google Sheets. Don't get me wrong - Sheets is pretty doggone good, and probably most spreadsheet users will not run into the sort of thing I'm trying to do. When it comes to macros and complicated macros at that, Excel is still the king of the hill, and now with Python programming added to Excel, it will be even more powerful. 

Apple's "Numbers" app is pretty pathetic as spreadsheet apps go. It's like going back to Visicalc on an Apple II.