Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Do you really believe that all features of Excel - necessary and unnecessary - must be transferred to the LibreOffice?

Let's count the number of clicks (I know that you already know the correct sequence of steps)

  1. Set cursor to any cell in list (if necessary)

2-3. Choose Data - Filter - Standard Filter

4-5. Leave Field name and Condition unchanged, select Not empty from the list of values

  1. Expand Options

  2. Check No duplications

8-9-10-11. Check Copy results to, click Shrink, click target cell, click Maximize (if necessary)

  1. Click OK

So, you must do 7 or 10 or 12 clicks. How many clicks and key pressed must do developers to fulfill your whim? Do you want to know the answer to this question? Just write and debug your own macros that perform these actions for you.

Do you really believe that all features of Excel - necessary and unnecessary - must be transferred to the LibreOffice?

Let's count the number of clicks (I know that you already know the correct sequence of steps)

  1. Set cursor to any cell in list (if necessary)

2-3. Choose Data Choose Data - Filter - Standard Filter

4-5. Leave Field name and Condition name and Condition unchanged, select Not empty empty from the list of values

  1. Expand Options

  2. Check No duplications

8-9-10-11. Check Copy results to, to, click Shrink, Shrink, click target cell, click Maximize Maximize (if necessary)

  1. Click OK

So, you must do 7 or 10 or 12 clicks. How many clicks and key pressed must do developers to fulfill your whim? whim?

Do you want to know the answer to this question? Just write and debug your own macros that perform these actions for you.

Firstly, you get the right solution for you. Second, to learn not to burden the developers to find solutions to already solved problems (IMHO)

Do you really believe that all features of Excel - necessary and unnecessary - must be transferred to the LibreOffice?

Let's count the number of clicks (I know that you already know the correct sequence of steps)

  1. Set cursor to any cell in list (if necessary)

2-3. necessary) - click 1

Choose Data - Filter - Standard Filter

4-5. - clicks 2-3

Leave Field name and Condition unchanged, select Not empty from the list of values

  1. values - clicks 4-5.

    Expand Options

  2. - click 6.

    Check No duplications

8-9-10-11. - click 7.

Check Copy results to, click Shrink, click target cell, click Maximize (if necessary)

  1. necessary) - clicks 8-9-10-11.

    Click OK

- last click, 12.

So, you must do 7 or 10 or 12 clicks. How many clicks and key pressed must do developers to fulfill your whim?

Do you want to know the answer to this question? Just write and debug your own macros that perform these actions for you.

Firstly, you get the right solution for you. Second, to learn not to burden the developers to find solutions to already solved problems (IMHO)