Bug 71111 - PIVOTTABLE: Possible confusions with pivot table function names (updated behaviour in Comment 8)
Summary: PIVOTTABLE: Possible confusions with pivot table function names (updated beha...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: UI (show other bugs)
Version:
(earliest affected)
4.1.2.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 88897 (view as bug list)
Depends on:
Blocks: Pivot-Table
  Show dependency treegraph
 
Reported: 2013-11-01 01:00 UTC by stragu
Modified: 2018-09-23 01:51 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Different names for one function (20.89 KB, image/jpeg)
2013-11-01 01:00 UTC, stragu
Details

Note You need to log in before you can comment on or make changes to this bug.
Description stragu 2013-11-01 01:00:55 UTC
Created attachment 88456 [details]
Different names for one function

Problem description: 

When creating a pivot table, the naming of the functions can be confusing in several cases.

Steps to reproduce:
1. Select a data range
2. Create a pivot table (Data > Pivot table > Create) and chose "current selection"
3. Drag and drop a source in the data field
4. Double click the source to choose a function

Current behaviour:

The following can be confusing to the user:
- The "Average" function results in "Mean" appearing in the layout (see attached screenshot);
- The "Count (numbers only)" function results in "Count" appearing in the layout, which is the same result as using the simple "Count" function;
- The names "StDev" and "Var" might not be explicit enough.

Expected behaviour:

Ideally, each function should have a shortened name if needed, accompanied by a clear explanation between brackets in the functin selection window.
A function name should be the same in the list and in the layout, and each function should have a different name to discern them in the layout.
             
Operating System: All
Version: 4.1.2.3 release
Comment 1 sophie 2013-11-07 12:25:46 UTC
Confirmed, mark as New, change component to UI - Sophie
Comment 2 A (Andy) 2014-10-02 09:42:36 UTC
reproducible with LO 4.3.2.2 (Win 8.1)
Comment 3 Katarina Behrens 2015-02-19 10:05:25 UTC
*** Bug 88897 has been marked as a duplicate of this bug. ***
Comment 4 QA Administrators 2016-02-21 08:37:24 UTC Comment hidden (obsolete)
Comment 5 stragu 2016-02-22 10:06:27 UTC
This issue is exactly the same in current "Still":

Version: 5.0.5.2
Build ID: 1:5.0.5~rc2-0ubuntu1~trusty1
Locale: en-GB (en_GB.UTF-8)
Comment 6 grofaty 2016-02-22 11:55:02 UTC
I have made three tests on Windows 7 with three different versions:
===========================
SUMMARY INFO
===========================
1. LibreOffice Still 5.0.5.2 (the same problem)
2. LibreOffice Fresh 5.1.0.3 (the same problem)
3. LibreOffice master 5.2.0.0-alfa0+ nightly (can't test, looks like broken)


===========================
DETAILED TESTS
===========================

TEST 1:

There are the following options from menu:
Data | Pivot table | Create
Data | Pivot table | Refresh 
Data | Pivot table | Delete


The naming problem is the same as in "Description" of this bug.


From Help | About menu:
Version: 5.0.5.2
Build ID: 55b006a02d247b5f7215fc6ea0fde844b30035b3



TEST 2:

There are the following options from menu:
Data | Pivot table | Pivot table
Data | Pivot table | Refresh 
Data | Pivot table | Delete 
Note: The first option is strange, double "Pivot table". Don't know if this is additional bug or new "feature".

The naming problem is the same as in "Description" of this bug.


From Help | About menu:
Version: 5.1.0.3
Build ID: 5e3e00a007d9b3b6efb6797a8b8e57b51ab1f737
CPU Threads: 3; OS Version: Windows 6.1; UI Render: default



TEST 3:

There are the following options from menu:
Data | Pivot table | Refresh 
Data | Pivot table | Delete 
Note: This is even more strange. There are only two options available from menu. I don't know if something has changed or there is something broken. I expect to have "Create" option after I mark cells in spreadsheet, but it is not available.

From Help | About menu:
Version: 5.2.0.0.alpha0+
Build ID: 6d5eeb6af585ae525645d844cbbd56e76678a0af
CPU Threads: 3; OS Version: Windows 6.1; UI Render: default; 
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-22_00:12:04
Comment 7 QA Administrators 2018-09-20 02:50:51 UTC Comment hidden (obsolete)
Comment 8 stragu 2018-09-23 01:51:04 UTC
Tested in:

Version: 6.0.6.2
Build ID: 1:6.0.6-0ubuntu0.18.04.1
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-AU (en_GB.UTF-8); Calc: group

The results are slightly different to the original description:

"Average" is now the same word in the menu, the layout and the pivot table headers, which is good.

However, there is still potential confusion in the naming of functions:
- Some names are still abbreviated and never spelled out ("StDev" and "Var"), which makes it less accessible for people who don't know what they stand for;
- The layout and the pivot table headers do not make the distinction between the variations of Count, StDev, and Var: both the layout and the pivot table headers only show "Var" for both "Var" and "VarP", "StDev" for both "StDev" and "StDevP", and "Count" for "Count" and "Count (numbers only)".