Re: [libreoffice-users] To open a second Sheet with one mouse click from the first Sheet in same document?

At 05:12 26/09/2014 -0700, Csányi Pál wrote:
> Is it possible to create a hyperlink in a cell ( 
> text or button ) in one Calc Document on one 
> Sheet so if one click on that hyperlink then get 
> focused another Sheet in the same Document? The 
> purpose of this would be that one should not 
> searching a specific Sheet in the same Calc 
> document but only to click in the first Sheet on 
> a hyperlink so to get quickly the desired Sheet focused for a data entry.

Here's an easy way:
o Go to View | Navigator (or press F5).
o Click the Drag Mode drop-down and select "Insert as Hyperlink".
o Expand the Sheets item in the list.
o Drag the sheet name from the list to the required cell.

A simple click on the generated hyperlink will 
take you to the required sheet. If you prefer, 
you can create a named range on the target sheet 
and hyperlink to that instead of to the plain sheet.

I trust this helps.

Brian Barker


--
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