Only characters within OLE object (spreadsheet) visible in writer document when converted to PDF/printed

I have inserted an OLE object (spreadsheet) into a Writer doc, however when converted to PDF or printed only the characters within the spreadsheet are visible; no borders or any other part of the spreadsheet shows up.
I’d like the OLE object to appear as it does when editing the document, any ideas?