Download it now!
Bug 66503 - macOS: Formula bar can not be resized smaller when using secondary monitor
Summary: macOS: Formula bar can not be resized smaller when using secondary monitor
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Multimonitor Calc-Formula-Bar
  Show dependency treegraph
Reported: 2013-07-02 11:48 UTC by Tim Richardson
Modified: 2019-08-11 09:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Tim Richardson 2013-07-02 11:48:13 UTC
On OS X Mountain Lion on an external monitor, I can grab the bottom of the formula bar box to make it multiple lines. However, when I try to make it small again, it doesn't work.

1. Using the "splitter" icon, grab the bottom of the formula bar to make it a few lines high.

2. Using the "splitter" icon, grab the bottom of the formula bar.
But as soon as I try to move the bar upwards, the splitter icon jumps towards the bottom of the screen, a long way from the bar. Therefore the bar can not be pulled up.

Note that I can reproduce this only when I move the spreadsheet window to the secondary monitor. On my Macbook's built in monitor, it behaves properly.
When I move a misbehaving spreadsheet back to the laptop's monitor, I can resize the formula bar properly.
Comment 1 retired 2013-07-03 10:52:30 UTC

I can not confirm this behavior on OS X 10.8.4 LO with an external monitor. I can extend the formula bar and move it back upwards to go back to the original size.

Any other OS X users willing to test this?
Comment 2 retired 2013-07-03 10:52:52 UTC
Joren (ping)
Comment 3 Tim Richardson 2013-07-03 11:03:39 UTC
I just tried it again and was able to immediately reproduce it.
Is there some more information I could provide?

On Wed, Jul 3, 2013 at 8:52 PM, <> wrote:

>  James <> changed bug 66503<>
>  What Removed Added  CC
>  *Comment # 2 <> on bug
> 66503 <> from James<>
> *
> Joren (ping)
>  ------------------------------
> You are receiving this mail because:
>    - You reported the bug.
Comment 4 Jorendc 2013-07-05 07:42:23 UTC
Nice catch Tim!

I can confirm this behavior using Mac OSX 10.8.4 with LibreOffice RC.

What I did:

* Connect a second screen, that is an extension of my MacBook Pro 13" screen.
* Open LibreOffice RC
* Open Calc
* enlarge it on my MacBook screen

Behavior: dragging the formula bar works. Not fluently (with a bit of lag), but it works.

* Drag the Calc window to the extended screen
* Enlarge it

Behavior: dragging the formula bar is only possible to enlarge it. I have same behavior as Tim now: When I try to make it smaller again, my cursor jumps to the bottom of the screen.

Kind regards,
Comment 5 QA Administrators 2015-04-01 14:40:55 UTC Comment hidden (obsolete)
Comment 6 Tim Richardson 2016-01-27 00:12:30 UTC
This problem still exists. 
1) You need a macbook with an external monitor
It just reproduced it on 10.11.3
Open libreoffice, and start a sheet.
On the laptop, verify that the formula bar can be increased in height and decreased by click and drag

2) move the sheet to the external monitor
Increase the height of the toolbar. This works
Now grab it and try to push it up, to reduce the height of the formula bar. Instead, the lower boundary moves down, against the direction of movement, making the toolbar higher.
Comment 7 QA Administrators 2018-07-25 02:39:30 UTC Comment hidden (obsolete)
Comment 8 Tim Richardson 2018-07-25 07:38:34 UTC
this bug report is still exactly correct for
Comment 9 QA Administrators 2019-07-30 03:14:33 UTC Comment hidden (obsolete)
Comment 10 eisa01 2019-08-11 09:44:23 UTC
This is still present

Formula bar was not resizable on 3.3

Build ID: 54028dc503fc08eb12e287919d5e2850cff05b73
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-07-31_01:48:19
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded