1. Create/open a calc document.
2. Make sure the Formula Bar is visible.
3. Slowly move the mouse cursor up from the spreadsheet over the Formula Bar to the icons above the formula bar.
4. When the mouse cursor reaches the middle/top of the formula bar, it jumps down to the spreadsheet again.
- The mouse moves up just fine when moved *around* the Formula Bar (i.e. outside the LibreOffice window.)
- Moving the mouse quickly often allows it to jump over the Formula Bar.
- Hiding and re-showing the Formula Bar seems to cure the problem. I was able to reproduce the problem 100% with LibreOffice 188.8.131.52 on Mac OS X 10.0.4 before hiding and un-hiding the Formula Bar. Afterwards, the problem went away and I am having a hard time reproducing it.
To clarify - you can't reproduce it at all with a new calc document any longer? If so the best thing we can do is close this bug as WFM. Our volunteers time is really stretched thin and spending time trying to reproduce a bug that the original reporter cannot even reproduce is just not a wise use of time.
Marking as NEEDINFO - please let us know if you can reproduce the issue still with a new calc document then mark as UNCONFIRMED. Thanks!
I can reproduce it, but it is no longer very visible, just a slight flicker while the mouse cursor travels upwards.
My best guess is that by hiding and unhiding the Formula Bar, some internal setting was reset to a sane value, making the problem almost invisible.
The original phenomenon was really bad behavior, but since there is a work-around, I think it is just a minor annoyance. Maybe this is simply something to document?
No repro on
Build ID: 9136f2344af88d524b6c10b6b2dfd6017bba60ec
Locale: fr-FR (fr.UTF-8)
@Emil : as you are the only person to apparently have suffered from this, and you now can't reproduce it, or at best, to an almost imperceptible extent, I am setting this to WFM.
The majority of users do not slowly move their mouse cursor from the spreadsheet through the formula editor to the toolbar above, and as we have tons more bugs that are reproducible and in need of attention on OSX, I would be inclined to let this one go.
(In reply to Alex Thurgood from comment #4)
> […] and as we have tons more bugs that are reproducible and in need of
> attention on OSX, I would be inclined to let this one go.
That reasoning is dangerous. Just because you consider some bug unimportant should not be the lone reason to close a report. We do not revolve around one user’s wishes. LibreOffice is developed by volunteers who decide where to put their effort and spend their time.
I've just had the same weird glitch. Came across this report while looking for a fix. Hiding-then-unhiding the formula bar resolved it.
Version 5.222. Under Win7. Works with any file, not just a newly created Calc workbook.
To repeat the bug:
(If you've changed the default bevahiour, make sure the formula entry field is in single line mode, not multi-line.)
On the Formula Bar, place the mouse pointer on any of the Wizard, Sum, or Function (=) buttons, move the mouse pointer down until the pointer icon changes from a normal arrow-pointer to the frame-drag double arrow.
Left-click while the mouse pointer is displaying the frame-drag icon, but the wizard, sum, or function button is still highlighted.
Now try to move the mouse pointer up. Flick, flick, flick.
To activate the bug, the button must trigger. If the mouse is on the border-area but too far below the button, clicking does nothing. Hence, the bug won't trigger on the formula entry field, the cell-name and drop-down, nor the Expand Formula Area button. Those have just enough separation between them and the border-area. And of course you can't trigger the bug when the formula entry field is in multi-line mode.
Therefore I suspect the bug is triggered by some overlap between the button-area mouse-detection and the border-area mouse-detection.
*** Bug 106115 has been marked as a duplicate of this bug. ***
*** Bug 102306 has been marked as a duplicate of this bug. ***
I've been able to reproduce this bug using Paul451's steps. Clicking below the input area where the double arrow to drag appears also fixes the problem.
184.108.40.206 (x64) under Windows 7.
Repro with steps from comment 6 in 3.6. Version 3.3 did not yet have the resize ability.
Arch Linux 64-bit
Version 220.127.116.11 (Build ID: e183d5b)
One of my users runs into this bug all the time and is quite frustrated by it. My workaround has been to manually resize the formula bar by dragging a spot that isn't over a button. When it's resized back to its normal size, the behavior is fixed.
After a bit of experimentation, another workaround is to place the cursor over one of the buttons, hold left-click and then right click.
While I agree that this is easy to work around once you understand the behavior, it's quite frustrating and very easy to accidentally trigger. On my system, the section that overlaps both a button click action and the resize action is 3px tall. With the button itself only being ~20px tall, that's a good chunk.
The other elements in the formula bar appear to handle this behavior properly and override the resize action with their own.
I can confirm this bug, on Debian Jessie, with 4.3.3
** 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!
I have seen this behaviour before (#102306), but I can not reproduce this on 18.104.22.168 anymore. I have switched to Linux Mint with Mate desktop, maybe this, maybe it really is fixed.
Please reopen this if it is still a problem with a recent version.
Hmm it is true that I cannot repro.
Version: 22.214.171.124.alpha0+ (x64)
Build ID: de6b0c6edce0b9237fa43d12e258bf5fa568f6a7
CPU threads: 4; OS: Windows 10.0; UI render: default;
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-07-16_05:06:14
Locale: fi-FI (fi_FI); Calc: group threaded
You can click on the formula bar to edit information within a cell, ... this popular guide shows beginners how to get up and running with Excel
If anyone searching jobs visit here https://careerjobs360.in/
I can reproduce it on Debian:
(In reply to mmavovaforlists from comment #18)
> I can reproduce it on Debian:
You are using 126.96.36.199.
Please rather try with a fresh version, preferably with 6.3 beta: https://libreoffice.soluzioniopen.com/
Created attachment 172529 [details]
Large formula bar and mouse jump towards bottom right
When trying to resize the formula bar, I can enlarge it but cannot reduce it again. When trying to reduce it the mouse cursor jumps toward the bottom right corner of the screen and I am stuck with a giant formula bar (see screenshot in above comment).
I've tried on two different laptops, both with touchpad and with external mouse.
Version: 188.8.131.52 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Ubuntu package version: 1:7.1.3~rc2-0ubuntu0.20.04.1~lo1
Operating System: KDE neon 5.21
KDE Plasma Version: 5.21.5
KDE Frameworks Version: 5.82.0
Qt Version: 5.15.2
Kernel Version: 5.11.8-051108-generic
OS Type: 64-bit
Graphics Platform: X11
Processors: 8 × Intel® Core™ i5-8350U CPU @ 1.70GHz
Memory: 15.4 GiB of RAM
Graphics Processor: Mesa Intel® UHD Graphics 620
Happy to file a new bug if this is too different.