Bug 88897 - Pivot table - Average and Mean word confusion
Summary: Pivot table - Average and Mean word confusion
Status: RESOLVED DUPLICATE of bug 71111
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.5.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-01-29 09:25 UTC by grofaty
Modified: 2015-02-19 10:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
average_dialog_label_naming.png (91.45 KB, image/png)
2015-01-29 09:25 UTC, grofaty
Details

Note You need to log in before you can comment on or make changes to this bug.
Description grofaty 2015-01-29 09:25:28 UTC
Created attachment 112908 [details]
average_dialog_label_naming.png

In LibreOffice Calc 4.3.5.2 on Windows 7:

1. Open Calc.
2. Type in values in cells:
   Cell A1: Product
   Cell A2: Product_A
   Cell A3: Product_B
   Cell B1: Price
   Cell B2: 100
   Cell B3: 150
3. With mouse select cells A1:B3.
4. Menu Data | Pivot Table | Create.
5. Select Source dialog open, just accept default and click OK button.
6. Pivot Table Layout dialog opens. From Available Fields move Product to Row Fields.
7. From Available Fields move Price to Data Fields.
5. In Data Fields member "Sum - Price" appears. Double click on this member. 
6. Data Field dialog opens. From Function selection select Average and click on OK button.
7. Now problem appears! In Pivot Table Layout dialog in Data Fields it appears: "Mean - Price". Instead of "Mean" I expect to get "Average" displayed, because I have selected Average. I know technically speaking Mean is perfectly fine word, but Average is what I expect to get.
8. Click on OK button to close Pivot Table Layout dialog.
9. New sheet opens with data. See the B1 data field "Average - Price". So this is additional confusion...

In step 6 there is word "Average", in step 7 it is word "Mean" in step 9 it is "Average" again. Confusing...

I think it should be the same word in all of the steps. I prefer word Average.

What is expected?
In step 7 instead of "Mean - Price" it should be "Average - Price".

See print-screen for clear picture.
Comment 1 raal 2015-01-29 11:53:21 UTC
I can confirm with LO 4.3.5, win7. Also in Czech version is word "mean" - not translated.
Comment 2 grofaty 2015-01-29 14:10:09 UTC
@raal, it is not a part of this bug report, but "mean" is also not translated for Slovenian language. I also see selecting any other option like "sum", "min" etc and this options are also not translated. Maybe it is not intended to be translated... I personally actually don't really care about this translations, because I like to use software in English language where ever possible. There should probably be opened another bug report for this "translation" problem, you know to follow one problem per bug report.
Comment 3 Katarina Behrens 2015-02-19 10:05:25 UTC
Average/mean issue is a subset of bug#71111 => marking as duplicate

Non-localized function names are already tracked in bug#81462

*** This bug has been marked as a duplicate of bug 71111 ***