Re: [libreoffice-users] How to disable undesired error indicator
Hi :) That sounds weird. Have you tried renaming the User Profile just to see if it's something in there? Regards from Tom :) On 25 August 2014 21:44, CVAlkan fobe...@enteract.com wrote: When adding a footnote reference to the end of a sentence, the typical style requirement is that the period comes first and then the footnote number, which is usually superscripted. When I do this, however, I've always been slightly annoyed that the fact that there is no space after the period is given the old blue squiggly underline, as is the fact that footnote number itself gets one (apparently Writer thinks the next sentence begins with a number, which it doesn't like). I finally decided to dive into the scattered configuration menus and disable these actions, but after looking everywhere I could think of or locate, could not find a place to do this. Does anyone know where this sort of thing is located? Or, might this be an actual bug in the routines that determine the conditions (e.g. it doesn't notice that the number is actually a footnote reference). Any help would be appreciated. Thanks ... -- View this message in context: http://nabble.documentfoundation.org/How-to-disable-undesired-error-indicator-tp4120218.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Numbering/Outline levels in Writer
Hi :) Congrats to Dave Boland on findingfixing it! Nicely done. :)) Regards from Tom :) On 27 August 2014 03:28, Steve Edmonds steve.edmo...@ptglobal.com wrote: Not the most intuitive. It would have made more sense to me to put the default outline style used in headings in styles. Steve On 2014-08-27 12:46, dave boland wrote: Thanks! I got it to work playing with Tools/Outline Numbering. Not the most intuitive choice (Format/Bullets Numbering would be more likely), but it works and I'm happy. Thanks again! Dave, On Mon, Aug 25, 2014, at 11:30 PM, dave boland wrote: How is this done? I have another document that needs this type of numbering, so I used F11, went to Heading 1, Modify, but could not find a way to go from 1. to 1.0. Same deal with Heading 2 - how do I chage the style so it goes from 1. to (for example) 1.1 or 2.1 etc. I looked at the help section, but it was obviously not helpful enough (for me). Thanks! Dave On Thu, Aug 14, 2014, at 11:36 AM, Kevin O'Brien wrote: Yes, got caught again by that damn list problem. Well, I would say that earlier version of MS Office (i.e. any time up to 2003) had very usable styles, but maybe that is a matter of taste. I had to do the very thing the original questioner asked about in MS Office 2010 a couple of weeks ago and it was a lot harder than in LibreOffice. But the general answer for any modern office suite is to do it with styles. Regards, On Thu, Aug 14, 2014 at 9:52 AM, Tom Davies tomc...@gmail.com wrote: Hi :) I think Styles often get ignored by beginners because in MS Office they are more of a hindrance than a useful tool. In LibreOffice they are really useful though so it's good to introduce people to them at the slightest excuse. I was hoping your message would go to the whole mailing list but it only came to me :( I think it would really help the couple of new people that have joined recently. Regards from Tom :) On 14 August 2014 13:44, Kevin O'Brien zwiln...@gmail.com wrote: Well, I always keep the Styles and Formatting window open and anchored to the left of the screen, so I would just access the List styles there. Regards, On Thu, Aug 14, 2014 at 3:57 AM, Tom Davies tomc...@gmail.com wrote: Hi :) From the Format menu, the icon-toolbar or the F11, Styles, extra menu or somewhere else? Regards from Tom :) On 14 August 2014 00:43, Kevin O'Brien zwiln...@gmail.com wrote: Well, I do it using a List style. Regards On Wed, Aug 13, 2014 at 4:07 PM, dave boland dbola...@fastmail.fm wrote: Writer used to allow this from a slection in Outline 1.0 Head 1 1.1 Head 2 1.2 Head 2 1.2.1 Head 3 2.0 Head 1 Can't find how to do it in 4.1.3.2 Any ideas? Dave, -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Same, same, but different... -- To unsubscribe e-mail to: users+unsubscr...@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 -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien Facebook is Evil. Cancel your account. -- To unsubscribe e-mail to: users+unsubscr...@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 -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien Facebook is Evil. Cancel your account. -- Kevin B. O'Brien zwiln...@gmail.com http://google.me/+kevinobrien Facebook is Evil. Cancel your account. -- To unsubscribe e-mail to: users+unsubscr...@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 -- dave boland dbola...@fastmail.fm -- http://www.fastmail.fm - Choose from over 50 domains or use your own -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-
Re: [libreoffice-users] unable to authentication login/password through proxy in OpenOffice
On 2014-08-26 21:52, Mark Bourne wrote: carbol...@openmailbox.org wrote: [...] I would like to get geocode by web service Google API, my macro works at home (without proxy) but not at work (through proxy). At work (Windows 7, LibO 4.0.5.2) , when I launch my macro, LibO freeze any seconds and replay Error 1: Une exception s'est produite : Type: com.sun.star.ucb.InteractiveNetworkConnectException Message: . (line : 194) [...] Not entirely sure if this will work, but try: [Snip the explanations I've followed letter by letter] - Now try accessing the web service from LibreOffice. Doesn't work :-( Another possibility is that the service is blocked by your proxy. Are you able to access it from work through any other means to test? e.g. another application, by manually connecting to it (if you know what you're doing and it uses a plain-text protocol, you can connect a telnet session via telnet address port from a command prompt, and then type the requests and see if you get a response back). I would like to use a Google geocoding service. It works with my/your favorite browser (through proxy): http://maps.googleapis.com/maps/api/geocode/xml?sensor=trueaddress=grand\%27place+Brussels+Belgium return a xml including location coordinates. My webbrowser ask me the proxy's login/passwd. It works with wget through proxy (Cygwin installed, .wgetrc configured with proxy's login/passwd). To use the google service with LibO, I have found the following webpage: http://www.tuicool.com/articles/IN7zEb. It works on a connection without proxy but not trough proxy. I've tried the following macro in LibO (simplier) - same result: works without proxy, not with proxy! Sub Macro1 open http://www.google.com; for input as #1 line input #1, texte close #1 print texte End Sub LibO want not to pass trough proxy! Does it exist an another way to use webservices into LibO (pluggin, or something like that ?) It may be worth asking your IT department what you might need to do to get through their proxy; the rest of us can only guess at how it might be configured. Some are more aggressive than others in blocking certain types of traffic. I'll see with him. Thanx you very much for your help. We keep in touch. Mark. Bruno. -- To unsubscribe e-mail to: users+unsubscr...@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: LO Writer (Linux): Way to do text search in set of documents?
On Tue, 26 Aug 2014 11:22:08 +, I wrote: I need to be 'in' LO Writer when the text is found, so that I can look around the context. I.e. I want to use the LO Writer 'Find' function, but spanning more than one file. (There would be likely to be several instances of the 'find' text in each file.) The simplest way would presumably be to write an app that would create a temporary composite document from a list, and do the Find through that. I had been wondering if there was an LO Writer function that would continue a Find over a given list of files, but I guess not. -- /\/\aurice -- To unsubscribe e-mail to: users+unsubscr...@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: LO Writer (Linux): Way to do text search in set of documents?
2014-08-27 13:15 GMT+02:00 Maurice maur...@bcs.org.uk: The simplest way would presumably be to write an app that would create a temporary composite document from a list, and do the Find through that. I don't know if that's what you meant, but it might be possible to achieve this through a macro inside LibreOffice. -- To unsubscribe e-mail to: users+unsubscr...@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] unable to authentication login/password through proxy in OpenOffice
Ciao Bruno! Have you tried to put credentials on proxy URLs in LibreOffice proxy settings (Tools - Options - Internet - Proxy - Manual)? I mean something like this: Proxy HTTP: http://proxy_user:proxy_passw...@proxy.server.com:proxy_port/ (or with the proxy port only in the LibreOffice proxy port field) Proxy HTTPS: https://proxy_user:proxy_passw...@proxy.server.com:proxy_port/ (ibidem) Proxy FTP: ftp://proxy_user:proxy_passw...@proxy.server.com:proxy_port/ (ibidem) And so on... Have a sunny day, Carlo p.s. Webgrafia: http://www.gnu.org/software/wget/manual/html_node/Proxies.html http://stackoverflow.com/questions/34079/how-to-specify-an-authenticated-proxy-for-a-python-http-connection - from this you can get some further ideas for your macros... -- ing. Carlo Strata - via Botticelli 1/4 30031 Dolo - VE Italia - Italy - tel./fax +39.041.822.0665 cell. +39.347.85.69.824 Skype carlo.strata Google carlo.strata.69 - carlo.str...@tiscali.it PEC: carlo.str...@ingpec.eu Il 27/08/2014 12:33, carbol...@openmailbox.org ha scritto: On 2014-08-26 21:52, Mark Bourne wrote: carbol...@openmailbox.org wrote: [...] I would like to get geocode by web service Google API, my macro works at home (without proxy) but not at work (through proxy). At work (Windows 7, LibO 4.0.5.2) , when I launch my macro, LibO freeze any seconds and replay Error 1: Une exception s'est produite : Type: com.sun.star.ucb.InteractiveNetworkConnectException Message: . (line : 194) [...] Not entirely sure if this will work, but try: [Snip the explanations I've followed letter by letter] - Now try accessing the web service from LibreOffice. Doesn't work :-( Another possibility is that the service is blocked by your proxy. Are you able to access it from work through any other means to test? e.g. another application, by manually connecting to it (if you know what you're doing and it uses a plain-text protocol, you can connect a telnet session via telnet address port from a command prompt, and then type the requests and see if you get a response back). I would like to use a Google geocoding service. It works with my/your favorite browser (through proxy): http://maps.googleapis.com/maps/api/geocode/xml?sensor=trueaddress=grand\%27place+Brussels+Belgium return a xml including location coordinates. My webbrowser ask me the proxy's login/passwd. It works with wget through proxy (Cygwin installed, .wgetrc configured with proxy's login/passwd). To use the google service with LibO, I have found the following webpage: http://www.tuicool.com/articles/IN7zEb. It works on a connection without proxy but not trough proxy. I've tried the following macro in LibO (simplier) - same result: works without proxy, not with proxy! Sub Macro1 open http://www.google.com; for input as #1 line input #1, texte close #1 print texte End Sub LibO want not to pass trough proxy! Does it exist an another way to use webservices into LibO (pluggin, or something like that ?) It may be worth asking your IT department what you might need to do to get through their proxy; the rest of us can only guess at how it might be configured. Some are more aggressive than others in blocking certain types of traffic. I'll see with him. Thanx you very much for your help. We keep in touch. Mark. Bruno. -- To unsubscribe e-mail to: users+unsubscr...@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: disable cntrl click to follow link
From: Mark Bourne [via Document Foundation Mail Archive] Sent: Tuesday, August 26, 2014 5:04 PM To: 4130 Subject: Re: disable cntrl click to follow link 4130 wrote: Dave, Thanks for the solution the image to my cntrlclick problem. Never thought it would be a security issue. I think the security issue is that hyperlinks can be formatted to look like normal text. Usually in a word processor you click to position the cursor where you want to edit text. Someone could send you a document, and when you click on that text (intending to position the cursor for editing it) you end up opening a web page instead - which may exploit a vulnerability in your web browser to install malware. With some vulnerabilities, you need only to open a web page designed to exploit it; you don't even need accept and run a download, or even realise that anything has happened. e.g. the first item under Mitigating Factors at https://technet.microsoft.com/library/security/MS14-037 (about half way down the page). Even if they're not being malicious, it's somewhat frustrating to click on a bit of text and suddenly find some web page being opened when all you wanted to do was edit the text. Mark. -- To unsubscribe e-mail to: [hidden email] 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 If you reply to this email, your message will be added to the discussion below: http://nabble.documentfoundation.org/disable-cntrl-click-to-follow-link-tp4120195p4120381.html To unsubscribe from disable cntrl click to follow link, click here. NAML -- View this message in context: http://nabble.documentfoundation.org/disable-cntrl-click-to-follow-link-tp4120195p4120441.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: disable cntrl click to follow link
Hi, Thanks to all who helped me with cntrl/click and an explanation of the security question. cheers, 4130 --__o _`\,_ ---(_)/ (_) * * * * * * * * -- View this message in context: http://nabble.documentfoundation.org/disable-cntrl-click-to-follow-link-tp4120195p4120439.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: LO Writer (Linux): Way to do text search in set of documents?
On Wed, 27 Aug 2014 13:23:23 +0200, Cley Faye wrote: it might be possible to achieve this through a macro inside LibreOffice. That sounds interesting!. Actually, many years ago I was using a word processor which (like some assembler languages) accepted an 'include file' control. Ideally I would have a master file just containing, e.g. %include filename-A %include filename-B etc... - which I would then give to Writer, which would then pull in the contents of those files to produce the composite document I need. -- /\/\aurice -- To unsubscribe e-mail to: users+unsubscr...@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: LO Writer (Linux): Way to do text search in set of documents?
Hi :) I guess that would be another way of doing it. A bit of a shame after there have been so many different coding ways of doing it! Chapter 13 Working with Master Documents might help! https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Writer_Guide Regards from Tom :) On 27 August 2014 13:46, Maurice maur...@bcs.org.uk wrote: On Wed, 27 Aug 2014 13:23:23 +0200, Cley Faye wrote: it might be possible to achieve this through a macro inside LibreOffice. That sounds interesting!. Actually, many years ago I was using a word processor which (like some assembler languages) accepted an 'include file' control. Ideally I would have a master file just containing, e.g. %include filename-A %include filename-B etc... - which I would then give to Writer, which would then pull in the contents of those files to produce the composite document I need. -- /\/\aurice -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Link in calc
Hi :) I think just typing =A2 into cell B4 would do the job? B4 wouldn't be clickable but if you double-click on it then it would highlight A2 to show the source. I'm not sure how to do both things at the same time unless you do the whole thing in html. An html table might be a better idea for this but even that would be quite messy. Apols and regards from Tom :) On 24 August 2014 19:51, Rob Jasper r...@famjasper.nl wrote: Hi, I have a list of names, for which I want to reference AND link to other names. Think about: — A B C 1 NameParent1 Parent2 2 John 3 Eve 4 Chris JohnEve --- Where the parent is both to link the value and a hyperlink to the respective cell. So B4 should be both #A2 as =A2. Can this be done? The hyperlink screen does not seem to allow a formula i.s.o. text... Best, Rob. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] Image mapping doesn't work in Impress
Hi :) Hmmm, if the link does not work on your local machine then i'm not sure what to suggest. Is the link supposed to be to a photo (or other image) or is it meant to be to the whole document? I mean is that link the one that is inside your document? To use Nabble you do have to register first. After that you can use Nabble to post replies to any message that you also get by email. It's a duplication but Does mean you have 2 tools that look at the same thing. Each tool has it's own advantage. Nabble's advantage is that it lets you add files and images to the posts. Email blocks attachments. Regards from Tom :) On 27 August 2014 16:09, Csányi Pál csanyi...@gmail.com wrote: 2014-08-27 16:34 GMT+02:00 Tom Davies tomc...@gmail.com: Hi :) I have no idea about this sort of thing. The url given only works on the local machine. The problem is that that it doesn't work even on my local machine. You might want to use some file-sharing service such as drop-box or something. So, the image mapping can one uses only with http URL's? Alternatively there is something very neat in Nabble that lets you upload files and also injects the http-type url link into the message for you so you don't have to worry about that. Are you talking about https://www.libreoffice.org/get-help/nabble/ ? This website doesn't work here. I can see only the following text: Nabble Forums This is the Nabble interface to our Users Support Mailing List. Nabble provides a forum like interface to discussions happening on mailing list. Register and browse Nabble below. Bellow this text is a circle with Loading... text, but nothing happen. I think I can't use the Nabble Forum. -- Regards from Pal -- To unsubscribe e-mail to: users+unsubscr...@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] Image mapping doesn't work in Impress
Hi Tom, :) 2014-08-27 17:37 GMT+02:00 Tom Davies tomc...@gmail.com: Hi :) Hmmm, if the link does not work on your local machine then i'm not sure what to suggest. Is the link supposed to be to a photo (or other image) or is it meant to be to the whole document? I mean is that link the one that is inside your document? The link is supposed to be to a Slide in the same document of the presentation. To use Nabble you do have to register first. As I sed before in this thread, on the website: https://www.libreoffice.org/get-help/nabble/ I just can't even register, because the web site doesn't work here. I can see only the Loading... image forever.. -- Regards from Pal -- To unsubscribe e-mail to: users+unsubscr...@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] Link in calc
Tom, Thanks for your reply. This works in MS Excel. Just insert hyperlink enter A2 as the cell, and =A2 in the text. Anyway, if one inserts lines, the link is not updated, so this makes the whole thing quite unworkable... I would expect this to be 'automagically' update, much like formula references. Is this a bug, or is this for some reason 'per design'? Rob. PS. Excel doesn't update the link either, but it does update the formula ref. . Op 27 aug. 2014, om 17:30 heeft Tom Davies het volgende geschreven: Hi :) I think just typing =A2 into cell B4 would do the job? B4 wouldn't be clickable but if you double-click on it then it would highlight A2 to show the source. I'm not sure how to do both things at the same time unless you do the whole thing in html. An html table might be a better idea for this but even that would be quite messy. Apols and regards from Tom :) On 24 August 2014 19:51, Rob Jasper r...@famjasper.nl wrote: Hi, I have a list of names, for which I want to reference AND link to other names. Think about: — A B C 1 NameParent1 Parent2 2 John 3 Eve 4 Chris JohnEve --- Where the parent is both to link the value and a hyperlink to the respective cell. So B4 should be both #A2 as =A2. Can this be done? The hyperlink screen does not seem to allow a formula i.s.o. text... Best, Rob. -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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