Bug 146927

Summary: Autofilter menu opens up and out of the monitor
Product: LibreOffice Reporter: DelphyM <dmladek+bugs>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED DUPLICATE    
Severity: minor CC: 79045_79045
Priority: medium    
Version: 7.2.5.2 release   
Hardware: All   
OS: macOS (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 104160    
Attachments: Screenshot of the misplaced autofilter menu
My display layout

Description DelphyM 2022-01-23 05:40:38 UTC 
Created attachment 177713 [details]
Screenshot of the misplaced autofilter menu

I have found a similar bug 123989, which has been resolved as not our bug :-(
So apologies if you think it is a duplicate.


I'm running the latest stable version on macOS Mojave with 3 displays:
(If using just one build in display, all is fine)
Version: 7.2.5.2 / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 16; OS: Mac OS X 10.14.6; UI render: default; VCL: osx
Locale: en-NZ (en_NZ.UTF-8); UI: en-US
Calc: threaded

Reproduction:
1) Open/create a spreadsheet with a column which would have a large variation of data in it.
2) Then create auto filters
3) Then click on a small dropdown icon on the filter

Actual Results:
- it opens a popup menu, but for a strange reason it place that menu above the filter, crossing the boundaries if the Calc window itself, and either is hidden (if the monitor doesn't have another on top of it), or is displayed on the other screen.
- it looks like it only determines the size and position on the main display (which has a menu bar). If window is placed on the main display and is close enough to the bar, then the menu is placed correctly.

Expected results:
- the Calc window is aware of Display Arrangement in macOS
- the Calc window is also aware of its location on a display and knows its dimension and position on the display of itself.
- and can calculate correctly if there is enough space underneath to be placed bellow.
Comment 1 DelphyM 2022-01-23 05:42:38 UTC 
Created attachment 177714 [details]
My display layout

attaching my display arrangement
Comment 2 Julien Nabet 2022-01-23 08:56:30 UTC 
*** Bug 146926 has been marked as a duplicate of this bug. ***
Comment 3 DelphyM 2022-01-23 11:57:17 UTC 
One additional thought on the expected results:
* if the Calc window is maximalised (on macOS it is a weird thing) by double-clicking its title (not using one of 3 control buttons at the top left hand side)
then the autofilter menu should always be displayed downward (as it must be obvious it won't be visible out of the edge of the screen)
Comment 4 eisa01 2023-04-01 18:55:31 UTC 
Can confirm

Tested with the top display as the main display, and my laptop screen directly below it

Moving a Calc window to the bottom laptop screen cause it to open the autofilter upwards instead of downwards as normal
Comment 5 eisa01 2023-04-01 19:13:57 UTC 

*** This bug has been marked as a duplicate of bug 96199 ***