Date: prev next · Thread: first prev next last
2017 Archives by date, by thread · List index


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


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.