Forgive me if this has been discussed; I searched the archive but didn't
find anything...
I have a large spreadsheet, and I'm trying to create a row of buttons
near the top that, when clicked, will take me down to specific sections
(via a named range). Here's how to reproduce:
1. start with blank spreadsheet
2. page down a couple times, and then Sheet -> Named Ranges and
Expressions -> Define...
3. Name: FOO, click Add, go back up top to row 1.
4. Ctrl+K (insert hyperlink), Document, Target: FOO (URL becomes #FOO),
Form: Button, Text: Jump To Foo, click OK
5. Make sure Design Mode is off, click button, and you should jump down
to the row where you created the named range.
So far so good, right? Ok, now save the document and close LibreOffice.
Re-open the document, and the button no longer works.
Does anyone have any ideas? I've gotta be doing something wrong.
My setup:
Windows 7 x64
Java 1.8.0_121
LibreOffice:
Version: 5.4.2.2
Build ID: 22b09f6418e8c2d508a9eaf86b2399209b0990f4
CPU threads: 8; OS: Windows 6.1; UI render: default;
Locale: en-US (en_US); Calc: CL
Thanks!
--
ryan
--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
- [libreoffice-users] Trouble in Calc with button hyperlink · Ryan T. Morgan
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.