Remove Duplicates Fast

Tags: Calc Extensions

Rating:

Remove Duplicates Fast will delete all duplicates from your cell range in LibreOffice Calc

remove duplicates fast 5a10753c 68ac 48a0 b307 89cb4f5dbb4c

Description

It will add own toolbar with only one button and menu item Remove duplicates into menu Data

This extension is fork of https://extensions.libreoffice.org/extensions/remove-duplicates extension.

Release List

  • Release Description Compatibility Operating Systems License Release notes  
  • 1.0.6 Fixed selected range after work of extension 6.1 Linux, Windows, macOS GPL Download
  • 1.0.5 Updated algorithm
    Added translating to Russian
    6.1 Linux, Windows, macOS GPL Download
  • 1.0 First release 6.2 Linux, Windows, macOS GPL Download

Other Extensions

Formatting of All Math Formulas

This extension allows formatting of all (or selection) Math formulas in your document. Works in Writer, Calc, Draw and Impress.

10-2020

Remove Duplicates Fast

Remove Duplicates Fast will delete all duplicates from your cell range in LibreOffice Calc

10-2020

Feedback

Post your review

You cannot post reviews until you have logged in. Login.

Reviews

  • Jake S 03.09.2021, 10:10 (vor 23 Tage)

    Works fine for me. Would like it better if I was able to permanently dock the toolbar. It shows up in its own window every time I open CALC.

    • Jake S 03.09.2021, 10:19 (vor 23 Tage)

      disregard. Turns out I just had to shut all instances and restart the program and it's docked fine.

  • Jan Kirchner 31.12.2020, 20:59 (vor 9 Monate)

    Remove Duplicates is really important extension, if it work faster is it can be even better.
    Unfortunately I tried to use it on only 13000 lines and it crashes all the time...
    What if we need to remove duplicates in many thoussand or hundred thousands lines?

    • Jan Kirchner 31.12.2020, 21:26 (vor 9 Monate)

      Comment:
      after removing all formating it worked fine.
      So it is probably problem of LO as it has problems with formating (slowing many operations)

  • Rufus Laggren 18.12.2020, 18:10 (vor 9 Monate)

    My bad. Rechecked everything. It appears to work just like it should. Probably something happened with sorting, maybe before I ran the de-dupe. Original tests definitely not showing arbitrary rows at top and bottom, but counts were the same for further tests this morning and after checking sort, all uniques were accounted for.

    Wrong on >"sheets switched", too. Probably mixing this extension with another I had been testing. It appears this extension always operates directly on the the active sheet, so to maintain the source intact one must copy content into a new sheet an operate on that copy.

    I'm sorry, folks. Too much coffee, day too long.

  • Rufus Laggren 18.12.2020, 00:44 (vor 9 Monate)

    GUI usable.

    Results BAD. In a 13k row x 47 col sheet, it appeared to work as expected - until I began to compare the old and new sheets. Dozens of unique rows disappeared and that was just paging in from the top and bottom of the sheet.

    Good idea, especially the selection of which columns define a dupe. But DANGEROUS because it appears to work while silently losing data.

    Also, the destination and source sheets appear to be switched. IOW, I thought I defined a new sheet to receive the cleaned data, but it received the original instead.

  • tezza2n 10.12.2020, 11:50 (vor 10 Monate)

    Worked perfectly for me in LibreOffice 7

  • Avi Wollman 09.12.2020, 21:09 (vor 10 Monate)

    Useful extension but currently incompatible with LibreOffice 7.

  • Toni Rocha 09.11.2020, 08:57 (vor 11 Monate)

    Good extension. LibreOffice needs it to remove duplicate rows based in specific columns.

  • Tried It 16.10.2020, 20:46 (vor 11 Monate)

    Tested it on a sheet of 117 lines, 7 of which were correctly identified as being/having duplicate lines by Conditional Formatting. "We found and deleted 2 duplicated values. Now we have only 111 unique values" this extension told me, so it only found and removed 3/7 duplicates, for an error failure greater than 50%.

    • Tried It Some More 16.10.2020, 20:50 (vor 11 Monate)

      To it's credit, for some reason it will find all the duplicates if I sic it on just one column at a time. So if I have it scan only Column A, it does find all 7 duplicates. But if I have scan Columns A-E, then for some reason it only finds 4. Weird.

      Also, I would like a way to review the found duplicates and remove only those I tell it to as my work involves some apparent dupes that actually should not be removed, so I need a way to just organize all the dupes together, and then use my judgment to delete both instances of some, and delete only one instances of others.

      • Roman 31.10.2020, 18:35 (vor 11 Monate)

        It calculate duplicates in all selected columns for one time.
        For example, we have follow:
        1 1 1 1
        1 1 1 1
        1 1 1 2
        1 1 2 2
        1 1 1 2

        and we selected all four column in the dialog, then we'll get follow result:
        1 1 1 1
        1 1 1 2
        1 1 2 2

        the algorithm uses all four values in row as ONE value and checks with other four value row by row

        But if we'll select in our example only first column, then we'll get:
        1 1 1 1

        and all.

  • mari 04.09.2020, 10:41 (vor 13 Monate)

    Can't install. on Calc 7.0.0 portable.
    "an error occured durling file opening"

  • Regis Fortier 03.09.2020, 14:40 (vor 13 Monate)

    Hi,
    It works well till I see the popup showing to me the result (which is exact) BUT NOT DELETING (as it must do) anything... Something wrong ?

    • Roman 04.10.2020, 18:53 (vor 12 Monate)

      Possibly. Give me more info, You can find me on LibreOffice Telegram channel

RSS feed for reviews on this page | RSS feed for all reviews