Max Depth:

Bug 109326 depends on 301 bugs:

view as bug list

•    109326: [META] Data filter bugs and enhancements [NEW; assigned to libreoffice-bugs]
  •    34394: Standard Filter order of actions inconsistent between Calc and Base [NEW; assigned to libreoffice-bugs]
  •    35923: Calc - Standard Filter produces wrong display (Selection range is automatically expanded) [NEW; assigned to libreoffice-bugs]
  •    56187: Standard Filter gets wrong criteria from Autofilter and vice versa [NEW; assigned to libreoffice-bugs]
  •    64641: EDITING: Filtering in Mac-Addressbook is not possible [NEW; assigned to libreoffice-bugs]
    •    126961: Cannot link to macOS address book - crashes and restarts [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    82008: Impossible to drop a standard filter criterion without also dropping following ones in the list [NEW; assigned to libreoffice-bugs]
  •    85976: [RFE] Add a "remove duplicate records" command [ASSIGNED; assigned to sahil]
  •    95264: Enhancement Suggestion: Save Filters as Favourites [NEW; assigned to libreoffice-bugs]
  •    103512: [META] AutoFilter-related bugs and enhancements [NEW; assigned to libreoffice-bugs]
    •    37259: FORMATTING Define Print Range across filtered rows fails [NEW; assigned to libreoffice-bugs]
    •    55398: FILTER: Enable on/off toggling for complex filtering under autofilter [NEW; assigned to libreoffice-bugs]
    •    60208: FILTER / UI / VIEWING : Using autofilter, when filtering, merged cells related to row not drawn (second result onwards) [NEW; assigned to libreoffice-bugs]
    •    68115: [Autofilter] Additional options (on top of window) are not accessible by Alt + letter shortcut [NEW; assigned to libreoffice-bugs]
    •    79140: Allow "Top 10" Auto Filter to Include Strings [NEW; assigned to libreoffice-bugs]
    •    82662: Feature Request: to add transposed auto filter on columns (rather than rows) [NEW; assigned to libreoffice-bugs]
    •    91847: “Filter Criteria” section does not fill extra space when resizing Standard Filter window [NEW; assigned to libreoffice-bugs]
    •    94660: ORDERING with Unicode order is not respected (sort dialogue and autofilter) [NEW; assigned to libreoffice-bugs]
    •    98205: Text for limitation of auto filter items is not shown when the widget is opened again [NEW; assigned to libreoffice-bugs]
    •    104314: macOS: [Calc] When filtering/sorting, the popup closes without applying filters [NEW; assigned to libreoffice-bugs]
    •    105980: Filter lost the Regular expression after saving [NEW; assigned to libreoffice-bugs]
    •    107385: Autofilter sorting breaks rows data alignment without warning [NEW; assigned to libreoffice-bugs]
    •    107648: CHARTS: Filtering makes subcategories disappear from graph display if there remains only one element [NEW; assigned to libreoffice-bugs]
    •    111778: Standard filter dialog window is not re sizable (work around in #10) [NEW; assigned to libreoffice-bugs]
    •    117346: color of Auto-FILTER-▼-Button does not switch back from blue to black after Filter RESET, still shows old filter settings [NEW; assigned to libreoffice-bugs]
    •    118574: Calc: show error and other special values at the beginning of the list of automatic filters [NEW; assigned to libreoffice-bugs]
    •    118625: AutoFilter dropdown is lost when range has no header and the first value is filtered out [NEW; assigned to libreoffice-bugs]
    •    121314: Show rows vs filter [NEW; assigned to libreoffice-bugs]
    •    123560: Add shortcut to open AutoFilter widget when in range (regardless of button visibility) [NEW; assigned to libreoffice-bugs]
    •    123807: [META] XLSX (OOXML) Autofilter-related bugs [NEW; assigned to libreoffice-bugs]
      •    118592: FILEOPEN XLSX AutoFilter import erroneously requires FilterDatabase defined name [NEW; assigned to libreoffice-bugs]
      •    138704: FILEOPEN XLSX AutoFilter in Table imported incorrectly, interacts weirdly with normal autofilter [NEW; assigned to libreoffice-bugs]
      •    142928: FILEOPEN XLSX Standard filters date condition appears converted to plain number [NEW; assigned to libreoffice-bugs]
      •    151505: Autofilter in xslb file ignored [NEW; assigned to libreoffice-bugs]
      •    157689: XLSX Autofilter bug; all sheets contain autoFilter XML specs, but only the last sheet presents the filters [NEW; assigned to libreoffice-bugs]
      •    99913: Importing autofiltered XLSX and selecting cells copies hidden cells, too [VERIFIED FIXED; assigned to tundeth]
      •    107082: FILEOPEN XLSX: Autofiltered date cell is hidden, but does not appear as filtered in the list [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    107797: Autofilter dropdown behaves strangely when it's created by a macro in a specific XLSM [VERIFIED FIXED; assigned to btomi96]
        •    107238: VBA autofilter needs support for list of strings arguments [RESOLVED FIXED; assigned to libreoffice-bugs]
      •    107858: Autofilter is created differently in Excel macro compared to manual creation [VERIFIED FIXED; assigned to btomi96]
      •    115022: subtotal in .xlxs wrong on fileopen with Recalculation on File Load [VERIFIED FIXED; assigned to libreoffice-bugs]
      •    116818: XLSX FILEOPEN: Autofiltered date column and another filtered column discard the filtering [VERIFIED FIXED; assigned to varga.balazs3]
      •    119637: XLSX: Small perf delay filtering file with 1500 comments in cells [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
      •    119913: FILEOPEN: XLSX: Wrong subtotal using autofilter after hard recalculating [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    122331: Autofilter disappeared after export to XLSX [VERIFIED FIXED; assigned to libreoffice-bugs]
      •    123353: FILESAVE XLSX AutoFilter button lost when exporting MS Excel created XLSX files if only empty cells are set to visible [RESOLVED FIXED; assigned to tibor.nagy.extern]
      •    124080: System freezes after search using autofilter [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    125828: XLSX: Performance issue undoing filtering file with 1500 comments in cells (GTK/GTK3) [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
      •    126505: Wrong Subtotal of auto-filtered rows on opening XLSX (comment 6) [CLOSED DUPLICATE; assigned to libreoffice-bugs]
      •    127301: FILESAVE XLSX Adjusting autofilter range creates extra name range [VERIFIED FIXED; assigned to varga.balazs3]
      •    137519: Calc is not copying data correctly with AutoFilter [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    137626: EDITING Handling time in autofilter [VERIFIED FIXED; assigned to varga.balazs3]
      •    138089: Crash when type any char in standard filter in the attached xlsx file (filter was set in MSO using wildcard autofilter match) [VERIFIED FIXED; assigned to libreoffice-bugs]
      •    138377: Autofilter not recognized even when XLSX has <autoFilter> defined in openxml [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    139809: FILESAVE XLSX Autofilter with filtered dates [VERIFIED FIXED; assigned to libreoffice-bugs]
      •    140085: FILEOPEN XLSX Counting the number of autofiltered records in status bar does not happen [VERIFIED FIXED; assigned to libreoffice-bugs]
      •    140098: FILESAVE XLSX Excel detects invalid contents in autofilter of particular document [VERIFIED FIXED; assigned to varga.balazs3]
      •    140469: FILEOPEN XLSX Autofilter opened incorrectly with more than 8 filtering conditions [VERIFIED FIXED; assigned to varga.balazs3]
      •    140968: FILEOPEN XLSX Autofilter does not take number formatting in account [VERIFIED FIXED; assigned to varga.balazs3]
      •    140978: FILEOPEN XLSX Autofiltered time entries are not selected [VERIFIED FIXED; assigned to libreoffice-bugs]
      •    141309: FILEOPEN XLSX Autofiltered time values do not appear in autofilter [VERIFIED FIXED; assigned to varga.balazs3]
      •    141915: FILEOPEN XLSX Autofilter condition with value 0.0 not checked [VERIFIED FIXED; assigned to varga.balazs3]
      •    142215: FILEOPEN XLSX Autofilter does not check values ending with zeroes [VERIFIED FIXED; assigned to varga.balazs3]
      •    142578: FILESAVE XLSX Filter by color overwrites conditional format background setting [VERIFIED FIXED; assigned to vasily.melenchuk]
      •    142929: FILEOPEN XLSX Standard filter with condition “Earlier than” imported incorrectly [RESOLVED FIXED; assigned to tundeth]
      •    143068: FILESAVE XLSX Standard filter condition of Top10 lost [VERIFIED FIXED; assigned to tundeth]
    •    125644: Select marker in filter entry list not correctly set, filter not correctly reset [NEW; assigned to libreoffice-bugs]
    •    132521: Show information when a range has been defined (applies to Sort, Filter...) [NEW; assigned to libreoffice-bugs]
    •    134777: EDITING: After adding content to new cells while leaving an empty row after the old content, rerunning autofilter has no effect [NEW; assigned to libreoffice-bugs]
    •    134884: Impossible to filter a column by searching a letter/word and unchecking all checkboxes [NEW; assigned to libreoffice-bugs]
    •    135125: Autocalculate broken if autofilter was active during formula creation (steps in comment #2) [NEW; assigned to libreoffice-bugs]
    •    140074: Clicking on items in Autofilter does not change their checked state (gtk3) [NEW; assigned to libreoffice-bugs]
    •    141212: [META] XLS Autofilter-related bugs [NEW; assigned to libreoffice-bugs]
      •    109374: Filesave XLS: autofilter shows different items checked [NEW; assigned to libreoffice-bugs]
      •    115122: In specific XLS file in drop-down autofilter's list there aren't any items (workaround: turn off-on autofilter) [NEW; assigned to libreoffice-bugs]
      •    76389: Calc: Used AutoFilter not highlighted when set in Calc and saved as XLS [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    141310: UI Autofilter dropdown should be able to group date & time values [NEW; assigned to libreoffice-bugs]
    •    141598: Standard Filter Window Width of three monitors when selecting thousands of rows [NEW; assigned to libreoffice-bugs]
    •    142076: [META] Color filtering in Autofilter bugs and enhancements [NEW; assigned to libreoffice-bugs]
      •    145055: UI Re-running filter by color is inconvenient because of inactive OK button [NEW; assigned to libreoffice-bugs]
      •    145056: UI Turning autofilter OFF and ON again retains the color filter setting [NEW; assigned to libreoffice-bugs]
      •    158613: Autofilter entries not consistent between first and subsequent opening (with background color in cells) [NEW; assigned to libreoffice-bugs]
      •    76258: Filter by colors in Calc [CLOSED FIXED; assigned to samuel.mehrbrodt]
      •    142393: CRASH: Clicking on filter by color dropdownlist (gen) [VERIFIED FIXED; assigned to libreoffice-bugs]
      •    142420: Filter By Color: Hangs after apply a color filter and then deselect the filter [VERIFIED FIXED; assigned to caolan.mcnamara]
      •    142522: Filter By Color: allow multiple selection [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
      •    142578: FILESAVE XLSX Filter by color overwrites conditional format background setting [VERIFIED FIXED; assigned to vasily.melenchuk] (*)
      •    142579: FILEOPEN XLSX Conditional format background colors not considered by color filter [VERIFIED FIXED; assigned to samuel.mehrbrodt]
      •    142580: FILEOPEN XLSX Conditional text format colors not considered by color filter [VERIFIED FIXED; assigned to samuel.mehrbrodt]
      •    142965: There is no way to select cells without color text or color filling in Autofilter [VERIFIED FIXED; assigned to samuel.mehrbrodt]
      •    143103: Support Color Filter in "Standard Filter" dialog [RESOLVED FIXED; assigned to samuel.mehrbrodt]
      •    143104: Color filter by text color lost (XLSX) [VERIFIED FIXED; assigned to vasily.melenchuk]
      •    144010: Filter by Background / Text Colour does not work for cells formatted by condition [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    144320: Color filtering stops program after de-selecting color [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    144410: UI Autofilter dropdown does not indicate that color filtering options are submenus [VERIFIED FIXED; assigned to caolan.mcnamara]
      •    144549: Filter by Color does not work for colors, which are set by number format [RESOLVED FIXED; assigned to samuel.mehrbrodt]
      •    144618: Standard Filter Dialog doesn't show up with GTK3 [RESOLVED FIXED; assigned to serval2412]
      •    144808: Add some triangle to Text color and Background color items in Autofilter window [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    144811: Align color items with "No fill" item in Autofilter's background and text color submenus [VERIFIED FIXED; assigned to caolan.mcnamara]
      •    145054: FILEOPEN XLSX Copying a sheet with autofilter by color leaves unusable autofilter on the copy sheet [RESOLVED FIXED; assigned to samuel.mehrbrodt]
      •    145057: FILESAVE XLSX Color filter set in data range does not work [RESOLVED FIXED; assigned to samuel.mehrbrodt]
      •    145058: FILESAVE XLSX Adding new sheet with conditional formatting loses autofilter condition [RESOLVED DUPLICATE; assigned to samuel.mehrbrodt]
      •    145059: FILESAVE XLSX Changing the conditional formatting of autofiltered color loses the filter condtion [RESOLVED FIXED; assigned to vasily.melenchuk]
      •    145329: [CRASH] Filtering by Background color freezes LO Calc [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    148820: FORMATTING - Background color of Cells in Excel sheet with conditional formatting is not correctly rendered [RESOLVED FIXED; assigned to balazs.varga991]
      •    149648: Background of cells are shown in black when there is no value [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
      •    150077: Allow to choose several color options in the automatic filter [CLOSED DUPLICATE; assigned to libreoffice-bugs]
      •    153972: Calc Autofilter can't select background colour when all cells in the filtered column have no content [VERIFIED FIXED; assigned to samuel.mehrbrodt]
    •    142999: Problems with filter of rows and images after the file is saved with filter activated [NEW; assigned to libreoffice-bugs]
    •    143833: FILEOPEN Filtered row headers aren't shown in blue when a file is opened [NEW; assigned to libreoffice-bugs]
    •    144048: Calc: Define Range doesn't set selected range [NEW; assigned to libreoffice-bugs]
    •    145499: CALC AUTOFILTER Numerical values duplicated in the drop down pane [UNCONFIRMED; assigned to libreoffice-bugs]
    •    145889: Autofilter result is wrong if the column contains the number "1000" and the text "'1000" [NEW; assigned to libreoffice-bugs]
    •    145995: Defined DATA ranges merge destructively if cells separating them are inadvertently filled (autofilter extending data area) [NEW; assigned to libreoffice-bugs]
    •    147076: AutoFilter does not show special characters [UNCONFIRMED; assigned to libreoffice-bugs]
    •    147296: AutoFilter: After hovering "Text color" the colors list does not disappear [NEW; assigned to libreoffice-bugs]
    •    147420: Images anchored to a cell and selected with AUTOFILTER are not displaying or PRINTING correctly [NEW; assigned to libreoffice-bugs]
    •    148293: Sorting columns with AutoFilter moves the AutoFilter button [NEW; assigned to libreoffice-bugs]
    •    148596: Selection List can appear very wide, depending on longest string in column - odd looking [NEW; assigned to libreoffice-bugs]
    •    148660: Closing autofilter with Esc after specific steps displays grey area [NEW; assigned to libreoffice-bugs]
    •    149662: Standard filter treating text badly if being composed of digits only [NEW; assigned to libreoffice-bugs]
    •    149851: Mouse pointer over down arrow in AutoFilter should not be a fat cross [NEW; assigned to libreoffice-bugs]
    •    149907: Standard Filter demands change on "Value" field, otherwise it does not update results [NEW; assigned to libreoffice-bugs]
    •    149984: Add counts to AutoFilter drop down (with Copy) [NEW; assigned to libreoffice-bugs]
    •    150150: [Calc][UI] Comment indicator is hidden behind the AutoFilter dropdown [NEW; assigned to libreoffice-bugs]
    •    150799: [UI] Poor space utilization in multi-line cell with filter on [NEW; assigned to libreoffice-bugs]
    •    150861: Autofilter result is wrong when I deselect one item, click OK, then click on the dropdown again [NEW; assigned to libreoffice-bugs]
    •    152334: Autofilter doesn't work on a custom array function range [NEW; assigned to libreoffice-bugs]
    •    152582: The autofilter outputs several values 0 and empty if data is the result of VLOOKUP function [NEW; assigned to libreoffice-bugs]
    •    152658: Calc Autofilter "loses track" of entries when they are changed, hiding them when the filter is examined [NEW; assigned to libreoffice-bugs]
    •    154968: CALC: Insert into multiple selection not possible but it is described in online help and not working that way [NEW; assigned to libreoffice-bugs]
    •    156058: Jumping to list item in AutoFilter doesn't work on Linux with VCL: gtk3 [NEW; assigned to libreoffice-bugs]
    •    156305: Allow to invert selection in Autofilter [NEW; assigned to libreoffice-bugs]
    •    157152: VIEWING: Calc, window width in AutoFilter keeps increasing horizontally [NEW; assigned to libreoffice-bugs]
    •    157177: Calc AutoFilter popup hides filtered column when opened, should be on the side [NEW; assigned to libreoffice-bugs]
    •    157476: AutoFilter is filtering incorrectly when set to hide empty cells [NEW; assigned to libreoffice-bugs]
    •    157878: Do an exact match of items in the autofilter [NEW; assigned to libreoffice-bugs]
    •    158326: FILTER autofilter seems to convert ß in ss and ignores value [NEW; assigned to libreoffice-bugs]
    •    158634: dates handled as text in AutoFilter when using a complex, conditional date format code [NEW; assigned to libreoffice-bugs]
    •    158733: Add UI Configuration Option To Disable Showing Hidden Filter Elements As Inactive In Autofilter [UNCONFIRMED; assigned to libreoffice-bugs]
    •    159737: Autofilter dropdown should be case-sensitive and independent from the filter dialog [NEW; assigned to libreoffice-bugs]
    •    159778: Calc autofilter does not allow to edit after last row [NEW; assigned to libreoffice-bugs]
    •    160326: AutoFilter does not automatically hide rows upon cell value changes in Calc [UNCONFIRMED; assigned to libreoffice-bugs]
    •    36383: EDITING auto row height or change row height removes AutoFilter result [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    46062: Autofilter should not tick "all" if each individual value is selected (blanks should be omitted) [RESOLVED FIXED; assigned to andreas.heinisch]
    •    46184: [Calc] [AutoFilter] Option "Copy results to ..." remains activated in AutoFilter [VERIFIED FIXED; assigned to tundeth]
    •    47079: EDITING Autofilter header is shifted hiding autofilter [VERIFIED FIXED; assigned to attila.szucs]
    •    48025: EDITING AUTOFILTER: Autofilter settings stay with the column number when deleting columns [VERIFIED FIXED; assigned to tundeth]
    •    49205: EDITING: Pasting range into autofiltered fields results in "Insert into multiple selection not possible" [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    49813: Enhanced autofilter popup window (Data > Filter > Auto Filter) should be resizeable (too narrow) (width too small) [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    53431: FILTER: fill down a cell with Autofilter arrow box cause duplication of arrow box [VERIFIED FIXED; assigned to attila.szucs]
    •    55269: Calc AutoFilter Performance Affected by Windows 7 Settings [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    57351: Calc: "Insert columns" is not available in the context menu if an autofilter to hide rows is applied [VERIFIED FIXED; assigned to tundeth]
    •    59312: AUTOFILTER: in non functional after 'Copy Sheet' in new sheet [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    60186: FILTER: The active filter column is not highlighted [RESOLVED WONTFIX; assigned to libreoffice-bugs]
    •    64703: PRINTING: Problem with page break when autofilter is on [VERIFIED FIXED; assigned to attila.szucs]
    •    68113: [UI] [Autofilter] Selecting "Not empty" unchecks all entries [VERIFIED FIXED; assigned to varga.balazs3]
    •    76481: Using autofilter pulldown on column with particular amount of records will freeze graphical mode, after few minutes normal state is restored [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    78664: Having over 100 000 rows autofilter does not open dialog box (hanging) (possibly related to decimal places) [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    81010: Calc crashes when sorting using autofilter sort [VERIFIED FIXED; assigned to deena.francis]
    •    85773: Auto-filter uses wrong, extended range for filtering [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    89158: Autofilter no longer needs Empty and Not Empty options [RESOLVED NOTABUG; assigned to libreoffice-bugs]
    •    89244: AutoFilter on merged cells is empty [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    89841: [Calc] Autofilter - weak indication that autofilter was set [VERIFIED FIXED; assigned to tundeth]
    •    97671: Calc does not save filter condition "Empty" [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    102298: [UI] In Autofilter the 5 elements on top do not get focus by Tab, nor have a shortcut [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    105629: AutoFilter filters incorrectly with time values. [RESOLVED FIXED; assigned to kohei]
    •    106214: Filtering on date columns doesn't work with autofilter [RESOLVED FIXED; assigned to markus.mohrhard]
    •    109240: FILESAVE XLSX: Use of Data > AutoFilter provoke auto-creation of multiple defined Name ranges over multiple consecutive save in XLSX format of the same file causing compatibility issue with Excel 2016 (file cannot be opened in Excel 2016) [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    112516: Autofilter adds a filter automatically [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    112656: selected text is truncated in Calc sort dropdown [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    113585: Auto Filter Columns are Treated Separately in the Attached ODS File [RESOLVED NOTABUG; assigned to libreoffice-bugs]
    •    115046: Autofilter is disabled prematurely [VERIFIED FIXED; assigned to erack]
    •    116047: LO 6.0.1.1 (x64) calc windows, autofilter freezes [VERIFIED WORKSFORME; assigned to libreoffice-bugs]
    •    116633: Values in filtered columns with dates shown incorrectly [RESOLVED DUPLICATE; assigned to varga.balazs3]
    •    116675: Autofilter: Clicking on item name does not select the item like in Excel [VERIFIED FIXED; assigned to attila.szucs]
    •    117234: FILTER: Typing in the autofilter box on a long list causes keyboard entry to be incorrectly entered [RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
    •    117276: Autofilter settings being reset in some cases [VERIFIED FIXED; assigned to balazs.varga991]
    •    118602: EDITING Undoing Cut-Delete-Paste multiplies filter [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    120223: Autofilter is empty in date column after making changes and reopening the file (Hungarian locale) [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    122084: Autofilter menu disappears as I move the pointer if Display zoom set to 200% in Ubuntu Settings for HiDPI monitor [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    122260: EDITING Autofilters not properly cleared [VERIFIED FIXED; assigned to serge.krot]
    •    122332: Slowly work of autofilter in 6.2 in comparison by 6.1 [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    122419: AutoFilter Search Freezes Calc if the column contains many unique values [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    122496: Autofilter icon marked as filtered (there is a dot) when shows all rows [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    122570: Doesn't work Enter key in Autofilter window in Calc [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    122759: AutoFilter list is created not case sensitive but filtering is case sensitive [VERIFIED FIXED; assigned to attila.szucs]
    •    122772: Table splits after AutoFilter popup menu use [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    122774: All items in AutoFilter popup menu are not keyboard accessible [VERIFIED FIXED; assigned to raykowj]
    •    122998: Move above checkboxes in Autofilter window [RESOLVED FIXED; assigned to heiko.tietze]
    •    123095: Auto filter result is wrong when cell value contains full-width and half-width characters and case-insensitive filtering is used [RESOLVED FIXED; assigned to andreas.heinisch]
    •    123202: EDITING Sorting of the filtered data is incorrect [VERIFIED FIXED; assigned to tundeth]
    •    123204: EDITING Not all special characters appear in the AutoFilter window ( Hungarian ) [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    123598: Autofilter removed from output range after save & reload [VERIFIED FIXED; assigned to tundeth]
    •    123662: EDITING: matrix formula fails if filter is applied [CLOSED NOTABUG; assigned to libreoffice-bugs]
    •    124007: Doesn't set up focus into text field in Autofilter window [VERIFIED WORKSFORME; assigned to libreoffice-bugs]
    •    124115: Autofilter button display is wrong [RESOLVED INSUFFICIENTDATA; assigned to libreoffice-bugs]
    •    124450: Libreoffice Calc: Autofilter functions are slow [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    124701: EDITING existing spreadsheet: counting the number of autofiltered records doesn't work [VERIFIED FIXED; assigned to varga.balazs3]
    •    125190: sort by color or filter by color is the only option missing in Libreoffice as compared to excel [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    125363: UI: LibreOffice Calc's AutoFilter treats combining and modifier letters the same as plain letters in the value list [RESOLVED FIXED; assigned to andreas.heinisch]
    •    125791: Text in Autofilter dropdown chages size when hovering over it (w/ 125% DPI scaling) [RESOLVED FIXED; assigned to vmiklos]
    •    125814: Some items disappear in Autofilter drop-down when you select or deselect any item and shows when you scroll list [VERIFIED FIXED; assigned to vmiklos]
    •    125919: Rendering's artifact in Autofilter drop-down widget [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    126006: Calc with Tabbed UI used to crash after File>>Reload; many toolbar items aren't working including save [RESOLVED FIXED; assigned to jluth]
    •    126144: Make font sizes in Autofilter window the same for 125% scaling [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    126306: Doesn't work Top 10 item in Autofilter [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    126356: Tiny visual artifact when opening autofilter menu [RESOLVED FIXED; assigned to jluth]
    •    127168: "Ranges containing merged cells…" modal dialog underlays Autofilter pull-down [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    128072: Libreoffice Calc autofilter is getting stuck for minutes when typing in the search box, only if input data is diversified. [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    130770: Autofilter not updated on data change (automatically or manually) [VERIFIED FIXED; assigned to info]
    •    133160: Autofilter popup should be resizeable [VERIFIED FIXED; assigned to attila.szucs]
    •    133492: Autofilter can't be easily/obviously re-run against additional data [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    133564: Text OK on button in Autofilter window doesn't show (macOS) [VERIFIED FIXED; assigned to thorsten.wagner.4]
    •    133700: Autofilter drop down opens slowly [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    133804: Autofilter is very slow when deselecting one item and click OK if the column headers are not defined [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    133828: Autofilter drop down opens with a 3 seconds delay (with multiple filter criteria set) [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    133834: Calc autofilter freeze after deselecting an item (in a column containing many unique date-time values) and pressing OK [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    133835: Calc autofilter freeze after deselecting an item (in a column containing many unique string values) and pressing OK [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    133836: Autofilter enables deselect items automatically when typing a search [RESOLVED FIXED; assigned to sahil]
    •    133867: Open file slightly slower & ctrl+a causes CPU to peak (autofilter related?) [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    133878: Slow performance in autofilter if the record contains many unique values (10 seconds after 5.4 vs. 2 seconds before) [RESOLVED FIXED; assigned to l.lunak]
    •    134270: AutoFilter select out of dialog, looks worse in 7.1+ [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    134351: Wrong Auto Filter Result if all the records are selected [VERIFIED FIXED; assigned to xiscofauli]
    •    134523: Calc hangs when you press Cancel in Autofilter window (mac OS only?) [VERIFIED FIXED; assigned to caolan.mcnamara]
    •    136535: EDITING “Fill Cells” onto autofiltered cells destroys autofilter [RESOLVED FIXED; assigned to attila.szucs]
    •    136559: Calc freezes when click "All" in auto-filter dialog [VERIFIED FIXED; assigned to caolan.mcnamara]
    •    136838: AutoFilter Improvement: Use "Not Equal" (i.e., <>) when we selected all but one item [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    137628: Item's rows in Autofilter list have two color [VERIFIED FIXED; assigned to attila.szucs]
    •    138438: CALC AutoFilter Top 10 malfunctions when another column is already filtered [VERIFIED FIXED; assigned to varga.balazs3]
    •    139460: Custom Sort popup in Autofilter popup can't be dismissed by scrolling away (GTK3) [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    140048: CALC Custom Sort for Autofilter WINDOWS [RESOLVED NOTABUG; assigned to libreoffice-bugs]
    •    140270: LibreOffice 7.1 - Auto Filter settings lead into wrong Standard Filter settings [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    140462: FILEOPEN ODS Autofilter on a date column makes autofilters on other columns empty [VERIFIED FIXED; assigned to varga.balazs3]
    •    140599: EDITING Row and column highlight cleared when selection moves over a filtered row [VERIFIED FIXED; assigned to tundeth]
    •    140745: AutoFilter dropdown doesn't show (empty) on top of the list with values [VERIFIED FIXED; assigned to tundeth]
    •    140955: EDITING Highlight active autofilters dropdown [VERIFIED FIXED; assigned to tundeth]
    •    141559: Add Clear Standard Filter to Autofilter widget [VERIFIED FIXED; assigned to tundeth]
    •    141775: EDITING Autofilter with fraction values does not differentiate between items [VERIFIED FIXED; assigned to varga.balazs3]
    •    141916: FILESAVE ODS Autofilter conditions with fractional values is not saved [VERIFIED FIXED; assigned to varga.balazs3]
    •    141946: EDITING Inserting column before autofiltered column empties autofilter [VERIFIED FIXED; assigned to tundeth]
    •    142231: Lose of autofilter items list when save and reread a Calc document [VERIFIED FIXED; assigned to szabolcs450]
    •    142350: EDITING Autofilter enables (empty) filtering if filtering for 0 is also enabled in a range containing empty cells [VERIFIED FIXED; assigned to tundeth]
    •    142389: Help for AutoFilter [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    142393: CRASH: Clicking on filter by color dropdownlist (gen) [VERIFIED FIXED; assigned to libreoffice-bugs] (*)
    •    142579: FILEOPEN XLSX Conditional format background colors not considered by color filter [VERIFIED FIXED; assigned to samuel.mehrbrodt] (*)
    •    142580: FILEOPEN XLSX Conditional text format colors not considered by color filter [VERIFIED FIXED; assigned to samuel.mehrbrodt] (*)
    •    142965: There is no way to select cells without color text or color filling in Autofilter [VERIFIED FIXED; assigned to samuel.mehrbrodt] (*)
    •    143048: Autofilter dropdown window width is not resizable [RESOLVED FIXED; assigned to heiko.tietze]
    •    143587: Latest *Dev Release appears to magnify autofilter buttons [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    144155: CALC Row operations over 100 times slower in 7.2 compared to 7.1 [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    144253: Filtering does not work with formatted calculated values [VERIFIED FIXED; assigned to varga.balazs3]
    •    144324: VIEWING Autofilter does not display calculated cell contents according to cell format [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    144740: Criteria query (COUNTIF(), MATCH() et al) for numeric values broken considering number formats [VERIFIED FIXED; assigned to erack]
    •    145901: Autofilter popup shows in invisible position of the desktop (again) on low-resolution display (gtk3) [VERIFIED FIXED; assigned to caolan.mcnamara]
    •    145925: AutoCorrect DOI (ISO 26324) recognition [VERIFIED FIXED; assigned to baole.fang]
    •    146018: Group similar autofilter submenu items to save the vertical space [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    146037: Autofilter is slow when filter conditions are set in multiple columns [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    146326: The Autofilter Input Box should get focus upon mouse-hover [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    146463: Filtering of data series name does not hide it in chart legend [VERIFIED FIXED; assigned to ouyang.leyan]
    •    146795: Calc crashes when pasting data into filtered cells (mdds) [RESOLVED FIXED; assigned to kohei]
    •    147444: Dependency between auto filter and standard filter [RESOLVED WONTFIX; assigned to libreoffice-bugs]
    •    147475: AutoFilter: Search filter not working when choosing to show specific entries [RESOLVED NOTABUG; assigned to libreoffice-bugs]
    •    147744: Calc crashes when pasting simple formula in a filtered column [VERIFIED FIXED; assigned to kohei]
    •    148774: Autofilter confusing input search with Standard filter (UX) [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    149098: Changing Standard Filter condition does not work unless you also update the value [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    149844: LibreOffice hangs on Auto Filter with Filter Criteria then press CTRL + A then try to align Left/Center/Right [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
    •    150647: Autofilter result is wrong when filtering (empty) records [VERIFIED FIXED; assigned to l.lunak]
    •    151152: Autofilter checkbox status is wrong when I deselect one item, click OK, then click on the dropdown again (2nd case) [VERIFIED FIXED; assigned to tundeth]
    •    151206: Auto filtering search entry / text input widget should use a timer-based search activation algorithm to improve performance [RESOLVED FIXED; assigned to andreas.heinisch]
    •    151702: Down arrows in Calc AutoFilter are not very visible using dark mode [VERIFIED FIXED; assigned to rafael.palma.lima]
    •    151996: crash when clicking autofilter (macOS 13) [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
    •    152082: Converting .xlsx to .ods does not correctly convert chosen filtering options [VERIFIED FIXED; assigned to tundeth]
    •    152325: Autofilter Show/Hide only the current item doesn't work [RESOLVED FIXED; assigned to caolan.mcnamara]
    •    152635: Image anchored to cell jump around when sorting + autofilter [RESOLVED FIXED; assigned to libreoffice-bugs]
    •    156686: AutoFilter arrows have white background in kf5/gen [VERIFIED FIXED; assigned to libreoffice-bugs]
    •    158314: Autofilter dropdown list always shows "Empty" and "Error" enties as active [RESOLVED FIXED; assigned to suokunlong]
    •    159420: EDITING Autofilter for empty cells disabled when by Autofilter in other column empty cells filtered out [VERIFIED FIXED; assigned to xiscofauli]
    •    160329: Image anchored to cell ends up in wrong cell after using autofilter sort, depending on hidden rows [VERIFIED FIXED; assigned to libreoffice-bugs]
  •    103548: Filtering rows and columns in 2 dimensions [NEW; assigned to libreoffice-bugs]
    •    82662: Feature Request: to add transposed auto filter on columns (rather than rows) [NEW; assigned to libreoffice-bugs] (*)
  •    117328: RESET FILTER will not restore all lines of area containing empty cells [NEW; assigned to libreoffice-bugs]
  •    117743: Standard filter / remember setting when whole column is selected [NEW; assigned to libreoffice-bugs]
  •    122975: CALC: Filter should be applied to the whole column, not just to the last cell with value [NEW; assigned to libreoffice-bugs]
  •    123661: add "copy result to new sheet" for filter and sort functions [NEW; assigned to libreoffice-bugs]
  •    124093: EDITING Selecting filtered cells with hidden rows in between causes a bug in filter reset. [NEW; assigned to libreoffice-bugs]
  •    127419: EDITING: Database range is extended automatically against my wishes when filtering [NEW; assigned to libreoffice-bugs]
  •    140095: EDITING Standard filter when added from menu is not visible [NEW; assigned to libreoffice-bugs]
  •    144196: Make "No duplications" in standard filters depending on case sensitive mode [NEW; assigned to libreoffice-bugs]
  •    150937: When opening Advanced filter dialog the "From" field should be filled with the address of current selection [NEW; assigned to libreoffice-bugs]
  •    153057: Calc and Base can not filter time values [NEW; assigned to libreoffice-bugs]
  •    160440: Paste as bitmap (PNG, BMP) of a chart is incorrect when source is filtered [NEW; assigned to libreoffice-bugs]
  •    38343: Behaviour of Advanced Filter in Calc/Spreadsheet is incorrect. Produced not working formulas [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    53430: FILTER: Contain/Does not contain etc Filter does not work on cell with numbers only, if cell format was changed to text after inputting the numbers [RESOLVED WORKSFORME; assigned to libreoffice-bugs]
  •    63708: FILTER: need filter view like ms excel 2007 in libreoffice calc [RESOLVED FIXED; assigned to libreoffice-bugs]
  •    76258: Filter by colors in Calc [CLOSED FIXED; assigned to samuel.mehrbrodt] (*)
  •    76898: It is not possible to reset the Standard Filter [RESOLVED FIXED; assigned to martin.vanzijl]
  •    80853: Calc freezes while filtering large data [VERIFIED FIXED; assigned to l.lunak]
  •    93664: filter a list with merged cells does not work [VERIFIED FIXED; assigned to tundeth]
  •    98239: Add means to delete a row in the standard filter dialog [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    105314: EDITING autofilter mixes "…" - 'ellipsis symbol', and "..." - 'three single dots' and produces partial result | was: Filter finds not all cells [RESOLVED DUPLICATE; assigned to libreoffice-bugs]
  •    119958: filter identifiers are not displayed when a standard filter is set [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    124080: System freezes after search using autofilter [RESOLVED DUPLICATE; assigned to libreoffice-bugs] (*)
  •    124972: Remove Duplicates in Libreoffice Calc [RESOLVED NOTABUG; assigned to libreoffice-bugs]
  •    125190: sort by color or filter by color is the only option missing in Libreoffice as compared to excel [RESOLVED DUPLICATE; assigned to libreoffice-bugs] (*)
  •    133683: Values cleared when scrolling in standard filter dialog [VERIFIED FIXED; assigned to libreoffice-bugs]
  •    142910: Standard filters involving "greater than" or "smaller than" (>, <, >=, <=) fail and hide everything [VERIFIED FIXED; assigned to varga.balazs3]
  •    143101: VIEWING Standard filter with OR connected criteria is not indicated on dropdowns [VERIFIED FIXED; assigned to tundeth]
  •    147444: Dependency between auto filter and standard filter [RESOLVED WONTFIX; assigned to libreoffice-bugs] (*)
  •    155757: Support Color Filter in "Standard Filter" dialog enhancement - missing background colors choice in filter field. UI french [RESOLVED FIXED; assigned to libreoffice-bugs]
  •    158072: Fails to apply AutoFilter or Standard Filter in Mail Merge dialog after it was applied once successfully (Writer+Calc) [VERIFIED FIXED; assigned to libreoffice-bugs]
  •    158440: Filter for background should take colors in empty cells [RESOLVED FIXED; assigned to libreoffice-bugs]

Bug 109326 does not block any bugs.

Max Depth:

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    [x]
  • | Forgot Password
    Login: [x]