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