https://bugs.documentfoundation.org/show_bug.cgi?id=167398
Buovjaga <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Version|7.3.7.2 release |3.5.0 release Summary|Data -> Advanced Filter -> |Advanced Filter forces |No Duplicates does not |"Range contains column |properly filter unique |labels" |numbers with "Copy" | |parameter included | Component|Calc |Documentation Status|UNCONFIRMED |NEW Ever confirmed|0 |1 CC| |olivier.hallot@libreoffice. | |org Blocks| |109326 OS|Linux (All) |All --- Comment #8 from Buovjaga <[email protected]> --- (In reply to jacob.sternig from comment #6) > Created attachment 207574 [details] > Results of copied information from No Duplicate Filters being applied. 1 is > counted twice The root cause is that we can't uncheck "Range contains column labels". The option is disabled, yet it seems to be active by default. This is true already in version 3.5. Reading the code, I find: https://git.libreoffice.org/core/+/f26084217a406828c7fb013bb006cad4f495a4be/sc/source/ui/dbgui/sfiltdlg.cxx#170 // special filter always needs column headers (Probably it was called "special" instead of "advanced" in ancient times) So it looks like the dialog is working as intended. I suppose it would be nice, if the code comments explained *why* the column headers are always needed. There is no mention of this behaviour in help or the Calc guide book: https://help.libreoffice.org/latest/en-US/text/scalc/guide/specialfilter.html https://books.libreoffice.org/en/CG262/CG26202-EnteringandEditingData.html#toc60 I would like to turn this into a documentation issue. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109326 [Bug 109326] [META] Data filter bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
