[libreoffice-users] Automatic updating of a cell from one spreadsheet to another doesn't work
Ok, so I have this spreadsheet, and a Writer document with embedded spreadsheets. It's an invoice document with two pages each with it's own spreadsheet. Because I could never figure out how to link the subtotal from one page (i.e. one internal embedded spreadsheet to another) to the next, I linked in a subtotal from the time tracking spreadsheet. Apparently internal document links are illegal in LibreOffice. Why? I don't know. He's on third. Well it *USED* to automatically update, back in the day. Not sure when it broke. Maybe I broke something in the configuration. It's pretty freaking fragile. I breath the wrong way and something breaks. Anyway. I noticed maybe last month it's not updating anymore. Again this month, nothing. Opening up the links dialog and it shows as manual and no option to make it automatic. Searched help docs and it says it needs to be a DDE link. Ok, fine. So I follow the instructions and make a "DDE" link. Only hen it does that it doesn't include the file path, so it can't find the link. Useless. Tried to edit it. I doesn't like that. This should be a simple no-brainer. Here I am 2 hours later. Wasting a couple hundred dollars of my time doing a task that can't be much simpler. I was doing this stuff in Word Perfect two decades ago. No three. God has it been that long. Brian -- 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
[libreoffice-users] Automatic updating of a cell from one spreadsheet to another doesn't work
Ok, so I have this spreadsheet, and a Writer document with embedded spreadsheets. It's an invoice document with two pages each with it's own spreadsheet. Because I could never figure out how to link the subtotal from one page (i.e. one internal embedded spreadsheet to another) to the next, I linked in a subtotal from the time tracking spreadsheet. Apparently internal document links are illegal in LibreOffice. Why? I don't know. He's on third. Well it *USED* to automatically update, back in the day. Not sure when it broke. Maybe I broke something in the configuration. It's pretty freaking fragile. I breath the wrong way and something breaks. Anyway. I noticed maybe last month it's not updating anymore. Again this month, nothing. Opening up the links dialog and it shows as manual and no option to make it automatic. Searched help docs and it says it needs to be a DDE link. Ok, fine. So I follow the instructions and make a "DDE" link. Only when it does that it doesn't include the file path, so it can't find the link. Useless. Tried to edit it. I doesn't like that, and it turns it into a URL. URLs don't compute. This should be a simple no-brainer. Here I am 2 hours later. Wasting a couple hundred dollars of my time doing a task that can't be much simpler. I was doing this stuff in Word Perfect two decades ago. No three. So, is there a workaround or fix for this? I'm using Libreoffice version 4.4.3.2 in Mint 17 64 bit. Brian -- 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
Re: [libreoffice-users] Re: Automatic updating of a cell from one spreadsheet to another doesn't work
Well, I used to use a table but that was ***way*** worse in Open Office (pre-LibreOffice). Professional or unprofessional. It gets my invoices out. Sure, I could write a program to do it. In fact, I have written programs that do it. But this is what I use for this client, because they want a Word document. The structure of ODF, is so bizarre, that I don't have the time to devote to design a program to build an ODF compliant document. So, this is what I use. Because the client is always right. That is the first rule of being professional. I build it in Libreoffice and export it to Word. LibreOffice, should be able to handle a linked field properly. I don't see how the automatic linking can work at all. I can't link from within a document and I can't link from another document. Looks like a bug. Maybe it's a feature. The automatic linking that doesn't link. On Thu, Jul 2, 2015 at 8:01 AM, Andreas Säger wrote: > Am 02.07.2015 um 02:18 schrieb QC: > > > needs to be a DDE link. Ok, fine. So I follow the instructions and make a > > "DDE" link. Only when it does that > > it doesn't include the file path, so it can't find the link. Useless. > Tried > > to edit it. I doesn't like that, and it turns it into a URL. > > URLs don't compute. > > > > There is no path until the linked document is stored somewhere. > > > > > So, is there a workaround or fix for this? > > I'm using Libreoffice version 4.4.3.2 in Mint 17 64 bit. > > > > > > > Using spreadsheets like this is common practice, nevertheless highly > unprofessional. > > > > -- > 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 > -- 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
Re: [libreoffice-users] Re: Automatic updating of a cell from one spreadsheet to another doesn't work
Wow! Sensitive much? I didn't tell anyone what to do. No I didn't upload an example document. No I haven't filed a bug report, because I was asking for guidance. By hopefully someone willing to be helpful and more experienced with everything LibreOffice than me, rather than someone to berate me. Yes, I included the Office Version, but since I don't get copies of my own posts, I don't t see them. But, here it is again. I'm using Libreoffice version 4.4.3.2 in Mint 17 64 bit. The document was created in a previous version. Possibly even in Open Office. I would have to look at previous invoices to determine that. It's at least 2 years old. It is not a spreadsheet, as I stated, it is a Writer document with a 2 page invoice with two embedded spreadsheets that links to an external spreadsheet time entry document. There is probably a better and more efficient way of doing this. I did this out of frustration from using tables where I would copy and paste from my timelog, but had to do a third step in between because that's just the way it is in Writer, even though there had been feature requests to change/fix that for years. Doesn't work is a perfectly good problem description when something doesn't work. It draws from my time entry for this client. It's a manual process. I manually create this every month for my client, because they want this. I don't create invoices like this for personal pleasure. I have C, VB, and COBOL programs to do these kinds of things. Programs I've written. You state there are five ways to o this, but don't even enumerate them for me. That's hardly a solution description. As for what I did to accomplish this "doesn't work". It's easy. 1) Open Writer and add some text. 2) Add a spreadsheet with 5 columns. Give it a name, Table1. Make the first column a 2 decimal place number. Make the 4th column an hourly rate. Make the 5th column the product of columns 1 and 4. Add a page subtotal to the last visible 5th column cell. Add a credit line cell above that. Add a detail subtotal line above that, and have it sum all the lines above. The page subtotal cell is the detail line minus the credits. 3) Add a page break, copy the text to the new page. 4) Add a spreadsheet to this page in the same manner as the above spreadsheet. With two differences, describe below. 5) Instead of a page subtotal, call the final line Invoice Total. 6) Add a link to the page subtotal cell in the previous spreadsheet to the summation formula in the invoice total cell. Do it in this manner. 6.a.) Enter the summation formula to subtract the page credits from the detail subtotal. Add a plus. Enter the previous page spreadsheet. Uh-oh can't do that. 7) Copy and paste. No that doesn't work. 8) Paste Special. No that doesn't work. 8) Manually enter the link. I've never found the right syntax. This might work, if only I knew the magic words. "Table1.$Sheet1.$G$36" doesn't work. 10) Now open a new speadsheet document and relabel sheet1 as Invoice2. 11) Enter a dollar amount in the first cell. 12) Save it. 13) Go back to the Invoice document. 14) Enter the Invoice total cell, add a plus, create a link to the cell in the spreadsheet document by going to that spreadsheet and double-clicking on the proper cell. Go back to Invoice document and hit enter. 15) Voila a manual link. 16) Now let's make a DDE link. 17) Go back to the spreadsheet copy the cell. 18) Back to the Invoice sheet. On the cell below the invoice total paste special and set the link checkbox. Hit enter. 19) It doesn't work. No path to the document. 20) Manually enter the path to the document. Voila you have something. It doesn't work. But you have displayed text and not an error message. Or you have a manual link like before. I've attached the documents to reproduce it. I didn't include them before, because I expected someone to tell me something like read you're doing it wrong, FAQ #213456 for the solution, and thus pointing me to a solution that actually works. Regards, Brian On Thu, Jul 2, 2015 at 9:05 AM, Andreas Säger wrote: > You don't tell us what you do. In fact, there are no less then 5 > different methods to link between spreadsheets. > No uploaded example document, no bug report number, not even office > version, formula or menu call which lets us reproduce anything you are > actually doing. I have no idea how one can print invoices without using > a database. > Overly complicated stuff like this can break any time (particularly with > LibreOffice). > "Does not work" is not a problem description. > Spreadsheets do not have any "tables". > > > > -- > 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 > -- To unsubscribe e
Re: [libreoffice-users] Re: Automatic updating of a cell from one spreadsheet to another doesn't work
I'm not getting anything like that when I try. I'll try with a new user
account. Maybe there's something wrong with a configuration file. Then I'll
try a few other things. Now that I know what a good link looks like.
Thanks!
I may be back for more help. If these things don't work and a clean install
on a different PC doesn't either. Now at least I can diagnose the condition.
On Fri, Jul 3, 2015 at 12:57 PM, Andreas Säger wrote:
> Am 02.07.2015 um 19:49 schrieb QC:
> > 19) It doesn't work. No path to the document.
>
>
> When I copy&paste-special a range of cells with link option, LibreOffice
> creates an external reference like
> 'file:///path/document.ods'#%SheetX.$A$1:$F$9 as an array formula. Same
> when I use the mouse pointer to mark a reference in another spreadsheet
> window.
> Apache OpenOffice still creates DDE links from the paste-special
> operation and file:/// links from the pointer operation.
>
> A valid DDE link looks like this:
> =DDE("soffice","C:\PATH\document.ods";$SheetX.$A$1:$F$9)
> The path-name is in system notation and not URL notation.
>
>
> --
> 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
>
--
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
[libreoffice-users] Gallery will not open in Libreoffice 4.4, no error reported
I'm having trouble getting LibreOffice. cat /etc/issue Linux Mint 17 Qiana #uname -a ... 3.13.0-24-generic #47-Ubuntu SMP Fri May 2 23:30:00 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux Libreoffice: Version: 4.4.6.3 Build ID: 40m0(Build:3) Locale: en_US.UTF-8 this is from the official ppa: deb-src http://ppa.launchpad.net/libreoffice/libreoffice-4-4/ubuntu trusty main I had a manually installed 4.4.6, because the default in Mint 17 is still 4.2. So I had removed 4.2, but both were installed briefly. I'm sure, I did something to screw it up, but don't know where to look to fix it. What I've last done is: 1) apt-get remove libreoffice4.4 2) added the ppa to the sources list. 3) apt-get update 4) apt-get install libreoffice, which installed the libreoffice4.4.6.3 above noted. Still no Gallery. The option is there to view it, but nothing happens when I try. Thanks, Brian -- 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
[libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
I've just discovered that when I save a copy of an invoice it's saving the spreadsheet part as an image. This is not the behavior I expected. I'm running: Linux mint 17 64 bit KDE 4.13 LibreOffice 4.4.7.2 When I save a copy of this file as Word 2007/2010/2013 (*.docx) if converts the spreadsheets as an image! Is this some setting? I've tried Googling, but it keeps showing my link on how to save things as an image. Completely not what I want to do. The older Word 97 format is not readable anymore by one of my customers. If I save an 2003 .xml version Libreoffice can't even open a readable document again!? Are there some configuration details I'm missing? Brian -- 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
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
On Sat, Apr 15, 2017 at 11:02 AM, Johnny Rosenberg 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. On Sat, Apr 15, 2017 at 3:43 PM, Johnny Rosenberg wrote: > 2017-04-15 22:19 GMT+02:00 Dave Howorth : > > > On Sat, 15 Apr 2017 18:04:47 +0200 > > Johnny Rosenberg wrote: > > > > > Since this is still the only mailing list that I'm on that requires > > > me to hit ”Reply to all” to reply to the group, I failed doing so > > > again, and all the crap ended up at the OP only… so this is my second > > > try… > > > > Well that must be a problem with the crap mailer you use. A simple > > reply works fine for me. > > > > No, my message was crap (it's my signum), not the mailer. In fact, I don't > even know what a ”mailer” is. Email client? If so, I don't use one. I use > the web thing. > > > Have a nice day, you too. > > > > Kind regards > > Johnny Rosenberg > > > > > > > -- > > 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 > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns > ubscribe/ > 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 > On Sat, Apr 15, 2017 at 3:43 PM, Johnny Rosenberg wrote: > 2017-04-15 22:19 GMT+02:00 Dave Howorth : > > > On Sat, 15 Apr 2017 18:04:47 +0200 > > Johnny Rosenberg wrote: > > > > > Since this is still the only mailing list that I'm on that requires > > > me to hit ”Reply to all” to reply to the group, I failed doing so > > > again, and all the crap ended up at the OP only… so this is my second > > > try… > > > > Well that must be a problem with the crap mailer you use. A simple > > reply works fine for me. > > > > No, my message was crap (it's my signum), not the mailer. In fact, I don't > even know what a ”mailer” is. Email client? If so, I don't use one. I use > the web thing. > > > Have a nice day, you too. > > > > Kind regards > > Johnny Rosenberg > > > > > > > -- > > 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 > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns > ubscribe/ > 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 > On Sat, Apr 15, 2017 at 3:43 PM, Johnny Rosenberg wrote: > 2017-04-15 22:19 GMT+02:00 Dave Howorth : > > > On Sat, 15 Apr 2017 18:04:47 +0200 > > Johnny Rosenberg wrote: > > > > > Since this is still the only mailing list that I'm on that requires > > > me to hit ”Reply to all” to reply to the group, I failed doing so > > > again, and all the crap ended up at the OP only… so this is my second > > > try… > > > > Well that must be a problem with the crap mailer you use. A simple > > reply works fine for me. > > > > No, my message was crap (it's my signum), not the mailer. In fact, I don't > even know what a ”mailer” is. Email client? If so, I don't use one. I use > the web thing. > > > Have a nice day, you too. > > > > Kind regards > > Johnny Rosenberg > > > > > > > -- > > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > > Problems? http://www.libreoffice.org/get-help/ma
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
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 wrote: > 2017-04-16 17:30 GMT+02:00 QC : > >> 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
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 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 wrote: > >> 2017-04-16 17:30 GMT+02:00 QC : >> >>> 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
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
As long as I maintain the object in an ODF format, as a document or a template, it works as it should. It's only once LO saves it into an Office 2013 format, that it converts to an image. The Office 97 format preserves the embedded spreadsheet(s). On Sun, Apr 16, 2017 at 1:56 PM, M Henri Day wrote: > 2017-04-16 20:45 GMT+02:00 QC : > >> 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. >> > > <...> > > Thanks for responding with your experience, QC ! Alas I've never > encountered your problem, so my suggestion was not based on any concrete > experience on my part. Too bad it didn't work > > My suspcion is that the embedding process works differently in LO than in > MS Office, which may explain - but, unfortunately not resolve - your > problem. I doubt that using the latest stable version of LO - 5.3.1.2 - > would make any difference, but it would be interesting to learn if, in the > event you were to save the document in .odt format, the embedded > spreadsheet would still be converted into an image > > 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
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
On Sun, Apr 16, 2017 at 3:18 PM, Johnny Rosenberg wrote: > 2017-04-16 17:30 GMT+02:00 QC : > > > > > 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. > > > > Maybe it's just me, but isn't PDF just perfect for invoices? Why send a > word document to your clients unless you want them to be able to edit your > invoice? And why would you want that? Sorry for not understanding, it's > probably simple and I just misunderstood everything, stupid as I probably > am. > > > My client enters this information into his own records. For his ease of use I send him a format that makes it easy for him, rather than having to type it all in himself. > > 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. > > > > Anyway, I just tested to embed a spreadsheet in a text file, I saved it as > docx, closed everything and reopened it in LibreOffice Writer. The > spreadsheet was still embedded, so maybe something got corrupted in your > file. > > > Hmm, ok, thanks. So it's something on my end. Perhaps some tweak done by Linux Mint or Ubuntu. Or something in my own set up. On Sun, Apr 16, 2017 at 3:18 PM, Johnny Rosenberg wrote: > 2017-04-16 17:30 GMT+02:00 QC : > > > > > 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. > > > > Maybe it's just me, but isn't PDF just perfect for invoices? Why send a > word document to your clients unless you want them to be able to edit your > invoice? And why would you want that? Sorry for not understanding, it's > probably simple and I just misunderstood everything, stupid as I probably > am. > > > > > > > > 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. > > > > Anyway, I just tested to embed a spreadsheet in a text file, I saved it as > docx, closed everything and reopened it in LibreOffice Writer. The > spreadsheet was still embedded, so maybe something got corrupted in your > file. > > > Kind regards > > Johnny Rosenberg > > > > > > > On Sat, Apr 15, 2017 at 3:43 PM, Johnny Rosenberg < > gurus.knu...@gmail.com> > > wrote: > > > >> 2017-04-15 22:19 GMT+02:00 Dave Howorth : > >> > >> > On Sat, 15 Apr 2017 18:04:47 +0200 > >> > Johnny Rosenberg wrote: > >> > > >> > > Since this is still the only mailing list that I'm on that requires > >> > > me to hit ”Reply to all” to reply to the group, I failed doing so > >> > > again, and all the crap ended up at the OP only… so this is my > second > >> > > try… > >> > > >> > Well that must be a problem with the crap mailer you use. A simple > >> > reply works fine for me. > >> > > >> > >> No, my message was crap (it's m
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
On Sun, Apr 16, 2017 at 3:25 PM, Brian Barker wrote: > At 16:33 14/04/2017 -0500, Brian Noname wrote: > >> I've just discovered that when I save a copy of an invoice it's saving >> the spreadsheet part as an image. This is not the behavior I expected. >> [...] When I save a copy of this file as Word 2007/2010/2013 (*.docx) if >> converts the spreadsheets as an image! [...] The older Word 97 format is >> not readable anymore by one of my customers. If I save an 2003 .xml version >> Libreoffice can't even open a readable document again!? >> > > You are tying yourself in knots here - and quite unnecessarily. > > o Don't believe what one customer tells you about what s/he can or cannot > handle: they may just not be competent enough to understand. My bank > provides documents in the format it chooses; it may respond to suggestions > for changes from customers in general, but it certainly wouldn't believe me > if I simply claimed I couldn't handle what it provided. Is your bank any > different? > > Well, I'm not a big bank with loads of customers that I can less less if they take their business elsewhere. This is a major client, that brings me significant business. I'd have to find multiple clients to replace him. That's a lot of work. So I do what I can to keep him happy. o You are confusing on the one hand the format in which you keep our own > records and active documents and on the other hand what you send your > customers. You may need part of a spreadsheet in a text document to be > active but you should not want your customers to be able to modify your > invoices easily. They may halve the price and pay you accordingly! > > No, I'm not. I use one format, and he has requested another. I keep my records and my own copies of invoices, etc. I make him a special copy, just for him. Because I want to keep him happy. It's just good business. But that copy is not being done right. > o Save and keep your own documents in LibreOffice's native Open Document > Format formats, here .odt and .ods. Use a DDE link to an .ods spreadsheet > document in your .odt text document if you wish. > > I do. > o Send your customers a frozen document. You need a format that is > suitable for final versions of documents and is robust to changes between > systems - operating system, installed fonts, printers, printer drivers, and > so on - and is also easily displayed by and printed from application > software that is easily available for a wide range of platforms and > conveniently free of charge for your customers. That is not *any* word > processor document format; that's PDF. Oh look: LibreOffice will export > your documents as PDF. > > Yes, but he enters the data from my invoice into his own systems. This allows him to not have to key it all in, if he can copy and paste. > At 10:30 16/04/2017 -0500, Brian Noname wrote: > >> I can't dictate to paying clients what software to use to open my >> invoices. >> > > No, but you can dictate the format in which you choose to provide invoices > - providing that is reasonable (as PDF is). > > I can't just send it in ODF. Unless MS Office has suddenly decided to >> support reading ODF files. >> > > Microsoft claims it has done this - though not "suddenly". (But you > shouldn't want to use office formats anyway; see above.) This is something special I do for a major client, to increase his customer satisfaction. > > > I could send it in PDF, and will if I have no other choice. >> > > It's the best choice: you need no "other choice". > > I use this system for my business. It has to work, or I have to use >> something else. >> > > As always, you are very welcome to use whatever software you wish. > LibreOffice will work for you, but chacun à son goût. > > At 14:14 16/04/2017 -0500, Brian Noname wrote: > >> As long as I maintain the object in an ODF format, as a document or a >> template, it works as it should. >> > > Good. Using LibreOffice's native format for your own document files is > what you should always do. > > It's only once LO saves it into an Office 2013 format, that it converts to >> an image. >> > > So don't do that (for your own use). See above. Again, I don't. It's a special thing I do for a special client who has asked for this to make his work easier. It should have been a simple thing to do, and has been or years. But suddenly when I use the newer format it doesn't work the same way. I can export it to PDF, and I have confirmed that I can copy and paste the text, from the PDF, but it loses it's spreadsheet layout. I don't know if that will work for him. So he will be able to use it, but at a reduced level of productivity. It's at least better than an image where he can't copy and paste the data at all. It's a far cry from the simple solution of it being a spreadsheet. I may just have to send him the underlying spreadsheet instead of the nicer format of the company invoice, or in addition to it. The spreadsheet might even be better for him. But the good new
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
Well none of that worked. :/ However, I can save as .xlsx and manipulate it in Office 2010. I can confirm my copy of LibreOffice is creating unusable files in Office 2010, and probably 2013 as well. So I guess I'll send him a .xlsx invoice, going forward. I suspect I have a bad configuration file or setting. I'll install a clean, newer Mint release on a spare partition of two, and test a fresh Libreoffice in a fresh and clean install and see if this problem goes away. Probably some old configuration setting that I kept in an update, that I should have rejected, removed, or changed. Thanks everyone for trying to help. On Sun, Apr 16, 2017 at 4:59 PM, QC wrote: > On Sun, Apr 16, 2017 at 3:25 PM, Brian Barker > wrote: > >> At 16:33 14/04/2017 -0500, Brian Noname wrote: >> >>> I've just discovered that when I save a copy of an invoice it's saving >>> the spreadsheet part as an image. This is not the behavior I expected. >>> [...] When I save a copy of this file as Word 2007/2010/2013 (*.docx) if >>> converts the spreadsheets as an image! [...] The older Word 97 format is >>> not readable anymore by one of my customers. If I save an 2003 .xml version >>> Libreoffice can't even open a readable document again!? >>> >> >> You are tying yourself in knots here - and quite unnecessarily. >> >> o Don't believe what one customer tells you about what s/he can or cannot >> handle: they may just not be competent enough to understand. My bank >> provides documents in the format it chooses; it may respond to suggestions >> for changes from customers in general, but it certainly wouldn't believe me >> if I simply claimed I couldn't handle what it provided. Is your bank any >> different? >> >> > Well, I'm not a big bank with loads of customers that I can less less if > they take their business elsewhere. This is a major client, that brings me > significant business. I'd have to find multiple clients to replace him. > That's a lot of work. So I do what I can to keep him happy. > > > o You are confusing on the one hand the format in which you keep our own >> records and active documents and on the other hand what you send your >> customers. You may need part of a spreadsheet in a text document to be >> active but you should not want your customers to be able to modify your >> invoices easily. They may halve the price and pay you accordingly! >> >> No, I'm not. I use one format, and he has requested another. I keep my > records and my own copies of invoices, etc. I make him a special copy, just > for him. Because I want to keep him happy. It's just good business. But > that copy is not being done right. > > >> o Save and keep your own documents in LibreOffice's native Open Document >> Format formats, here .odt and .ods. Use a DDE link to an .ods spreadsheet >> document in your .odt text document if you wish. >> >> I do. > > >> o Send your customers a frozen document. You need a format that is >> suitable for final versions of documents and is robust to changes between >> systems - operating system, installed fonts, printers, printer drivers, and >> so on - and is also easily displayed by and printed from application >> software that is easily available for a wide range of platforms and >> conveniently free of charge for your customers. That is not *any* word >> processor document format; that's PDF. Oh look: LibreOffice will export >> your documents as PDF. >> >> Yes, but he enters the data from my invoice into his own systems. This > allows him to not have to key it all in, if he can copy and paste. > > >> At 10:30 16/04/2017 -0500, Brian Noname wrote: >> >>> I can't dictate to paying clients what software to use to open my >>> invoices. >>> >> >> No, but you can dictate the format in which you choose to provide >> invoices - providing that is reasonable (as PDF is). >> >> I can't just send it in ODF. Unless MS Office has suddenly decided to >>> support reading ODF files. >>> >> >> Microsoft claims it has done this - though not "suddenly". (But you >> shouldn't want to use office formats anyway; see above.) > > > This is something special I do for a major client, to increase his > customer satisfaction. > > >> >> >> I could send it in PDF, and will if I have no other choice. >>> >> >> It's the best choice: you need no "other choice". >> >> I use this system for my business. It has to work, or I have to us
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
Yes, most people can read a pdf. That's not the issue here. The issue is a customer wants to copy and paste the contents of the invoice for his own bookkeeping processes. Copy and pasting from a pdf is not the same as copy and paste from a spreadsheet. I have a specific need to save a copy as a Microsoft Office readable format. I have been saving as a copy for years as a Microsoft Word document for this one client, and it has worked until recently. Most likely I did an upgrade on Libre Office and broke something. I have found a solution, that saving only the spreadsheet portion and sending that as an Excel document will work for him. Until I figure out what I broke. On Sun, Apr 16, 2017 at 6:17 PM, Dave Stevens wrote: > On Fri, 14 Apr 2017 16:33:01 -0500 > QC wrote: > > > I've just discovered that when I save a copy of an invoice it's > > saving the spreadsheet part as an image. This is not the behavior I > > expected. > > > > I'm running: > > Linux mint 17 64 bit > > KDE 4.13 > > LibreOffice 4.4.7.2 > > > > When I save a copy of this file as Word 2007/2010/2013 (*.docx) > > if converts the spreadsheets as an image! > > > > Is this some setting? I've tried Googling, but it keeps showing my > > link on how to save things as an image. Completely not what I want to > > do. > > > > The older Word 97 format is not readable anymore by one of my > > customers. If I save an 2003 .xml version Libreoffice can't even open > > a readable document again!? > > > > Are there some configuration details I'm missing? > > > > Brian > > > > something I often do is save as a file. you get to specify the file > name and location and can save as a .pdf. I think most folks can read > that. > > D > > > -- > In modern fantasy (literary or governmental), killing people is the > usual solution to the so-called war between good and evil. My books are > not conceived in terms of such a war, and offer no simple answers to > simplistic questions. > > - Ursula Le Guin > > -- > 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 > > -- 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
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
On Sun, Apr 16, 2017 at 11:28 PM, Brian Barker wrote: > At 16:59 16/04/2017 -0500, Brian Noname wrote: > >> Yes, but he enters the data from my invoice into his own systems. This >> allows him to not have to key it all in, if he can copy and paste. >> > > Aha! I think that is the first we've heard of that. > Actually, I've mentioned that several times. Perhaps not in these exact terms. ;) > > I can export it to PDF, and I have confirmed that I can copy and paste the >> text, from the PDF, but it loses its spreadsheet layout. I don't know if >> that will work for him. So he will be able to use it, but at a reduced >> level of productivity. >> > > If he needs the functionality of a spreadsheet - formulae and such, and > not just the data - then PDF will indeed not do. > > He doesn't need the functionality of a spreadsheet. I could give him a tab delimited file for all that matters. I don't do a lot of fancy stuff in my invoices. I prefer to keep things as simple as possible. That's not always possible, nor my natural inclination ( unfortunately). I'll install a clean, newer Mint release on a spare partition of two, and >> test a fresh Libreoffice in a fresh and clean install and see if this >> problem goes away. Probably some old configuration setting that I kept in >> an update, that I should have rejected, removed, or changed. >> > > A simpler way may be just to delete or rename your LibreOffice user > profile (whilst LibreOffice is closed). That should have the same effect. > I'm not sure that would work. There is the system level configuration, and also my individual level configuration. The error (probably my fault) in the configuration could be in either one, since I am the administrator of the system. I could try it on one of the other company computers, but the system configuration would still be my doing, and the upgrades and upgraded configurations also my doing, or worse that of my administrative assistant (not exactly a computer geek). > I hope you won't see me as being unnecessarily critical if I say that part > of the problem here was that you did not declare some of the boundary > conditions to your problem in your earlier messages. It was not surprising > that people offered apparently useful suggestions that didn't satisfy you. > It helps other to help you best if you can give such detail up front. Critical observations don't bother me. I've been on the other end of support issues: Client: "I've pressed the power button and nothing happens! See!" Me: "That's the mouse. This is the power button." ;) -- 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
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
On Sun, Apr 16, 2017 at 12:37 AM, Mike Scott wrote: > > It looks as though he has a writer file with an embedded calc document. > Exporting as docx indeed renders the embedded spreadsheet as an image. I'm > not sure what he would expect to happen - embed an LO spreadsheet in a MS > Word document!? Translate the spreadsheet to something Word supports in the > same way (IIRC not in general possible but IANAE) Or what? > > I do indeed have a LO writer document with an embedded calc object. I downloaded this as a template from the then official Open Office templates site, oh about 10 years ago. It's not my design. But it's worked for me for years. > My thought though is his document is 'inside out'. If the important parts > are the numbers, perhaps it would better be a Calc document with embedded > text and images; I'd suggest this would export better to something MS might > support. > Perhaps. But I didn't develop it. Although I have tweaked it for my own purposes. > > He doesn't say why he needs to export to docx - I thought these days MS > had some support for ODF documents. Could the recipient not cope with the > odt file? I have repeatedly said why I need to export to docx. Because I have a client who takes the data from my invoice and copies it into his accounting system. As a spreadsheet, he can copy and paste what he wants without having to type it all in. The older .doc format I used to use is now broken, as a result of some update I applied to this (now) quite old version of Libre Office, running on an old LTS Qiana Linux Mint desktop. I can indeed open the original (and my company's official version) ODT document in newer MS Office programs, but they don't like the embedded spreadsheet part and strip it out. This defeats the purpose of opening in Word 2010 or later as that's the important part. ;) So, until I can install the latest stable Mint, and test it on my system, and then upgrade the rest of the systems. I will just invoice him with an actual spreadsheet as an invoice. Maybe I'll even move entirely to that layout. Thanks everyone for your help! -- 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
Re: [libreoffice-users] Libre Office saving spreadsheets as images when saving as Word docx!?
In trying to resolve this, I've deleted the embedded sheet and added a new one. So I doubt that is the issue. I may have deleted the original embedded spreadsheet years ago, for a similar reason. But this template here would have the embedded sheet, I've been using for at least 3 years. I've added sample data in it, so you can see the kind of data and minimal calcs I do. There is normally an external link on the second page of the invoice, when there is a second page, because I've never found a way to link internally to the first embedded spreadsheet, and using a single spreadsheet, has never given me the look I wanted to present. (I know, stupid reason for not using a single spreadsheet with recurring headers.) The link is removed here. I had tried removing the link from the two page invoices, in case that was the cause, a while ago. But this also is a problem with one page invoices. So it's not that. I haven't actually used a template in ages. Just clear the previous month's invoice and save to a new file. I know, my system could be streamlined in so many ways, but I seem to never give myself enough time to do my internal change requests. ;) On Mon, Apr 17, 2017 at 1:34 PM, Regina Henschel wrote: > Hi, > > QC schrieb: > >> On Sun, Apr 16, 2017 at 12:37 AM, Mike Scott >> wrote: >> >> >>> It looks as though he has a writer file with an embedded calc document. >>> Exporting as docx indeed renders the embedded spreadsheet as an image. >>> I'm >>> not sure what he would expect to happen - embed an LO spreadsheet in a MS >>> Word document!? Translate the spreadsheet to something Word supports in >>> the >>> same way (IIRC not in general possible but IANAE) Or what? >>> >>> I do indeed have a LO writer document with an embedded calc object. I >>> >> downloaded this as a template from the then official Open Office >> templates >> site, oh about 10 years ago. It's not my design. But it's worked for me >> for >> years. >> >> > Can you please sent me the template? If it is so old, it might be, that it > has not embedded an ods-spreadsheet but a sxc-spreadsheet. > > Kind regards > Regina > > > > -- > To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-uns > ubscribe/ > 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 > -- 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
