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+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
Context
- [libreoffice-users] Automatic updating of a cell from one spreadsheet to another doesn't work · QC
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.