Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?

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.celt@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 <mhenriday@gmail.com> wrote:
>
> > 2017-04-16 17:30 GMT+02:00 QC <quiet.celt@gmail.com>:
> >
> > > On Sat, Apr 15, 2017 at 11:02 AM, Johnny Rosenberg <
> > > gurus.knugum@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+unsubscribe@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