Created attachment 179632 [details]
Pivot table on label with mixes of unicode ellipsis and three dots

When data source contains multiple occurs of the equivalent text with three dots and unicode ellipsis, pivot table is malformed.

NOTE on the environment :
- LibreOffice installed through snap
- OS Ubuntu Budgie 20.04 with french language pack

```
$ /snap/bin/libreoffice.calc --version
LibreOffice 7.3.2.2 454130fadb9a820d3728b86ccb63c8f359d70528
```

On the sample document, I use 2 sentences in column A of the first sheet:
- "Livres, CD/DVD, bijoux, jouets…" : text ending with unicode ellipsis (31 cars)
- "Livres, CD/DVD, bijoux, jouets..." : text ending with three dots (33 cars)

Both sentence should be repeated multi times (for pivot table use case), mishandling occurs when there is also distinct sentence between them.

NOTE: The autofilter drop down list shows only 1 sentence (I can't distinguish  on screen if it is the ellipsis variant or three dots). However, when selected, only ellipsis variant is selected for display.
This behaviour is already covered by Bug 105314 https://bugs.documentfoundation.org/show_bug.cgi?id=105314

When using column A as row fields to create a pivot table, there is :
- on A2 : sum of all ellipsis text before the first three dots text
- on A3 : sum of the three dots text between the 2 ellipsis text
- on A4 : sum of the ellipses text between the 2 three dots text
- on A5 : sum of the three dots text after the last ellipsis text

I was expecting as much rows as the number of distinct text (2 rows in the sample) or a single row if lexicographic equivalence is applied.

Unlike the autofilter drop down list, the drop down list of the pivot table shows 4 items instead of 1 or 2.

Due to the both bug on autofilter and pivot table, it is difficult to find the origin of the "duplicate" label in the pivot table.

If ellipsis (or other sentence with lexicographic equivalence on unicode) cannot be handled similarly on all libreoffice modules, I would expect both sentence shown in all drop down lists.