Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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??? What, pray tell is unclear about: Click 'Insert' 'Hyperlink' 'Document' 'Target' 'OtherSheet' ? Seriously. I, the user, by doing the above, am *telling* it to go to a *different sheet*. You honestly don't think that is clear enough for the program? If you give it the full path i.e. 2012.A1, then it can accept the hyperlink. You appear to assume that all hyperlinks will be to another spreadsheet. And you obviously did not read - or did not comprehend - my email - try again. Hyperlinks are also used in the Writer and Drawing modules. Irrelevant to my point. In order to cater for all the different circumstances, I cannot see how it could have been coded otherwise. Surely it is up to the User to input precisely what they want. That is *precisely what I am doing. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 on Sheet 2014. 1. The GUI itself allows me to select *just* a sheet name, nothing else is required, or even asked for: Click 'Insert' 'Hyperlink' 'Document' 'Target in Document' button 'OtherSheet' 2. If the sheet name is anything other than *just* a number, clicking the hyperlink takes me to the desired sheet. 3. If the target sheet name is just a number, it takes me to that number row but in the CURRENT sheet, NOT in the target sheet. Interestingly, what *cell* it decides to land on in the target sheet seems to be random. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4044497.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 apparently you cannot read and/or understand what I am saying. My point is, if, using the GUI, when adding a hyperlink, and I select a SHEET named with a number, I obviously am telling Libreoffice to link to that SHEET, NOT the row# on the CURRENT sheet. If you cannot see that, then please just don't reply any more because I am tired of repeating myself. Go to the bug and read the comments. I have. I am the bug creator. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 you keep on weening about the structure and exact wordings of the message, or you use the energy to find a solution. I do support as well, in another domain, and my choice is always to help the enduser. I hope LO can improve the support by helping people. This way, you send people to MS, which is very sad. (and yes, I once entered a bug myself, on which I received so much negative comment, I'd think twice to enter a bug again... such a pity) Met vriendelijke groeten, Salutations distinguées, Kind Regards, DRIES FEYS CORPORATE SERVICES • Specialist Software Developer On 18 March 2013 15:53, Tanstaafl tansta...@libertytrek.org wrote: 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 apparently you cannot read and/or understand what I am saying. My point is, if, using the GUI, when adding a hyperlink, and I select a SHEET named with a number, I obviously am telling Libreoffice to link to that SHEET, NOT the row# on the CURRENT sheet. If you cannot see that, then please just don't reply any more because I am tired of repeating myself. Go to the bug and read the comments. I have. I am the bug creator. -- For unsubscribe instructions e-mail to: users+h...@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 -- DISCLAIMER http://www.tvh.com/newen2/emaildisclaimer/default.html This message is delivered to all addressees subject to the conditions set forth in the attached disclaimer, which is an integral part of this message. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 corrected. I just do not see why this needs to be corrected. Please do not take offense, I started off trying to help. Tink. -- View this message in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4044537.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 without the cell reference, e.g. #Sheet 2, it takes you that sheet but looks to retain the last cell referenced, i.e. the landing cell is erratic. 3) And if as Tanstaafl reports in fdo#62289 https://bugs.freedesktop.org/show_bug.cgi?id=62289 even if you use the GUI and select the numbers only page name, e.g. 3 so hyperlink is #3 ,the link is interpreted incorrectly and you remain on the same page--and apparently in that numbered row. 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 hyperlink target, the parser should identify the sheet and default to a consistent cell--A1 I would imagine. Stuart -- View this message in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4044553.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 hyperlink target, the parser should identify the sheet and default to a consistent cell--A1 I would imagine. Precisely, and I agree A1 is the most logical choice for the default... So, the user would click the sheet name (#2), and the target should be entered as #2.A1, which the user would then be free to modify if desired. Thanks for confirming Stuart -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 if I did that. I know the Hyperlink has not asked for the cell reference, but you could give it anyway. Agreed, but this is irrelevant to the bug report. There are far too many bugs waiting to be corrected. I just do not see why this needs to be corrected. Maybe because it would (most likely) be trivial? And I don't recall any Libreoffice developer ever saying 'Hey, we have too many bugs, please stop reporting them unless they are 'really important'(tm)... Please do not take offense, I started off trying to help. Ok, no problem, probably it is just a language thing... Anyway, my whole point of the bug is that what the user intends, because they intentionally selected the other SHEET (named with a number), does not occur. As Stuart just pointed out, the best fix would be for the picker to just add the .A1 to the sheetname (regardless of whether or not it is a number), then let the user edit it if desired. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 new sheet. Very odd though. Tink. -- View this message in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4044290.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 sheet, it only adds a link to 'Number', which results in the hyperlink taking yo to that RowNum in the current sheet. This is *obviously* not what the user wanted, because they intentionally chose the other sheet. What it should do is add a hyperlink to SheetName.A1 (and let the user decide whether or not to change the target cell or not). Apparently this is what it used to do, hence, this is a regression. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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, just as I have been experiencing. It follows then that there must be: A difference in the interpretation, i.e. a bug in the Mac version, or a difference in the instruction, i.e. my entry into the drop down frame. Here is my entry: http://nabble.documentfoundation.org/file/n4044189/Link.jpg Adding a Name does not apply. I cannot see what other arrangement I could have tried. Tink. -- View this message in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4044189.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 say this constitutes a BUG? Tink. -- View this message in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4044219.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 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, just as I have been experiencing. It follows then that there must be: A difference in the interpretation, i.e. a bug in the Mac version, or a difference in the instruction, i.e. my entry into the drop down frame. Here is my entry: http://nabble.documentfoundation.org/file/n4044189/Link.jpg Adding a Name does not apply. I cannot see what other arrangement I could have tried. Tink. -- View this message in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4044189.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 and it moved the Link to Sheet 2011, just as I have been experiencing. It follows then that there must be: A difference in the interpretation, i.e. a bug in the Mac version, or a difference in the instruction, i.e. my entry into the drop down frame. Here is my entry: http://nabble.documentfoundation.org/file/n4044189/Link.jpg Adding a Name does not apply. I cannot see what other arrangement I could have tried. Tink. Hi. Just ried 3.6 on my mac, it works the same as 3.6 on Suse. What do you mean in your reference to the drop down frame. I insert the hyperlink by selecting (highlighting) the text in the cell that is to contain the hyperlink and then typing in 2012.A12 where you show it. The text Next Year is the text that I highlighted. Steve -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 first will mess up your Sheets. Would you say this constitutes a BUG? Tink. Works for me without saving. I just create a new calc document, insert a sheet and rename to 1012. Go back to the first sheet, type some text in a cell Goto 2012, highlight it and InsertHyperlink, type in 2012.A1 for the target and all works fine. Steve -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4044028.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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, 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 from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4043921.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] Re: Hyperlink Bug in calc - bug 62289
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 more intuitive can help. Tink. Thanks. It worked for me. Highlighted text in sheet zyz to be the hyperlink, then insert hyperlink and then typed in the target 2012.a1 The hyperlink stayed ok on the original page. It seems it is just adding the hyperlink with the target button that is broken. When you select a sheet it inserts, say 2012 and it should insert 2012.a1 as a minimum. Steve -- For unsubscribe instructions e-mail to: users+h...@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