[Libreoffice-bugs] [Bug 113840] New: [Spreadsheet FORMATTING] Can not remove automatic hyperlinks

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113840

            Bug ID: 113840
           Summary: [Spreadsheet FORMATTING] Can not remove automatic
                    hyperlinks
           Product: LibreOffice
           Version: 6.0.0.0.alpha0+
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jim.avera at gmail.com

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 "homer at example.com<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 at 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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171114/7edd17bb/attachment-0001.html>