<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Hyperlink colours cannot be changed by changing Hyperlink style"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134456#c9">Comment # 9</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Hyperlink colours cannot be changed by changing Hyperlink style"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=134456">bug 134456</a>
from <span class="vcard"><a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> <span class="fn">Mike Kaganski</span></a>
</span></b>
<pre>(In reply to Heiko Tietze from <a href="show_bug.cgi?id=134456#c7">comment #7</a>)
<span class="quote">> Sorry, but I don't get the point of cell formatting with hyperlink style.
> Sure, I can enter www.foo.bar and undo the auto formatting (links are shown
> in lighter blue without underlining) and apply the cell style.</span >
No it's not for this use case at all. The style is not for a random cell where
you put an URL, and artificially disable URL recognition. It's (as other styles
in Calc) for potentially huge ranges of cells with structured data (here:
formulas).
Imagine a spreadsheet with goods of this company; in column A, there's an ID;
then its name in B, price in C, and clickable URL in D. How would those URLs in
D be created? There are maybe tens of thousands of rows - would you type
"<a href="http://www.thisfictionalcompany.com/?id=1234">http://www.thisfictionalcompany.com/?id=1234</a>" by hand ten thousand times? No,
you will use a formula which would take the id from A, like this (in D2):
<span class="quote">> =HYPERLINK("<a href="http://www.thisfictionalcompany.com/?id">http://www.thisfictionalcompany.com/?id</a>=" & A2; "Click to see full description for " & B2)</span >
Try this formula yourself, and see how it creates a clickable cell ("Ctrl+Click
to go to ..."), which you can expand (copy to 1000s of rows) in usual Calc's
ways (e.g., auto-filling, etc) - but it doesn't get coloured as hyperlink!
Are you suggesting to apply direct formatting to those 1000s of cells? The
style is to select D, and apply the style. Is it wrong?</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>