Download it now!
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)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: low minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 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: 2019-11-18 08:29 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


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

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: 4.2.7.0.0+
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
Confirmed:
Windows 7
LibreOffice 4.2.5.2 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 5.1.3.2 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
 5.3.1.2
Kubntu 17.04 
the bug is here
Comment 11 Thomas Lendo 2017-09-04 21:01:18 UTC
Still repro.

Version: 6.0.0.0.alpha0+
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 5.3.6.1 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: 6.1.1.1
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
Still
Version: 6.4.0.0.alpha0+ (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 6.3.3.2(64).

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.