Bug 152387 - Calc Auto-Filter: duplicate filtering items
Summary: Calc Auto-Filter: duplicate filtering items
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-12-05 20:20 UTC by Gwenaël Q.
Modified: 2022-12-08 14:44 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Attached file (39.08 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-12-05 20:25 UTC, Gwenaël Q. 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gwenaël Q. 2022-12-05 20:20:45 UTC 
Description:
Hi, 

Tried a long time to login to https://ask.libreoffice.org. Didn't managed, so I'm posting here. sorry if this is not a bug but a misuse.

In the attached file, look to filterable items of the auto-filter (Column B).
Elements are duplicated, with quotation marks.


Steps to Reproduce:
1. open attached file
2. go to fist row of second column and open the auto-filter dialog


Actual Results:
items are listed duplicated , with and without quotation marks.

Expected Results:
items should not be duplicated


Reproducible: Always


User Profile Reset: No

Additional Info:
Thanks for listening !
Comment 1 Gwenaël Q. 2022-12-05 20:25:37 UTC 
Created attachment 184004 [details]
Attached file
Comment 2 m_a_riosv 2022-12-06 16:07:13 UTC 
Maybe because some of them have a space at the end of the word.

Select the column, Menu/Edit/Find & Replace [Ctrl+H]
Search for a space
Replace with nothing.
Replace All.

Now filter looks fine.
Comment 3 Gwenaël Q. 2022-12-08 14:44:23 UTC 
That's right.

Thank you for your help !