It’s been bugging me for years… the only thing I really prefer in Excel over Libre Office Calc is that I can tell Excel I always want to edit in the input line, rather than directly in the cell.
Turns out you can do this in Libre Office too, just customise the keyboard and change what F2 does. Such a relief:
https://ask.libreoffice.org/t/calc-how-to-edit-formulae-in-formula-bar-directly/38179