Bug Hunting Session
Bug 81636 - Not possible to view two formulas at the same time in different Calc instances
Summary: Not possible to view two formulas at the same time in different Calc instances
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
: 61202 94520 (view as bug list)
Depends on:
Blocks: Calc-UX Calc-Formula-Bar
  Show dependency treegraph
Reported: 2014-07-22 08:08 UTC by werru
Modified: 2018-10-28 23:07 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:

screencopy under Ubuntu / Unity (469.61 KB, image/png)
2014-07-22 10:52 UTC, Jean-Baptiste Faure
formula editing in two documents (42.62 KB, image/png)
2015-09-04 06:25 UTC, werru

Note You need to log in before you can comment on or make changes to this bug.
Description werru 2014-07-22 08:08:27 UTC
I have Kubuntu 14.04. May be problem in it
Two open sheets in different windows if I make visible some formula in document №1 and after focused in another window with document №2 formula disappear in unfocused document. It makes me develop me memory but...
Comment 1 Jean-Baptiste Faure 2014-07-22 10:52:08 UTC
Created attachment 103275 [details]
screencopy under Ubuntu / Unity

Not reproducible for me with Version:
Build ID: f5949d09321e3ac62538df0e70e58284bd1cab32 build at home under Ubuntu 14.04 x86-64.

On the attached screenshot you can see two formulas in edit mode in two separate documents.

Best regards. JBF
Comment 2 werru 2014-07-22 11:48:30 UTC
sorry may be I misstook with category of the bug
This bug in Libreoffce calc formula
Comment 3 Joel Madero 2014-07-23 02:07:44 UTC
Windows 7
LibreOffice release

Steps to Reproduce:
1. Open two instances of spreadsheet - arrange them so both are visible
2. In one document type 1+1 in A1 formula bar and push enter
3. Highlight A1

Observed: You see 1+1 in Document1 formula bar

4. Select A1 in Document 2

Observed: The formula bar in Document 1 now shows empty

Expected: Formula bar in Document 1 is unchanged by selecting Document 2
Comment 4 m.a.riosv 2014-07-23 20:23:16 UTC
I'm not sure this is a bug, I think a limitation to only one edit at once.

Maybe not so easy to implement, if it could be achieved I would be happy, it's really annoying. At least if was possible, one editable, and the others with the formula/value visible.
Comment 5 QA Administrators 2015-09-04 02:48:40 UTC Comment hidden (obsolete)
Comment 6 werru 2015-09-04 06:25:22 UTC
Created attachment 118405 [details]
formula editing in two documents
Comment 7 Aron Budea 2016-06-19 02:57:47 UTC
*** Bug 94520 has been marked as a duplicate of this bug. ***
Comment 8 Alex 2016-06-20 07:13:17 UTC
The behavior still exists on CALC version running on Kubuntu 16.04, Linux 4.4.  Whenever there is more than one CALC window open, the location and formula fields are readable only on the one which has (or last had) the focus.  These two fields on all other open CALC windows will go blank.  Note that the fields don't go blank on a CALC window when focus merely leaves that window.  It's when focus shifts to another CALC window.  It seems unlikely to me that such a behavior would have been intentionally designed that way, so perhaps these two fields on all open CALC windows are controlled by a single process, which can only make them visible on one window at a time?
Comment 9 QA Administrators 2017-09-01 11:17:00 UTC Comment hidden (obsolete)
Comment 10 werru 2017-09-01 11:41:19 UTC
Kubntu 17.04 
the bug is here
Comment 11 Thomas Lendo 2017-09-04 21:01:18 UTC
Still repro.

Build ID: bfd8a4e22fe584939f67b64c9c9495a466b16576
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-08-21_00:52:56
Locale: de-DE (de_DE.UTF-8); Calc: group
Comment 12 Alex 2017-09-06 07:12:02 UTC
Behavior still exists on version for Windows 32-bit.
Comment 13 QA Administrators 2018-09-07 02:44:21 UTC Comment hidden (obsolete)
Comment 14 m.a.riosv 2018-09-07 08:45:32 UTC
Still Version:
Comment 15 Thomas Lendo 2018-10-28 23:07:09 UTC
*** Bug 61202 has been marked as a duplicate of this bug. ***