https://bugs.documentfoundation.org/show_bug.cgi?id=166121
Bug ID: 166121
Summary: "Remove Duplicate" needs to be improved to handle
cases with many duplicates
Product: LibreOffice
Version: 25.8.0.0 alpha0+
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
"Remove Duplicate" needs to be improved to handle cases with many duplicates.
Steps to Reproduce:
0. This is an extreme example to illustrate.
1. Open new Calc.
2. Insert "A" in Cell Range [ A1:A100000 ].
3. Select Cell Range [ A1:A100000 ].
4. Menu - Data > Duplicates
5. Actions Option is "Remove", and other Options are Defalt.
6. Push OK Button.
7. It took 7 seconds for Cells [A2:A100000] to be deleted on my PC.
8. Perform Undo.
9. It took 20 seconds on my PC.
10. Select Cell Range [ A1:A100000 ].
11. Menu - Data > Duplicates
12. Actions Option is "Select", and other Options are Defalt.
13. Push OK Button.
14. On my PC, it took less than a second for Cells [A2:A100000] to be selected.
15. Menu - Sheet > Delete Cells ( Ctrl + - ) > Check the "Shift cells up".
16. Push OK Button.
17. It took less than a second to delete Cells [A2: A10000] on my PC.
18. Perform Undo.
19. Undo took less than a second on my PC.
Actual Results:
[2. ～ 9.] In such an extreme case, processing is too slow.
Expected Results:
[10. ～ 19.] At the very least, you should be able to do it faster than doing it
manually.
Reproducible: Always
User Profile Reset: No
Additional Info:
If the lines that can be deleted are consecutive, it should be no problem to
delete them all at once.
It may be unexpected that there is so much overlap, but it should be taken into
account.
Reproducible with
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 7c46846ad1aeeca7e38eb0aada6dc99b5fb701e3
CPU threads: 4; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster;
VCL: win
Locale: ja-JP (ja_JP); UI: ja-JP
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
