[Libreoffice-bugs] [Bug 35125] New: GETPIVOTDATA Datapilot - Enhance Help Section Manual - L10N

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=35125

           Summary: GETPIVOTDATA Datapilot - Enhance Help Section Manual -
                    L10N
           Product: LibreOffice
           Version: LibO 3.3.0 release
          Platform: x86 (IA32)
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: famoog at googlemail.com


Created an attachment (id=44250)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=44250)
Example Spreadsheet

My explanation refers to the attached OD Spreadsheet:
Issue_GETPIVOTDATA_01.ods.

== Explanation ==
In Issue_GETPIVOTDATA_01.ods
is a Datpilot with:
• Column Fields: Rechnungs-Datum
• Row Fields: Name, Rufnummer
• Data Fields: Kosten
on the Row Field "Name" is set a User-defined subtotal (sum) which is also
visible in the datapilot.

I want to refer to this subtotals using the GETPIVOTDATA formula.
I work under the german locale, UI, and environment.
So I tried:
=GETPIVOTDATA($A$1;"Name[Name1;Summe]")
which doesn't work (#REF: Fehler: Ungültiger Bezug).
But:
=GETPIVOTDATA($A$1;"Name[Name1;Sum]")
does work.
Although in my german locale, I cannot see the word "sum" in my datapilot.

== Reason ==
My guess, the english "sum" in GETPIVOTDATA is necessary in order to assure the
inter-language compatibility. That is if I would use "Summe" the formula
wouldn't work for someone in english locale since there would be no "Summe" in
/his/ datapilot.

== Resolution / Proposal ==
My proposal: the help section to the GETPIVOTDATA formula, should be updated
for non-english locales.
German Example/Proposal:
Wenn mit der Funktion PIVOTDATENZUORDNEN auf benutzerdefinierte Teilergebnisse
im Datenpiloten verwiesen werden soll, so müssen diese mit ihrem englischen
Titel referenziert werden. Benutzen sie dafür folgende Tabelle:
deutsch | englisch
Summe | Sum
Mittelwert | Average
Produkt | Product
Max | Max
...
..
.
Beispiel:
=PIVOTDATENZUORDNEN ($A$1;"Name[Name1;Sum]") anstelle von 
-=PIVOTDATENZUORDNEN ($A$1;"Name[Name1;Summe]")-

== End ==

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.