When I remote into my work computer and open an existing calc spreadsheet, the contents of the spreadsheet do not show. All controls etc are also not visible.
As you didn’t mention any details about operating system or other environment I’ll just give a possible answer:
You forgot to forward X11.
If that doesn’t mean anything to you or was not the case then ask a good question.