Excel has a feature where you can remove duplicates with a single click. This would be very helpful to have in LibreOffice as well.
Like this: http://milospjanic.blogspot.com/2011/10/how-to-remove-duplicates-in-libreoffice.html ?
Yes, that is what I was looking for. But I still think it should be an optional button/dialog available on the main toolbar without having to go through all that.
*** Bug 92990 has been marked as a duplicate of this bug. ***
Below also another program that easily performs the procedure.
Additional detail: in Excel, the function *removes* duplicates in-place, while filter in LO only allows hiding in-place, or removing by copying to a different location. So actually, LO lacks the functionality.
(In reply to Joel Madero from comment #1)
> Like this:
> libreoffice.html ?
IMHO, in Excel it made more clear for users. Different dialogue with very simple options. And in result in Excel we have only rows without any duplicates and without copying of result to another range...
*** Bug 109519 has been marked as a duplicate of this bug. ***
I would also like to request that "Remove Duplicates" is added to Calc.
In Excel, removing duplicates from a column is a one click action. In Calc I have to go through multiple steps to obtain this. It's a waste of time if it's encessary to do it in multiple spreadsheets, it's a waste of time to make a macro and other spreadsheets offer this by default.
There is an extension that adds this function to Calc so I propose that this is added to the default installation, that a .uno command is created for this button to be integrated in the Notebookbars as well.
Created attachment 145904 [details]
Remove Duplicates button in Data Ribbon in Excel 2016
Well, that extension apparently does not work in 6.1
Dear Markus and Eike,
Would it be possible to use the code on the extension to provide this function by default on Calc?
It is a really useful data manipulation option that Calc should have by default like most Office suites have.
*** Bug 73712 has been marked as a duplicate of this bug. ***
Well, Muhammet Kara after checking the extension confirmed that it is written in Basic, meaning that it is a macro.
If someone would translate it to C++, it would be awesome.
*** Bug 124758 has been marked as a duplicate of this bug. ***
(In reply to Pedro from comment #13)
> Well, Muhammet Kara after checking the extension confirmed that it is
> written in Basic, meaning that it is a macro.
> If someone would translate it to C++, it would be awesome.
Now there is faster extension https://extensions.libreoffice.org/extensions/remove-duplicates-fast for it
Couldn't this extension be added by default to LibreOffice?
(In reply to Roman Kuznetsov from comment #15)
> (In reply to Pedro from comment #13)
> > Well, Muhammet Kara after checking the extension confirmed that it is
> > written in Basic, meaning that it is a macro.
> > If someone would translate it to C++, it would be awesome.
> Now there is faster extension
> https://extensions.libreoffice.org/extensions/remove-duplicates-fast for it
Couldn't your extension be added by default to LibreOffice?
Also, please consider adding support for it to create its own tab in the Tabbed Bar UI.
I don't know much about LibreOffice software and people are using it and I am the one who knows start working on it. The https://www.assignmenthelper.com.au/do-my-assignment/ share some of the tips and features which will help me more than for sure.
Since we have a working solution with the standard filter dialog it should be easy to add a new UNO command and run the filter procedure with a predefined setting.
Would understand this as a medium to interesting difficulty.
Just to mention: this is not just filtering. It also deletes the cells with duplicate values. But I guess that is one minor thing to add.
pay someone to do assignments
Swithering over unaccomplished and half-and-half assignments and the time is running on the fast track so you feel you can not catch it? Every time you pick up the topic you tangle up with the content in thinking how to start and finish it up? If these are your concerns, then pay someone to do assignments is the handpicked solution students and experts prefer. You can ask us for top-quality assignment and at My Assignment Helper Online, we are ready 24x7 to provide you the best assignment service. https://myassignmenthelperonline.com/pay-someone-to-do-my-assignment.html
Being the outstanding website development company in delhi It is renowned for providing beautiful websites and allows you to enjoy the seamless experience from website design and development to website optimization for various platforms for all your website design and development needs. We work both for higher rankings as well as for conversions. We are Top 5 Digital marketing company in delhi that ensures your business visibility on top of the search engines. At Wondermouse Technologies- website development company, our team has a wealth of experience in making sure it is easy to use and professional.
OnlyOffice, which is an open source (GPL3) office suite added the RemoveDuplicates function.
Maybe we could use their function.
Here's the code pointer in OnlyOffice:
(In reply to Pedro from comment #23)
> OnlyOffice, which is an open source (GPL3) office suite added the
> RemoveDuplicates function.
> Maybe we could use their function.
OnlyOffice doesn't use LibreOffice, so I don't see how we could use their function.
Maybe look at it and make something similar in LibO codebase. Thanks for the explanation on the Telegram channel.
Hello! Is there any news about function?
Having a group of super-expedient and deft academic experts truly helps in delivering express online assignment help in UK on time. You will make certain to get the most awesome aspect help with assignments within the timeframe that you set at the time of placing the request with us.
<a href="https://www.greatassignmenthelp.com/uk/">assignment help</a>
Nice Bug tracking tool like team foundation. If you want to get more information related to your programming and tracking the programming, contact Australia Best Tutor
Created attachment 177433 [details]
Only Office also acquired the Remove Duplicates functionality
Only Office also got the Remove Duplicates functionality by default.
Created attachment 177434 [details]
Remove Duplicates in Google Sheets
This feature is also present in Google Sheets.
*** Bug 144744 has been marked as a duplicate of this bug. ***
Note that any feature request having a working extension with compatible license is already an easy hack. Just use its source code as the template that provides the required logic - it uses UNO commands, which may be easily converted to a C++ code, and assign a new UNO command to that new function.
(Given that Remove Duplicates Fast is based on Remove Duplicates (https://github.com/ACTom/lo-extension-removeduplicates) which is GPLv3, which doesn't allow to use its code in LO directly because we need an MPL-compatible license, interested parties may ask the author for changed license in a github issue.)
What MPL specific license do you recommend?
Asked the dev in a new issue.
The developer already changed the license to MPL 2.0. Hopefully this allows someone to pick this up. :D
Important, also the values of the duplicate selected cells should be deleted and not the entire rows. Moving the remaining data up to leave the blank spaces below.
Created attachment 184664 [details]
Why remove the whole row?
The filter hides the entire 8th row, including the letter f (view image attached).
The correct behavior would be to remove values 1 and 4 from row 8. Do not filter by hiding row 8 but move values 2 and 1 from row 9 up one cell and leave B9 and C9 empty.
I know this was a standard filter, but the button that they put specifically to remove duplicates should not be a filter, but actually remove the duplicate values within the selection and not the entire row.
Created attachment 185548 [details]
WPS Worksheets Manage Duplicates menu
WPS Worksheets is vastly superior in managing duplicates to any other office suite.
It not only allows for removal, but also highlighting and also fetching unique values or highlight them.
Created attachment 185549 [details]
It allows selecting duplicates in selected range, in two ranges within the sheet, in different sheets in the worksheet and in different worksheets!
Created attachment 185550 [details]
Created attachment 185551 [details]
Fetch unique values
This is a feature already available in MSO since at least 2007 and it's a feature that's been actively worked on in other Office suites as well, to a point where it is very well designed.
All in all, this is a feature that is sorely lacking in Calc for several years now and with the evolution of this feature visible in OnlyOffice and WPS Worksheets (available in Linux as well), and with the RemoveDuplicates extension having compatible license with LibO it's hard to understand why this has been overlooked for so long now.
(In reply to Pedro from comment #42)
> with the RemoveDuplicates
> extension having compatible license with LibO it's hard to understand why
> this has been overlooked for so long now.
0. both extensions
are licensed GPL (whatever version) and thus are *not* compatible with LibreOffice licensing.
1. even if they were, that tells nothing about the source code whether it would fit into LO core code (or even be in C++ that it could).
2. if those extensions fulfil the requirements, then why not use them.
If we realize bug 149933 searching for duplicates could be one option too.
(In reply to Eike Rathke from comment #43)
> (In reply to Pedro from comment #42)
> > with the RemoveDuplicates
> > extension having compatible license with LibO it's hard to understand why
> > this has been overlooked for so long now.
> 0. both extensions
> are licensed GPL (whatever version) and thus are *not* compatible with
> LibreOffice licensing.
> 1. even if they were, that tells nothing about the source code whether it
> would fit into LO core code (or even be in C++ that it could).
> 2. if those extensions fulfil the requirements, then why not use them.
Eike Rathke, the developer changed the license on his github repo to MPL 2.0.
Created attachment 185837 [details]
License changed to MPL2.0
The Fast extension was an improvement done by Mike Kaganski and Kompilainnen I believe. They did not change the license on their extension yet.
Am definitely missing this in Calc right now.
(In reply to Pedro from comment #47)
> The Fast extension was an improvement done by Mike Kaganski and Kompilainnen
> I believe. They did not change the license on their extension yet.
Since our extension was based on the previous one, our license was necessarily the same. Since the old extension's license is now MPL 2.0, I am glad to re-license my work under MPL 2.0.
I'm assuming this bug is about adding the command. If we also want to simplify/alter the filtering dialog - that should be a separate bug.
(If I'm wrong - please change the title, clarify the bug's scope in a comment, and refer to the comment in the title)
(In reply to Eyal Rozenberg from comment #50)
The original request was to implement a feature *like Excel's "remove duplicates"*. Filters are orthogonal to that, they never remove any duplicates, only hide or do a partial copy.
Your work is truly remarkable! Thank you for providing us with this wonderful website and all your hard work.