Steps how to reproduce with Installation of Version: 24.2.3.2 (X86_64) Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: de-DE; Theme: Element Calc: threaded – normal User Profile: Before you Start this test disable Option "Need to use <Ctrl+Click> to open hyperlink! 0. From Test Kit open Spreadsheet1.ods 1. From Test Kit open Spreadsheet2.ods 3. In Spreadsheet2: Menu ˋData → More Filters → Advanced Filterˊ » Filter Dialog opens 4. Switch to Spreadsheet1 5. View UI: » Most Icons are greyed. Strange! 6. In Cell hover Mouse to Cell A2 » Mouse pointer view changes to "Hand with finger" 7. Click on Link in A2 » Expected: Spreadsheet3.ods opens Actual: Nothing! My question: ----------- There might be good reasons to disable many UI functions also in other documents. Where can I read about that? Additional Info: ----------------- a) There are other strange effects: a1) Menu ˋFile → Open recent filesˊ shows "no documents" a2) Menu ˋFile → Closeˊ does nothing If it's intended that particular functions are inactive because of dialog in different documents, there at least should be a warning, they should be greyed or an other visible indicator.
b) More or less the same with open Standard Filter Dialog.
c) Also close-X for closing Spreadsheets will not work
Created attachment 195299 [details] Test kit after Unzip proceed as per original report
d) Some of the related effects are already visible in LibO Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) and Ooo, for example incorrect Hyperlink Handling. But, for example, Toolbar Icons are not completely greyed out in Spreadsheet1, and several I tried worked correctly. Example: copy / paste special sa GDI range F4:F9 from Spreadshhet2 to Spreadsheet1 C23
Also reproduced on Linux: Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 233af54afb6e493c3538efe7c93d0f53f1b4c3ab CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: CL threaded Also, extra steps: 8. In Spreadsheet 1, select a cell range: Advanced Filter dialog gets focused 9. Close Advanced Filter dialog: a leftover floating rectangle is left; both windows are unusable and can't be closed. The soffice process needs to be ended/killed. In OOo 3.3, the UI (toolbars, menus) was greyed out only when the Filter dialog was focused, and the Recent Documents list was populated, but many parts are not functional (still couldn't follow link, close document...) So similar to comment 4. If the dialog accepts a range selection from a different file, I guess it makes sense that other windows have their UI disabled in the same way. However, it does not: selecting a criteria matrix from Spreadsheet 1 results in e.g. $Tabelle1.$B$4:$C$5, without any reference to the external file, and therefore shows the message "This range does not contain a valid query" (as it's looking for it in Spreadsheet 2). And in any case, things like the results (7), (a1) and (9) above are problematic.