Hiow do I live-link a Calc spreadsheet into Writer and keep the formatting? [closed]

asked 2018-02-15 22:23:51 +0200

Deplorable Mountaineer gravatar image

updated 2020-08-02 11:40:09 +0200

Alex Kemp gravatar image

I can copy and paste a spreadsheet from Calc to Writer and keep the formatting. Or I can use a DDE link, and keep it sync'd with the original spreadsheet file, but the formatting does not carry over to the table in Writer.

Is there a way to have my cake and eat it too, have a table in writer automatically sync'd with a Calc spreadsheet, and with formatting information (column widths, background colors, etc.) sync'd automatically as well?


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-02 11:40:19.023576


Without some elaborate and extensive macro coding it seems improbable. And that is even without considering items such items ( as etc. implies) like inserted or deleted columns or rows and resizing and probably dozens of other possibilities. It appears you are trying to make your table mimic an OLE object or want certain aspects visible/present for a reason. What is the reason/purpose? Maybe there is another solution.

Ratslinger gravatar imageRatslinger ( 2018-02-15 23:29:15 +0200 )edit