<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 - Cell highlighting does not work sporadically"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117979">117979</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Cell highlighting does not work sporadically
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.7.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>kaigue7@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
1. Work on a spreadsheet for some time, create multiple additional sub-sheets
2. Double click formulas referring to some sub-sheets and go to the source
3. Cell highlighting does not work, need to manually look for row/column to
find the source
This has happened to me every since I've been using LO from 5.3.7 onwards
(including all version in between). I've tried multiple distributions, OpenSuse
Leap 42.3, 15, Tumbleweed and Fedora 27 which their official build of LO and
all show the same error in my .ods file.
I have around 10 sheets within my spreadsheet. In most cases cell higlighting
works fine, but there are 2-3 sheets where it doesn't work at all. So whenever
I try to refer to that sub-sheet, cells won't be highlighted.
I assume it has something to do with copy-pasting formulas to a new sheet or
the way the sheet is created. Maybe a broken sub-sheet?
Steps to Reproduce:
1. Work on a spreadsheet for some time, create multiple additional sub-sheets
2. Double click formulas referring to some sub-sheets and go to the source
3. Cell highlighting does not work, need to manually look for row/column to
find the source
Seems only to happen after working with a sheet for some time as it grows.
Actual Results:
The cell does not get highlighted (with a colored frame)
Expected Results:
Cell highlight works in every sub-sheet.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
OpenGL is disabled. Cannot enable OpenGL anyway because it introduces even
worse bugs/weird behavior in LO's UI.
This bug has been reported many time, e.g.
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED WORKSFORME - Active cell not highlighted / bordered when OpenGL is disabled"
href="show_bug.cgi?id=99705">https://bugs.documentfoundation.org/show_bug.cgi?id=99705</a> and seems date back
quite some time.
I must say it's still there and it's very annoying.
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
Firefox/60.0</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>