Apache OpenOffice (AOO) Bugzilla – Issue 85577
xhtml export dont generate hyperlinks made using Hyperlink() -function
Last modified: 2013-08-07 15:13:10 UTC
I am creating dynamic hyperlinks using Hyperlink() -function in my spreedsheet. Created hyperlinks works fine in spreedsheet and in exported PDF document, but in exported XHTML file these hyperlinks are not working. In the XHTML-file those are not at all as HTML <a href...> -tags.
In no way a P1 Issue. lowered to a more appropriate level aof three
Hi Swante, please have a look at this one. Frank
I confirm, using OOo 2.4 (Linux). Very disappointing.
Almost the same as issue #61032: http://qa.openoffice.org/issues/show_bug.cgi?id=61032
The reason for no HTML link output is that the cell itself does only contain a paragraph, but not a link. In ODF it looks like: <table:table-cell table:formula="oooc:=HYPERLINK("http://www.openoffice.org")" office:value-type="string" office:string-value="http://www.openoffice.org"> <text:p>http://www.openoffice.org</text:p> </table:table-cell> Whenever a certain table:formula exists, the content have to be moved into a link. I have other tasks with higher prio, is anyone able to take this one over?
i can fix i guess it is good to convert to links *all* content that have prefix http:// regrdless how it constructed - string concatenation or hyperlink or we really need link only in case with related hyperlink function?
A different opportunity to fix this issue (at least on the long term) is that Calc would write out not only the paragraph, but as well the link. I therefore added Niklas on CC...
but wait - look like here error not in export filter but in schema for example - HYPERLINK function can have second parameter - text to display, it suppress URL if present and look like in this case our URL in content.xml exist only in @table:formula - it can be parsed if it plain string but what if this parameter calculated (rarely case but still possible)? Should XSLT perform this calculation? <table:table-cell table:formula="oooc:=HYPERLINK("http://adobe.com";"PDF father")" office:value-type="string" office:string-value="PDF father"><text:p>PDF father</text:p></table:table-cell> I guess it can be solved by using @office:value & @office:string-value at same time for cells with URL - @value for URL since it more important in our case and @string-value for URL title (but i did not check is it valid or not for current schema) also i think that OO really lack data type "XML"