<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - [Spreadsheet FORMATTING] Can not remove automatic hyperlinks"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113840">113840</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>[Spreadsheet FORMATTING] Can not remove automatic hyperlinks
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.0.0.alpha0+
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>jim.avera@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
If an email address or other hyperlink is auto-detected in text in a
spreadsheet cell, there does not seem to be any documented way to change it
back to plain text. The docs say "...LibreOffice formats the hyperlink with
direct font attributes (color and underline) the properties of which are
obtained from certain Character Styles."
1) Those "direct font attributes" are not removed by selecting the text and
doing Format->Clear Direct Formatting. What is a "direct font attribute"
which is not "Direct Formatting"?
2) The docs also say you can "open the context menu and choose Remove
Hyperlink."
but there is no "Remove Hyperlink" item in the context (right-click) menu when
an auto-hyperlink is selected in a spreadsheet cell. This does work in a text
document, however.
Steps to Reproduce:
1. Tools->Autocorrect Options->(Options tab)->URL Recognition checked
2. File->New->Spreadsheet
3. Click in a cell; type "<a href="mailto:homer@example.com">homer@example.com</a><ENTER>"
4. Select the cell, or select the text inside the cell
5. Format->Clear Direct Formatting
6. right-click to see context menu
Actual Results:
Clear Direct Formatting does nothting, and there is no
"Remove Hyperlink" item in the context menu.
Expected Results:
Format->Clear Direct Formatting should clear the "direct font attributes"
mentioned in the docs (or if the docs are incorrect then they should be fixed);
and the documented "Remove Hyperlink" context menu should be present when the
auto-hyperlink is selected.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.0.0.0.alpha0+
Build ID: cfbb8b5090537e79ba70e250ddee86d53facbe15
CPU threads: 8; OS: Linux 4.10; UI render: default; VCL: gtk2;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2017-10-18_22:54:20
Locale: en-US (en_US.UTF-8); Calc: group
User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/62.0.3202.89 Safari/537.36</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>