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 <quiet.c...@gmail.com> 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 > version. > > 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 <mhenri...@gmail.com> wrote: > >> 2017-04-16 17:30 GMT+02:00 QC <quiet.c...@gmail.com>: >> >>> On Sat, Apr 15, 2017 at 11:02 AM, Johnny Rosenberg < >>> gurus.knu...@gmail.com> >>> wrote: >>> >>> > >>> 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 >>> to >>> 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 >>> in >>> 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 ! >> >> Henri >> > > -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted