Hyperlinks: use concatenation to define a url

[pedro]

Dear happy NeoOffice/J users

I have happily discarded Microsoft Office and I am now using the entire Neooffice app to do my common work. It works fine although a bit slow. It is not a big problem, since after a while when all the app is in cache the soft runs quite smothly. (ibook 700MHz, 380 MB ram)
I have a question for the experts.
I need to add hyperlinks into cells of the CALC app. Although to add then is no problem, we can not edit then to for instance include into the URL link a information refered in a particular cell. If we do it for instance by concatenation of two cells, the URL text is not recognized as a hyperlink but only as text. How can I automate the procedure? Some clues, ideas?

Thanks a lot,

PM