https://bz.apache.org/ooo/show_bug.cgi?id=127860
Issue ID: 127860
Issue Type: DEFECT
Summary: Importing html Document table with multiple links in a
record-Can not format/edit afterwards in Calc without
losing links
Product: Calc
Version: 4.1.3
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: formatting
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 86491
--> https://bz.apache.org/ooo/attachment.cgi?id=86491&action=edit
A record line typical after import
I'm NOT sure if this should be a bug or a feature request/possible oversite.
Typical Input record:
<tr><td valign="top">Acrylia Reinforced Belt</td><td valign="top"><a
href="http://www.eqtraders.com/items/show_item.php?item=1564";>Acrylia
Boning</a>(2), <a
href="http://www.eqtraders.com/items/show_item.php?item=1731";>Belt Pattern</a>,
<a href="http://www.eqtraders.com/items/show_item.php?item=1335";>Flawless
Rockhopper Hide</a>, <a
href="http://www.eqtraders.com/items/show_item.php?item=1536";>Paeala Bark
Tannin</a><td valign="top"><a
href="http://www.eqtraders.com/items/show_item.php?item=1614";>Deluxe Sewing
Kit</a>, <a href="http://www.eqtraders.com/items/show_item.php?item=1733";>Large
Sewing Kit</a>, <a
href="http://www.eqtraders.com/items/show_item.php?item=1791";>Loom</a>, <a
href="http://www.eqtraders.com/items/show_item.php?item=5228";>Planar Sewing
Kit</a>, <a
href="http://www.eqtraders.com/items/show_item.php?item=5494";>Tanaan Loom</a>,
<a href="http://www.eqtraders.com/items/show_item.php?item=5896";>Coldain
Tanners Kit</a>, <a
href="http://www.eqtraders.com/items/show_item.php?item=7340";>Collapsible
Sewing Kit</a> </td><td valign="top">1</td><td></td><td
valign="top"><b>242</b></td></tr>
Calc will open and import the HTML file flawlessly and I will end up with a
table that looks like Picture-1. All links and text are correct and working.
The trouble as you can see is that grey background and nothing I can do with
cell formatting will change that. Font size, Underlining . etc. work fine. Also
if I edit one of those cells the hyperlinks poof after a RETURN.
I can find nothing in objects or any other accessible part of the document that
explains the GREY background and how the hyperlinks are connected or the reason
the links disappear on editing.
To summarize:
I love the way Calc will import a HTML with multiple links in a cell, whoever
worked on the import code did well there. But other then using
HYPERLINK("http://www.SomeLink";"SomeText";) for a single hyperlink in a cell, I
can find no way to access the data in a cell with multiple hyperlinks in it
even though the data is obviously there and working ( as long as it isn't
edited )
**************
There should be some way to edit a snippet of multiple links in a cells
contents. Especially to get rid of that ugly grey background. Or some function
or command to create multiple links in one cell.
**************
Non-Related Unsolicited Comment:
Calc/Base? can really use some work on dealing with hyperlinks. This has
bothered me for years. even if it was as simple as making this legal;
=HYPERLINK("http://www.SomeLink";"SomeText";),
HYPERLINK("http://www.SomeLink2";"SomeText2";),
HYPERLINK("http://www.SomeLink3";"SomeText3";)
or
=HYPERLINK("http://www.SomeLink";"SomeText","http://www.SomeLink2";"SomeText2";)
which seems kind of basic for a function like a nested if or some such ...but I
have never made work.
Again it works on a html import but no way to accomplish this while working in
Calc that I can find.
--
You are receiving this mail because:
You are the assignee for the issue.
