Bug 152387

Summary:	Calc Auto-Filter: duplicate filtering items
Product:	LibreOffice	Reporter:	Gwenaël Q. <g_quenette>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG
Severity:	normal	CC:	g_quenette, miguelangelrv
Priority:	medium
Version:	7.4.3.2 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Attached file

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 !