Bug 33951

Summary:	Calc: Comment text defined as hyperlink doesn't display on mouseover.
Product:	LibreOffice	Reporter:	Randy <rbpguard-bugzilla>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	aurimas, bfo.bugmail, c_strobbe-fdo
Version:	3.3.0 RC4
Hardware:	All
OS:	All
Whiteboard:	target:4.3.0
i915 platform:		i915 features:
Attachments:	example spreadsheet created in LibO Calc 4.1.0.4

Description Randy 2011-02-05 15:42:53 UTC

When creating a comment for a spreadsheet cell text in the comment that is defined as a hyperlink does not display in the comment box on mouseover.  To recreate the problem perform the following:

* Right-click and select Insert Comment.

* When the empty comment box is displayed for editing, choose Insert-Hyperlink from the main menu bar. 

* After the Hyperlink window is displayed, specify the Web Target URL, the text to be displayed as the comment, and then click Apply and Close to complete the new comment.

* Click on any other cell in the spreadsheet.

* Mouseover the commented cell to display the comment.

And here's the problem: the comment box is displayed but not the comment text; however, right-clicking and choosing Show Comment, successfully displays the comment text, which correctly functions as a hyperlink.  Note that if the comment contains both normal text and hyperlink text, the normal text displays just fine, but, as before, not the hyperlink text.

Comment 1 Katarina Behrens 2011-02-23 02:29:00 UTC

Taking this one

Comment 2 Christophe Strobbe 2011-08-12 06:17:57 UTC

I reproduced this issue in LibreOffice 3.3.1 (OOO330m19, build:8) on Windows XP, so it is not a Linux-only issue.

In addition to the comment box appearing empty on hover, the comment is also represented as a gap in the Navigator.

To reproduce the issue:
* Right-click on a cell and select "Insert comment".
* Paste a URL (e.g. http://www.example.com/) and press the spacebar after the URL, so the URL becomes a hyperlink.
* Press F5 to open the Navigator and expand the list "Comments": the comment with the hyperlink is not visible. (The issue is easier to spot when you have a few normal comments in cells before and after the cell with the hyperlink comment.)

Comment 3 Aurimas Fišeras 2012-04-08 09:59:27 UTC

Still a problem in 3.6. Also reproducible in 3.5.2 on Windows.

Comment 4 bfoman 2013-08-14 21:50:15 UTC

(In reply to comment #1)
> Taking this one

This bug has not been touched by its Assignee for a long time. To make it clearer which bugs should be fixed by someone else please take following action:
- If you are the Assignee, and you are actively working on the bug, please give it an update. 
- If you are the Assignee, and you do not plan to work on it in the near future,
please reassign it to the default assignee.

Comment 5 James 2013-08-15 09:27:45 UTC

Resetting assignee. Thinks thats an ok move after 2 years.

Randy: Could you provide an example document? That would make testing much easier and speed up the process of getting this fixed a lot.

Also can anybody confirm this bug is still persisting in LO 4.1.1.1? http://www.libreoffice.org/download/pre-releases/

Comment 6 Christophe Strobbe 2013-08-15 10:20:27 UTC

Created attachment 84094 [details]
example spreadsheet created in LibO Calc 4.1.0.4

I uploaded a test file in LibreOffice Calc 4.1.0.4. It contains three comments:
1. A comment containing only a link.
2. A comment containing normal text.
3. A comment containing a link followed by normal text.

The links are not visible, neither in the comments themselves, nor in the Navigator.

Comment 7 Randy 2013-08-15 12:21:33 UTC

Thanks for the example document, Christophe.  As you indicated, the problem persists in 4.1.0.4.

Comment 8 Commit Notification 2014-03-01 15:24:16 UTC

Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=63308b1e6c5fe3450783e589df8bd588fb4ceb3e

fix OOXML validation issue, related fdo#33951



The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
http://wiki.documentfoundation.org/Testing_Daily_Builds
Affected users are encouraged to test the fix and report feedback.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.