Huh. Well, LibreOffice still can't preserve the formatting. Not sure if the last version of real-Excel I tried could.
Having the compose box fit itself to the formula size or give other indication that there is more to see is still a head-scratcher why they didn't do it.