Created attachment 117507 [details] FILE For Test LibreOffice is not removing duplicates lines. For test: * Menu-> Date -> Filter -> Stardard Filter * Field Name = filedigest * Value = No empty * More Options * Enable only: Range contains column labels, No duplications The lines even after several attempts are not removed. It was also tested in versions of LivreOffice 5.0.0, 4.4.4.3, 4.2.6.3 and the problem is the same.
Hi @Erely, thanks for reporting. What rows are you expect must be removed, selecting "No empty".
I wish he removes up all lines with "filedigest" column are equal. In Microsoft Office WPS Office and this removal operation lines of a duplicate column is done perfectly. I tried a number of ways to accomplish this and so far not got any success.
There is not a direct way, but can be done with a few steps. - Select the column to delete duplicates. - Do the filter as you have comment - Select the whole table data. - Copy. - Click on the up-left corner to select all rows. - Show all rows or deactivate the filter. - Select all table data. - On A1 paste. Or maybe easy creating a help column like in this link: http://ask.libreoffice.org/en/question/26865/how-to-remove-entire-row-based-on-duplicates-from-single-column-in-libre-calc/ In any there is another bug report asking for this enhancement. *** This bug has been marked as a duplicate of bug 85976 ***
For me these procedures do not get what I want. I have 4336 lines with many of them in the column "filedigest" equal, so far only Microsoft Office and the WPS Spreadsheets succeeded with a single click diminish the lines to 1722 lines. I also tried to hold the information in the link without success, to me believe that this formula will not do.
(In reply to Erelyn Alves from comment #5) > For me these procedures do not get what I want. > I have 4336 lines with many of them in the column "filedigest" equal, so far > only Microsoft Office and the WPS Spreadsheets succeeded with a single click > diminish the lines to 1722 lines. > > I also tried to hold the information in the link without success, to me > believe that this formula will not do. I think it works as follows: - select column C - Tools > Filter > Standard filter - filedigest <> "" - Options > No duplicates - OK > gives me 1728 lines. (tested in nightly build of master 6.2)