<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <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#c6">Comment # 6</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 <a class="email" href="mailto:mikekaganski@hotmail.com" title="Mike Kaganski <mikekaganski@hotmail.com>"> Mike Kaganski</a> <pre>In Calc, the "hyperlink" cell style is intended for the cases where Calc does *not* apply the hyperlink formatting automatically: e.g., for a column of formulas like '=HYPERLINK("www.example.org?q="&A1)'. Setting that column to that style helps the formatting, and is perfectly logical. But for automatically applied text run formatting, the colors are taken from Options->LibreOffice->Application Colors (Unvisited/Visited links). I don't know if there's a way to define the other properties of hyperlink text - but I don't expect spreadsheet to provide too flexible ways to format parts of cells, which is anyway only possible manually on per-cell basis, while in all other aspects, spreadsheet documents are about bulk operations involving same formulas, formatting, etc in thousands of cells... (But yes, if this is out of user control at least in some way, like the formatting applied automatically, it's not good.) Actually I would love to see "Application Colors" to transform into "Application Formatting", with each element presenting not only color, but also other applicable properties, e.g. font and background. Then defining the look and feel of an auto-applied hyperlink formatting could be done in a single place. (But it's an off-topic, I realize.)</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>