Bug 94520 - UI: Formula ToolBar fields go blank when focus leaves window
Summary: UI: Formula ToolBar fields go blank when focus leaves window
Status: RESOLVED DUPLICATE of bug 81636
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: x86 (IA32) Windows (All)
: medium minor
Assignee: Not Assigned
Keywords: regression
Depends on:
Reported: 2015-09-26 05:55 UTC by Alex
Modified: 2016-06-19 02:57 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Alex 2015-09-26 05:55:05 UTC
The Formula Toolbar fields for viewing/entering a cell's contents and viewing the cell's name or address go blank if focus is shifted from that window elsewhere.  This makes comparing the contents of these fields to anything else on the screen (e.g., another spreadsheet document) difficult.  I do not recall this behavior before version 5.
Comment 1 Jacques Guilleron 2015-09-26 06:56:32 UTC
Hi Alex,

I reproduce with
LO Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Locale : fr-FR (fr_FR)
LO Build ID: 6664859e1e8b3f8b7db8c931b8d0335510c20ce0
TinderBox: Win-x86@42, Branch:master, Time: 2015-05-16_03:16:31
Locale: es-ES (fr_FR)
but not with
LO Build ID: a22f674fd25a3b6f45bdebf25400ed2adff0ff99 Locale : fr_FR
& Windows 7 Home
Comment 2 raal 2015-10-07 06:21:47 UTC
Hello, I want to bibisect this but bug I don't know if I understand correctly the problem. I tested 5.0.2 and 4.0.0 and doesn't  see the difference. Please could you post a screenshot with error? Thank you
Comment 3 Alex 2015-10-07 07:44:56 UTC
I'm not sure that a screenshot would show anything except two blank fields.  What happens with version 5 but not version 4 is that when the focus leaves the Calc sheet window (to another window on the screen or to a different screen), the formula field and the cell location field in the formula toolbar go blank.  It may take a few seconds for this to happen.  Perhaps, and I'm just guessing here, it may have something to do with the user's mouse behavior.  In my case, the behavior is focus follows mouse, i.e, whichever window the mouse cursor is under gets the focus, although that window is not brought to the front unless it is clicked somewhere.  Another guess is that it might have something to do with a user's default color scheme.  Perhaps what's actually happening is that the text just changes color, and in my case happens to change to the same color as the background due to my color scheme. However, even if that's the case, I don't see why any change to those fields should happen just because focus shifts away from the window. What would be the point of that?   The result is that if you're trying to compare a formula (or cell content) on one sheet with that of a sheet in another window, you can't because whichever one is not in focus will go blank.
Comment 4 Jacques Guilleron 2015-10-07 11:09:38 UTC
Hi raal,

To reproduce:
In Calc A1, type something, (let's say 4).
Input line displays 4 and Name box A1.
Open Writer.
Line input and Name box in Calc are now empty.
Clic in Calc A1 and Line input and Name box display again their content.

In LO 4, when you left Calc to work somewhere else, contents of Line input and Name box were visible.
Comment 5 Aron Budea 2016-06-19 02:57:47 UTC
As far as I can see this is not a regression, and exists since LO 3.3. (was it really briefly working in some 4.4 versions? I only checked with, where it still occurred)
There's also a different bug report for the issue, bug 81636, so I'm closing this one.

*** This bug has been marked as a duplicate of bug 81636 ***