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...
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
sorry may be I misstook with category of the bug This bug in Libreoffce calc formula
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
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.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.0.5 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-09-03
Created attachment 118405 [details] formula editing in two documents
*** Bug 94520 has been marked as a duplicate of this bug. ***
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?
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.4.1 or 5.3.6 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170901
5.3.1.2 Kubntu 17.04 the bug is here
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
Behavior still exists on version 5.3.6.1 for Windows 32-bit.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still Version: 6.1.1.1
*** Bug 61202 has been marked as a duplicate of this bug. ***
Dear werru, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
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:
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.
Dear werru, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still happens in 7.5.2.2 on Windows 10.
Still Version: 7.6.0.0.alpha1+ (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
*** Bug 157142 has been marked as a duplicate of this bug. ***
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.
(In reply to DErik from comment #23) >... FIX IT. You can place yourself at your own orders and fix it.
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.
(In reply to DErik from comment #25) > ... https://www.libreoffice.org/community/developers/ https://www.libreoffice.org/about-us/who-are-we/
*** Bug 158700 has been marked as a duplicate of this bug. ***
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.
Code pointer of the place that explicitly clears the formula and address upon deactivation, *in addition* to the correct disabling of the controls: https://opengrok.libreoffice.org/xref/core/sc/source/ui/app/inputhdl.cxx?r=621caf93&mo=157018&fi=4480#4480 It was this way since the initial import. There is a special case, when it is skipped altogether ("Keep formula e.g. for help"). Note how e.g. font name / size controls don't clear on window deactivation, and somehow avoid destroying the world ;)