Created attachment 204970 [details] table of data and column header, Data > AutoFilter selected PRECONDITION: Calc spreadsheet with a table of data and column header, Data > AutoFilter selected, combo box arrows visible in the first row, see e.g. attached trainstat-filt.ods PROBLEM DESCRIPTION: set cursor _outside_ of the table Data > AutoFilter is not marked in menu (OK) click Data > AutoFilter popup window: "AutoFilter not possible" (NOK) AutoFilter switched off (OK or not??) EXPECTED BEHAVIOR: shall the AutoFilter be switched off if the cursor is not in the table? (although the Data > AutoFilter is NOT marked in the menu) Either "AutoFilter not possible" and nothing is changed -or- no such popup and switch off the only found AutoFilter in the file. Version: 26.2.0.0.beta1 (X86_64) Build ID: 1ff380402efe713308d6f0e5c815a6e3a1b3b67c CPU threads: 5; OS: Linux 6.14; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded
Created attachment 204975 [details] Sample file with several autofilters Version: 26.8.0.0.alpha0+ (X86_64) Build ID: 680(Build:0) CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Defining Menu>Data>Define ranges, it's possible to have several autofilters in one sheet. Find it in the attached sample. Define a range, apply autofilter. Select another range apply autofilter, yes the first one dissapear. Apply again autofilter to definid range, not it is preserved and to range of data with autofilter.