Kathrin Newbie

Joined: 18 Oct 2010 Posts: 1
|
Posted: Fri Oct 22, 2010 5:34 am Post subject: [Calc] Hyperlinks and Conditional Formats |
|
|
Hello,
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:
| Code: |
doc = thisComponent
oLink = doc.createInstance("com.sun.star.text.TextField.URL")
oLink.URL = baseURL + item.id + "-CL"
oLink.Representation = item.iName
cell.insertTextContent(cell.getText().createTextCursor(),oLink,true)
|
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,
Kathrin |
|