OpenOffice-OODoc - How to Access Hyperlinks in Cells in Spreadsheets

Posted on Sun Oct 16 00:19:26 2005 by cilynx
How to Access Hyperlinks in Cells in Spreadsheets
I have a bunch of spreadsheets that include links to websites in some of the cells. I need access to this content.

$doc->getCellValue($cell)
Wraps the visible string in <<>> if it is a hyperlink, but gives no hint of the link content.

$doc->cellValueType($cell)
Returns 'string' even when the cell holds a hyperlink

getAttributes() didn't return any keys that looked useful either.

Is there some way that I haven't thought of to access the link content?

Thanks --
Direct Responses: 1189 | Write a response