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 Here.

Reviews

  • Jan Kirchner Dec 31, 2020, 8:59 PM (3 months ago)

    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 Dec 31, 2020, 9:26 PM (3 months ago)

      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 Dec 18, 2020, 6:10 PM (4 months ago)

    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 Dec 18, 2020, 12:44 AM (4 months ago)

    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 Dec 10, 2020, 11:50 AM (4 months ago)

    Worked perfectly for me in LibreOffice 7

  • Avi Wollman Dec 9, 2020, 9:09 PM (4 months ago)

    Useful extension but currently incompatible with LibreOffice 7.

  • Toni Rocha Nov 9, 2020, 8:57 AM (5 months ago)

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

  • Tried It Oct 16, 2020, 8:46 PM (6 months ago)

    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 Oct 16, 2020, 8:50 PM (6 months ago)

      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 Oct 31, 2020, 6:35 PM (5 months ago)

        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 Sep 4, 2020, 10:41 AM (7 months ago)

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

  • Regis Fortier Sep 3, 2020, 2:40 PM (7 months ago)

    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 Oct 4, 2020, 6:53 PM (6 months ago)

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

  • Gabriel Gonzalez Aug 13, 2020, 5:28 PM (8 months ago)

    It works perfectly, it should be a native function in libreoffice calc

    • Jenn Aug 18, 2020, 8:33 PM (8 months ago)

      I wish it worked for me. I keep getting an error. Any idea how to get support?

      • Roman Oct 4, 2020, 6:52 PM (6 months ago)

        Can you find me in LibreOffice Telegram channel?

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