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 157142 158700 (view as bug list)
Depends on:
Blocks: Calc-UX Calc-Formula-Bar Multi-Window
  Show dependency treegraph
Reported: 2014-07-22 08:08 UTC by werru
Modified: 2023-12-14 17:55 UTC (History)
8 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. ***
Comment 16 QA Administrators 2019-10-29 03:29:34 UTC Comment hidden (obsolete)
Comment 17 m_a_riosv 2019-10-29 07:43:01 UTC
Version: (x64)
Build ID: 758516295e5f69393bd78bb4af6e7214d48ece0b
CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc:
Comment 18 Martin Schoenmakers 2019-11-18 08:29:44 UTC
Same problem here in Win10 + LibreOffice

It is very inconvenient, I need to compare sheets and formulas, and only one formula is shown.

Note1: this is only the case when there are two or more Calc windows. Losing the focus to another program does not lose the visibility of the inputline. Maybe, does this have to do with "only one instance" of Calc? 

Note2: In Excel this is not the case: cell contents remain visible between two spreadsheets next to each other.

Maybe related, also very inconvenient:
When several cells are selected, the main selected cell is visible, and the selection is shown in the Name Box. But with more Calc windows open, without focus on the window, the selected cell is no more visible. 
And the Name Box also gets to be empty.
Comment 19 QA Administrators 2023-05-18 03:18:51 UTC Comment hidden (obsolete)
Comment 20 mahfiaz 2023-05-18 11:19:24 UTC
Still happens in on Windows 10.
Comment 21 m_a_riosv 2023-05-18 11:25:39 UTC
Version: (X86_64) / LibreOffice Community
Build ID: b3c88dc039d447322b8c8c564ab6e2f0ce9c5b90
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 22 Heiko Tietze 2023-09-08 07:34:51 UTC
*** Bug 157142 has been marked as a duplicate of this bug. ***
Comment 23 DErik 2023-09-08 15:58:51 UTC
Still happens in latest version (7.5+). And is not restricted to two windows of Calc. A refocus to Writer will also wipe out the formula bar - of the latest Calc window, which has already wiped out the formula bar of any other Calc window. Try it with three or more Calc windows - they all lose the info. THIS IS BAD IMPLEMENTATION. I had submitted a similar bug report just yesterday and got the response it was because focus for an os/DE edit (whatever that is) could only be on one field. True that input should only be accepted from one field at a time, but no excuses for this type of behavior. FIX IT.
Comment 24 m_a_riosv 2023-09-08 17:51:16 UTC
(In reply to DErik from comment #23)
>... FIX IT.
You can place yourself at your own orders and fix it.
Comment 25 DErik 2023-09-08 20:57:06 UTC
Sorry if I came off a bit too strong. But take a look at the response I got on my initial bug report (https://bugs.documentfoundation.org/show_bug.cgi?id=157142). I didn't understand that explanation, not sure it is correct either, and it sounded like you weren't going to do anything about it. But it does need fixing. I'd do it myself, but I am not familiar enough with your code and implementation methods. I'm not on your development staff. And I would really appreciate it if it was fixed.
Comment 27 m_a_riosv 2023-12-14 16:25:54 UTC
*** Bug 158700 has been marked as a duplicate of this bug. ***
Comment 28 ady 2023-12-14 17:55:52 UTC
If you want to enter into (cell's) edit mode in the second file, you need to exit edit mode from the first file before that (e.g press [ESC], or [ENTER], depending on the result you want in the first file).

I doubt there is some realistic solution, as Calc is not capable of preemptively knowing whether:
* you want to relate the first file to the second one, or instead,
* you want to abort the first edit mode and enter into edit mode in the second file.

See duplicate bug 158700 comment 2 for short example.