Joined: 18 Oct 2010
|Posted: Fri Oct 22, 2010 5:34 am Post subject: [Calc] Hyperlinks and Conditional Formats
I have problems using hyperlinks in calc cells.
I have a cell that contains a string and uses a conditional format. Now, I want to use a hyperlink instead of a simple string value but (and that's the problem) without changing the visual appearance.
What I have for now is:
doc = thisComponent
oLink = doc.createInstance("com.sun.star.text.TextField.URL")
oLink.URL = baseURL + item.id + "-CL"
oLink.Representation = item.iName
The inserted link works fine, but it really looks ugly and it ignores my conditional format.
So, how can I achieve a sort of invisible hyperlink?
Thanks in advance,