Bug 125853 - Improve indications for folded data groups in a pivot table
Summary: Improve indications for folded data groups in a pivot table
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.4.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2019-06-11 12:40 UTC by Markus Elfring
Modified: 2019-12-13 14:15 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Markus Elfring 2019-06-11 12:40:15 UTC
I have tried the software “LibreOffice Calc 6.2.4.2-821.3” (Build-ID: 20(Build:2)) out again.
Pivot tables provide also outline functionality.
https://help.libreoffice.org/6.2/en-US/text/scalc/guide/datapilot_edittable.html

Thus data groups can be folded by a double-click on a table cell.
But I got difficulties to notice the folded status of items in the provided (graphical) user interface.
I would appreciate clearer indications for the possibility to unfold them again.
https://en.wikipedia.org/wiki/Outliner
Comment 1 Heiko Tietze 2019-08-19 08:51:27 UTC
What exactly do you mean with outline and where do you double click? We have an autofilter, the dropdown on row fields, to quick filter data (besides the filter function mentioned in bug 125857).
Comment 2 Markus Elfring 2019-08-19 10:52:53 UTC
(In reply to Heiko Tietze from comment #1)
I find that a pivot table can be treated also as an outline editor.
https://help.libreoffice.org/6.3/en-GB/text/scalc/guide/datapilot_grouping.html

Do the actions vary for a double-click on a table cell of this widget?
Comment 3 Heiko Tietze 2019-08-20 08:05:54 UTC
Okay, let's talk about the example from this link. Where do you double-click and what exactly do you expect?
Comment 4 Markus Elfring 2019-08-20 12:28:37 UTC
(In reply to Heiko Tietze from comment #3)
https://help.libreoffice.org/6.3/media/files/scalc/en-GB/pivot.ods

1. A pivot table can be created based on the example data “Car Inventory”.

2. The fields “Branch” and “Car model” can be chosen then for the rows.

3. I suggest to take another look at the software behaviour for a double-click on an entry like “City AA”.
   Do you see how data are hidden and displayed again?
   Does this observation fit to the functionality “(un)folding” (for item labels)?
Comment 5 Heiko Tietze 2019-08-21 08:03:28 UTC
(In reply to Markus Elfring from comment #4)
> 3. I suggest to take another look at the software behaviour for a
> double-click on an entry like “City AA”.

Just to make clear: single click selects a cell like A3 containing "City AA", double-click goes into the edit more.

>    Do you see how data are hidden and displayed again?
>    Does this observation fit to the functionality “(un)folding” (for item
> labels)?

Maybe you have in mind to highlight parts of the chart on selection? I still don't get it.
Comment 6 Markus Elfring 2019-08-21 09:08:44 UTC
(In reply to Heiko Tietze from comment #5)
> Just to make clear: single click selects a cell like A3 containing "City AA",

I agree eventually.


> double-click goes into the edit more.

I wonder about this wording.

I would usually expect an “edit mode” in some cells.


> Maybe you have in mind to highlight parts of the chart on selection?

Not in this use case.


> I still don't get it.

Which software behaviour did you see after double-clicking on “branches” in another separate example pivot table?
Comment 7 Heiko Tietze 2019-08-27 07:23:21 UTC
Looked again into the topic and the workflow is quite common. Single/double click are assigned properly to the interactions and while cross-referencing (selection in charts highlight respective values and vice-versa) sounds interesting it is likely annoying in many situations. Beside the tremendous effort. So WFM.
Comment 8 Markus Elfring 2019-08-27 07:43:39 UTC
(In reply to Heiko Tietze from comment #7)
> Single/double click are assigned properly to the interactions

Yes - to some degree.


> and while cross-referencing (selection in charts highlight respective values and vice-versa) sounds interesting

Will this aspect be relevant for a separate feature request?


> it is likely annoying in many situations.

I suggest to reconsider this view once more.

Would you occasionally like to recognise a bit easier that specific data were excluded from the display by the pivot table widget?
Comment 9 Xisco Faulí 2019-09-26 09:50:33 UTC
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.
Comment 10 Xisco Faulí 2019-10-29 10:04:26 UTC
(In reply to Heiko Tietze from comment #7)
> Looked again into the topic and the workflow is quite common. Single/double
> click are assigned properly to the interactions and while cross-referencing
> (selection in charts highlight respective values and vice-versa) sounds
> interesting it is likely annoying in many situations. Beside the tremendous
> effort. So WFM.

Closing as RESOLVED WORKSFORME.
For further discussion, please use the UX Team meetings...
Comment 11 Markus Elfring 2019-10-29 10:11:34 UTC
(In reply to Xisco Faulí from comment #10)
> For further discussion, please use the UX Team meetings...

I hope that a nicer user interface experience can still be achieved if the remaining communication difficulties will be resolved somehow.
Comment 12 Xisco Faulí 2019-10-30 08:34:02 UTC
You can't confirm your own bugs. Moving it back to UNCONFIRMED until someone
else confirms it.
Comment 13 Xisco Faulí 2019-12-12 12:56:06 UTC
(In reply to Markus Elfring from comment #11)
> (In reply to Xisco Faulí from comment #10)
> > For further discussion, please use the UX Team meetings...
> 
> I hope that a nicer user interface experience can still be achieved if the
> remaining communication difficulties will be resolved somehow.

More UX input needed
Comment 14 Heiko Tietze 2019-12-13 07:20:13 UTC
(In reply to Xisco Faulí from comment #13)
> More UX input needed

See comment 7 (I removed the keyword after Markus reopened the ticket).
Comment 15 Markus Elfring 2019-12-13 12:07:27 UTC
(In reply to Heiko Tietze from comment #14)

* Can it be that you are you still disturbed too much by the cross-referencing idea?
* Will a better understanding be achieved for the software behaviour were are usually expecting after double clicks in pivot tables?
Comment 16 Heiko Tietze 2019-12-13 13:57:12 UTC
(In reply to Markus Elfring from comment #15)
> * Can it be that you are you still disturbed too much by the
> cross-referencing idea?
> * Will a better understanding be achieved for the software behaviour were
> are usually expecting after double clicks in pivot tables?

Maybe, but you don't need to convince me. We are an open source project where my input is just advice from the UX perspective. And I always try to put the KISS principle first. So uncommon interactions may support your workflow but require most other users to learn it for just one application. But if you find a developer, or do it yourself, your contribution is welcome.
Comment 17 Markus Elfring 2019-12-13 14:15:17 UTC
(In reply to Heiko Tietze from comment #16)
Can your contribution become a bit more constructive also for this issue?