Have you tried collabora office and/or onlyoffice ? These could match your need.
Yes and it is atrocious compared to Google Spreadsheets, unfortunately.
Yes, they are indeed not as streamlined unfortunately.
Maybe ethercalc if you need something lightweight, but that's also not a real alternative
https://ethercalc.net/
I use NextCloud with Collabora Online (hosted and trimmed down version of LibreOffice). All self-hosted.