https://bugs.documentfoundation.org/show_bug.cgi?id=145966
Bug ID: 145966
Summary: [PIVOTTABLE]
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 176594
--> https://bugs.documentfoundation.org/attachment.cgi?id=176594&action=edit
Image of the formual. INFODATDOSTABELADINÂMICA is the localized name for
GETPIVOTDATA
Reporting an community demand for pivot tables, available in MS Excel and
missing in Calc.
1) Have a pivot table in your spreadsheet
2) place cursor *out* of the pivot table, say "X1"
3) type = and click in one of the total row/columns of the pivot table
4) Cell X1 has now the formula '=GETPIVOTDATA(...)' with arguments taken from
the source pivot table.
Why this is a nice feature?
a) it is a extremely user friendly way to create the right formula for
GETPIVOTDATA
b) is the pivot data is updated, the formula stays valid.
Actual results:
X1 receives a cell reference of a pivot table cell
Expected result
X1 receives =GETPIVOTDATA(...) with arguments picked from the source pivot
table.
--
You are receiving this mail because:
You are the assignee for the bug.
