Re: Get URL from Hyperlink - Solved

[David Stuhr <da...@verizon.net.INVALID>]

Hello,

I figured out a very low tech solution ... save as an HTML file, a 
little editing and a file import. Done. Sometimes simpler is better and 
I know I will fully understand what I am dong. :-)

I would be more than happy to write up a cheat sheet of the steps in the 
procedure that I am yet to devise. (But I know I can do it.)

I want to thank the members of the group for the unpaid work that you 
do. I for one appreciate what each of you do. I look forward each day to 
the question/problems users present and the thoughtful attention you 
give to the issues raised. Keep up the good work.

I think in this day and age that a function that would get the URL from 
a Hyperlink in a spreadsheet cell would be entirely appropriate. Does 
the team/individual that maintains OpenOffice have a "suggestion" box?

David

On 8/18/2020 5:40 PM, David Stuhr wrote:
>
> Hello Brian,
>
> I had time today to copy the Basic macro code in the link provided 
> today into a test spreadsheet. I pasted the code between "Sub Main" 
> and "End Sub". I then saved the macro. When I attempted to compile the 
> macro I got the following error.
>
> BASIC syntax error.
> Function not allowed within a procedure.
>
> What am I doing wrong?
>
> David
>
> On 8/17/2020 9:12 AM, Brian Barker wrote:
>> At 08:18 17/08/2020 -0400, David Stuhr wrote:
>>> I have an OpenOffice spreadsheet that has over a thousand hyperlinks 
>>> to an external www website. The information in each hyperlinked cell 
>>> is the URL and descriptive text. From a search of the web it appears 
>>> that Excel has a "get URL" function but a search of OpenOffice help 
>>> did not return a similar function.
>>>
>>> Is there a method/way of getting the URL in a cell that contains a 
>>> hyperlink and putting it in another? I want to do this to identify 
>>> duplicate URL references.
>>
>> See
>> https://superuser.com/questions/315752/separating-text-and-links-from-a-hyperlink-in-openoffice 
>> - which includes a function CELL_URL() which appears to provide what 
>> you need.
>>
>> I trust this helps.
>>
>> Brian Barker
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
>> For additional commands, e-mail: users-help@openoffice.apache.org
>>

Re: Get URL from Hyperlink - Solved

[Brian Barker <b....@btinternet.com.INVALID>]

At 19:38 18/08/2020 -0400, David Stuhr wrote:
>I think in this day and age that a function that would get the URL 
>from a Hyperlink in a spreadsheet cell would be entirely 
>appropriate. Does the team/individual that maintains OpenOffice have 
>a "suggestion" box?

Yup. You can suggest enhancements at the same place as you report 
bugs: https://bz.apache.org/ooo/ . See also
https://wiki.openoffice.org/wiki/QA/HowToFileIssue .

Brian Barker 


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@openoffice.apache.org
For additional commands, e-mail: users-help@openoffice.apache.org