Bug 148100 - Clarify the pivot tables dialog instructions label to mention double-clicking to edit the properties of a field item
Summary: Clarify the pivot tables dialog instructions label to mention double-clicking...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.5.2 release
Hardware: All All
: medium trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2022-03-20 20:49 UTC by Jeff Fortin Tam
Modified: 2024-03-24 03:14 UTC (History)
3 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 Jeff Fortin Tam 2022-03-20 20:49:12 UTC
The current pivot table dialog currently only shows this label as instructions:

"<u>Drag the Items into the Desired Position</u>"

...but there is a hidden feature there, that I could never discover by myself until I stumbled on it in the user manual, and it shouldn't be that hard to discover: the fact that you can double-click to configure how a particular field item is represented/calculated.

So at the very least, this info label should say:

"<b>Tip:</b> drag & drop items to the desired positions. Double-click them to configure how they are calculated."

Of course this does not replace a more complete UI overhaul to make it easier to understand (bug #131654) but at least changing this label could be done _now_ as a very easy hack, probably one line of code, and the change preserved in whatever new design may come up later down the road.
Comment 1 Roman Kuznetsov 2022-03-21 11:39:48 UTC
Did you try to read the Calc guide? There are many hidden and brilliant features in Calc and after the reading you will know many interesting things.

I don't think we need this. -1
Comment 2 Jeff Fortin Tam 2022-03-22 04:19:31 UTC
Yes I have had a look at the user manual, yet I believe in self-documenting UIs, and I think this is a pretty important feature that is worth the few extra words on the existing label widget.

By your logic, the UI should not try to help the user with hints, not even the existing "Drag the Items into the Desired Position" label, because users should just RTFM.
Comment 3 Roman Kuznetsov 2022-03-22 04:30:51 UTC
(In reply to Jeff Fortin Tam from comment #2)

> By your logic, the UI should not try to help the user with hints, not even
> the existing "Drag the Items into the Desired Position" label, because users
> should just RTFM.

UI should be clear itself, but if we will write the sentence in dialogs for every possibly actions UI will not clear.

Unfortunately, UX for the Pivot table layout options was just copied from MS Excel. We uses drag&drop in our dialogs a few times. Therefore there is the long tip in Pivot table layout dialog.
I don't think we need another tip for double click action because there is a context menu in addition for that double click by item.
Comment 4 Heiko Tietze 2022-03-22 06:46:20 UTC
How about the idea with mockup #3 in bug 131654? https://bugs.documentfoundation.org/attachment.cgi?id=160522
Comment 5 Heiko Tietze 2022-03-24 13:47:08 UTC
No further input, removing UX keyword. Ticket should remain as reference. The actual solution is not to add static tips but to revamp the dialog.
Comment 6 QA Administrators 2024-03-24 03:14:56 UTC
Dear Jeff Fortin Tam,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug