table not appearing in .doc format in MAC

Friends,
I am using the Libre office 4.2.4 version on a linux machine with Unbuntu
12.10.

I have .odt file where i copied a table from libreoffice Calc. Then i saved
the file in .doc file.

Opening the .doc file in macbook does not show the tables. Is there any way
to resolve this issue.

Thanks,
Bala

Hi,

I have .odt file where i copied a table from libreoffice Calc. Then i saved
the file in .doc file.

Opening the .doc file in macbook does not show the tables. Is there any way
to resolve this issue.

When you write that you save as doc, do you mean Doc (Word97) or Docx
(Word 2003/2010) ?

I should be able to test this between my Linux and Mac machines.

Alex

Errm, actually, now I think about it, isn't this normal behaviour ?

What I mean is that you've inserted a Calc document into a Writer
document which you then save as DOC Word97.

Firstly, the DOC Word97 filter is designed to export to that format
(give or take a few bugs), but that doesn't mean it supports OLE from an
object that does not form part of the Word 97 format.

Second, how would a Word document know anything about a Calc OLE object
(or its Linux equivalent) ? If you save your Writer document as Writer
ODT, instead of DOC Word 97, does the ODT document open correctly on the
Mac and display the inserted Calc spreadsheet ?

As I don't tend to embed certain types of document in other types of
documents, I'm not really sure what is, and what isn't supposed to work
anyway, much less be interoperable between different OSes that don't
have the same mechanisms for object linked embedding.

Alex

Bala subramanian wrote:

Friends,
I am using the Libre office 4.2.4 version on a linux machine with Unbuntu
12.10.

I have .odt file where i copied a table from libreoffice Calc. Then i saved
the file in .doc file.

Opening the .doc file in macbook does not show the tables. Is there any way
to resolve this issue.

If you've simply copied from Calc and pasted in Writer, you've probably ended up with a Calc object embedded in a Writer document. If (in Writer) you double-click on the pasted table, do you get the row and column headings around it, and sheet tabs below? If so, that's a Calc object opening within the Writer document.

When you save that in .doc format, you probably end up with a Calc object embedded in a Word document - which would need something on the macbook capable of opening, displaying and editing that Calc object.

A couple of potential solutions:

1. Copy from Calc as usual, but in Writer try the options given by Edit > Paste Special. "Formatted text" or "HTML" paste as a Writer table rather than an embedded spreadsheet, and may be sufficient.

2. If you actually need a spreadsheet object embedded in the text document (rather than just inserting a table), look under Tools > Options > Load/Save > Microsoft Office. Tick the [S]ave box next to "Excel to LibreOffice Calc or reverse" before saving as .doc. I think that makes it convert the embedded Calc object to an Excel object when saving the text document in Microsoft (.doc) format. I don't tend to embed spreadsheets in text documents and transfer to Microsoft formats, so not entirely certain that'll work, but it's worth a try. If it doesn't you can always change the settings back to what they were. If it does work, and you do this kind of thing a lot, you might want to tick all those boxes ([L]oad and [S]ave for all object types). I'd suggest keeping the original in ODF format though, and just saving a copy as .doc when you need to share it, just in case something goes wrong with the conversion.

Hope that helps.

Mark.