Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index

Ah, well that didn't work. I can save as xlsx, and it preserves the sheet.
I can then embed it into  a .docx file, but if I save it or "save a copy",
it converts it to an image. Not the behavior one would expect. This really
seems like a bug to me. Saving an embedded object should preserve the type
of embedded object.

Even if I link to the external object it still flattens it to a graphic.
What!? It destroys the link! That is not standard behavior! That is a bug
for sure.
 Does that happen in the latest version of Libre Office? I'm not thrilled
at the idea of pinning to a newer version of Libre Office, but if it fixes
this bug I'd do it.

On Sun, Apr 16, 2017 at 12:32 PM, QC <> wrote:

No, I use Libre Office, and used Open Office for years before that to make
my invoices. One of my clients started complaining after upgrading to
Office 2013 that my older exported from LO to a Word 97 format wouldn't
display, or display properly. Not sure exactly what his issue is. I have
seen a similar issue when importing from ODF into Google Docs. It does
funky things, but the spreadsheet remains a spreadsheet, however the
document the layout is completely messed up.

So since my client can't read the LO document "saved as" a Word 97
document, I started saving in the latest Office layout that LO allows. It
was then this saved layout, that I discovered a few days ago is converting
the speadsheet to an image. I discovered it when opening one in LO to make
copy some data from, after accidentally overwriting the previous ODF

Rather, than pulling from a backup.

I will attempt your suggestion to save the spreadsheet as an xlsx, and try
importing into a docx file. It would mean switching to a .docx template,
rather than an ODF template.  But if it works so be it.

On Sun, Apr 16, 2017 at 11:37 AM, M Henri Day <> wrote:

2017-04-16 17:30 GMT+02:00 QC <>:

On Sat, Apr 15, 2017 at 11:02 AM, Johnny Rosenberg <>

The document is created in Writer. It has Text, a table and an embedded
spreadsheet. I got it from and OO/LO template document years ago. I've
tweaked it somewhat, but not much.  I open it in Writer, paste in the
relevant charges from my Tracking spreadsheet, save it to a new filename,
and then save a copy in Office format for my clients, who use Word and
Microsoft Office. I can't dictate to paying clients what software to use
open my invoices.

I can't just send it in ODF. Unless MS Office has suddenly decided to
support reading ODF files. Last time I tried it didn't.  I could send it
PDF, and will if I have no other choice. If LO can't export a simple
spreadsheet embedded in a document to a current MS format, or read back
what it wrote, then they should not be included as options to export to.

I use this system for my business. It has to work, or I have to use
something else.


QC, perhaps I misunderstand you, but you seem to be saving what
originally was a .doc file in .docx format, because as you say above,
«[t]he older Word 97 format is not readable anymore by one of my
customers». I was quite surprised to read that, as I had laboured under the
understanding that even the latest editions of MS Office could still
successfully open files in .doc (and for that matter, .xls) format. Could
it be that your attempts to save the file in .docx format is what led the
embedded spreadsheet (which I presume was originally in .xls format) to be
converted to an image (in which format ?) ?...

Perhaps to get 'round your present difficulty you could open the embedded
spreadsheet in .xls format and then attempt to save it in .xlsx format. If
that can be done successfully, perhaps you could replace the embedded
version with the new version ?...

Good luck !


To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.