https://bugs.documentfoundation.org/show_bug.cgi?id=148641
Bug ID: 148641
Summary: inconsistent unicode ellipsis vs three dots handling
in pivot table
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: draco31...@free.fr
Created attachment 179632
--> https://bugs.documentfoundation.org/attachment.cgi?id=179632&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
