Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Tanstaafl
On 2013-03-17 2:59 PM, Tinkerer j_taylo...@btinternet.com wrote: Tanstaafl Sorry, but there is no bug. Tink Sorry, but you are wrong. The Program has no way of knowing whether you want to move to another place on the same sheet, or whether you want to move to another sheet. Seriously???

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Tanstaafl
On 2013-03-14 4:17 PM, Tinkerer j_taylo...@btinternet.com wrote: For the benefit of others, there is no bug. For the benefit of others, there is most certainly a bug. Tink, stop saying otherwise. You need to include a position on the sheet, say: Target 2014,A1 This will take you to cell A1

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Tinkerer
Tanstaafl If I enter 2014.A1 as the Hyperlink target, a click on it takes me to sheet 2014 cell A1 If I enter 2012.C12 the link takes me to Sheet 2012 Cell C12 So where is the Bug? Go to the bug and read the comments. Tink. -- View this message in context:

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Tanstaafl
On 2013-03-18 10:27 AM, Tinkerer j_taylo...@btinternet.com wrote: Tanstaafl If I enter 2014.A1 as the Hyperlink target, a click on it takes me to sheet 2014 cell A1 If I enter 2012.C12 the link takes me to Sheet 2012 Cell C12 So where is the Bug? sigh The first and foremost bug is that

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Dries Feys
Guys, What are we discussing about? Ok, the bug isn't the hyperlink which doesn't work, but it's easy reproducable following the steps Tanstaafl did provide easy and clearly. The bug is with other words the hyperlink creating, instead of the hyperlink processing. There are 2 options now : or

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Tinkerer
I understand perfectly what you are saying. I just do not understand why you cannot enter the cell location as well as the sheet number. When I do it, it just works. I know the Hyperlink has not asked for the cell reference, but you could give it anyway. There are far too many bugs waiting to be

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread V Stuart Foote
Actually the bug is exactly as described. Testing with LibreOffice 4.0.2 rc1 The problem is in interpreting an incomplete hyper link. 1) If the complete hyper link is entered Sheet 2.A2 it becomes #Sheet 2.A2 And movement to that sheet and cell is reliable. 2) If you insert the hyperlink

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Tanstaafl
On 2013-03-18 12:55 PM, V Stuart Foote vstuart.fo...@utsa.edu wrote: So there is definitely an issue with the Target in Document GUI picker allowing an incomplete hyper link. Or equally an inconsistent parser/handling logic for incomplete hyperlink targets--would think that absent a complete

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-18 Thread Tanstaafl
On 2013-03-18 12:17 PM, Tinkerer j_taylo...@btinternet.com wrote: I understand perfectly what you are saying. I just do not understand why you cannot enter the cell location as well as the sheet number. When I do it, it just works. I didn't say I couldn't do it, and I didn't say it didn't work

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-17 Thread Tinkerer
Steve I have tried this on Mac 10.8.2 and Mac 10.8.3 For LibreO, I have tried 4.0.1 and 4.0.2.1 with no variation in the results. There must be something in the way I have it set up in the Preferences. Now I know how to cope with it, it isn't much of a problem as it only happens when you set up a

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-17 Thread Tanstaafl
On 2013-03-16 8:47 AM, Tinkerer j_taylo...@btinternet.com wrote: Steve There is no bug. Yes, there is. When you add the hyperlink using the GUI (Insert Hyperlink Document Target OtherSheet), where OtherSheet name is only a number, it adds a hyperlink that doesn't take you to that

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Tinkerer
Steve There is no bug. Not all Hyperlinks will be to another Sheet, so adding a sheet location would cause more problems. The Documentation could be improved though. Thank you for your example, it works. I tried adding another Hyperlink to your Sheet 2012 and it moved the Link to Sheet 2011,

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Tinkerer
Hi Steve Doh! The solution is unbelievably simple. It does not much matter what technique you use as long as you have 2011.A1, or equivalent, in a Hyperlink. To make it work you have to SAVE the file before you use the Hyperlink. Any attempt to test it first will mess up your Sheets. Would you

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Steve Edmonds
Hi. What version LO are you using. I will fire up my mac and check there too, my last test was 3.6 on Suse. Steve On 2013-03-17 01:47, Tinkerer wrote: Steve There is no bug. Not all Hyperlinks will be to another Sheet, so adding a sheet location would cause more problems. The Documentation

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Steve Edmonds
On 2013-03-17 01:47, Tinkerer wrote: Steve There is no bug. Not all Hyperlinks will be to another Sheet, so adding a sheet location would cause more problems. The Documentation could be improved though. Thank you for your example, it works. I tried adding another Hyperlink to your Sheet 2012

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-16 Thread Steve Edmonds
On 2013-03-17 07:19, Tinkerer wrote: Hi Steve Doh! The solution is unbelievably simple. It does not much matter what technique you use as long as you have 2011.A1, or equivalent, in a Hyperlink. To make it work you have to SAVE the file before you use the Hyperlink. Any attempt to test it

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-15 Thread Tinkerer
Steve No luck with either Hyperlink from the INSERT menu, or Hyperlink from the Functions. The Help pages are anything but on this subject. Can you send me a copy of your file so that I can try it. Many thanks, Tink. -- View this message in context:

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-14 Thread Tinkerer
For the benefit of others, there is no bug. You need to include a position on the sheet, say: Target 2014,A1 This will take you to cell A1 on Sheet 2014. Tink. -- View this message in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4043877.html Sent

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-14 Thread Steve Edmonds
So the bug is in the window that pops up for target (press the target button). It inserts sheet incorrectly as the target. This sounds an easier fix. But if I enter 2014,A1 as the target I get the error invalid range. Steve On 2013-03-15 09:17, Tinkerer wrote: For the benefit of others,

[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-14 Thread Tinkerer
Steve Replace the comma with a stop. Alas it still does not work correctly. It moves the cursor to Sheet 2014 Cell A1, but it also moves the Hyperlink to Sheet 2014 as well. I have not the time to sort that out at present. Perhaps someone more intuitive can help. Tink. -- View this message

Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289

2013-03-14 Thread Steve Edmonds
And for the group. On 2013-03-15 12:48, Tinkerer wrote: Steve Replace the comma with a stop. Alas it still does not work correctly. It moves the cursor to Sheet 2014 Cell A1, but it also moves the Hyperlink to Sheet 2014 as well. I have not the time to sort that out at present. Perhaps someone