No, it haven’t. You will need to learn a few things to get over this nuisance.
In general, working with Calc ranges requires more knowledge and care than Excel.
Use Database Ranges.
Forget. The formula itself, of course, won’t fill down the rows. Click on the cross in the lower right corner of the cell.
You still have to get used to inserting new rows/columns correctly, and not just adding them by filling data in new rows below or columns to the right. Feel the difference between the terms Insert and Add.
Smart tables appeared in Excel in 2007. This means that we are at the level of Excel 2003 in this sense. But there is one more nuisance. Excel 2003 knew how to work with dynamic ranges (using the OFFSET function), and Calc still does not know how, if we are talking about using pivot tables or expanding charts. Only absolute references to the source (a serious flaw). And don’t forget to correct them yourself! Which is why our member @Villeroy is so skeptical about newbies using spreadsheets: it’s too easy to get it wrong. For me, these bottlenecks are resolved by macros, and this is a very complex topic. Everything can be automated, however.
Of course, I was able to overcome all these difficulties, but it will take effort. Will you develop this topic further or keep using Excel? But if you come to us seriously and for a long time, then all problems can be solved. But not as easy as you imagine.
Perhaps I disappointed someone…