Bug 130968 - UI: Auto generate function GETPIVOTDATA when referencing a cell in pivot table
Summary: UI: Auto generate function GETPIVOTDATA when referencing a cell in pivot table
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.0 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Function
  Show dependency tree / graph
 
Reported: 2020-02-26 20:41 UTC by gmolleda
Modified: 2023-05-10 18:52 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description gmolleda 2020-02-26 20:41:57 UTC 
Create a pivot table
Write in a cell a reference to pivot table
The content of the cell writed must change to auto-generated function =GETPIVOTDATA(...) with the result in cell referenced in the pivot table.
Comment 1 gmolleda 2020-02-26 20:42:52 UTC 
Same that this behaviour in Excel: https://exceltotal.com/referencias-a-tablas-dinamicas/
Comment 2 ifanlo 2020-03-15 09:10:01 UTC 
It is need this funcionality really.
Confirmed in version 6.3.4.2 (ubuntu)
Comment 3 gmolleda 2020-03-15 16:34:26 UTC 
Confirmed in:
Versión: 6.4.1.2 (x64)
Id. de compilación: 4d224e95b98b138af42a64d84056446d09082932
Subprocs. CPU: 2; SO: Windows 6.1 Service Pack 1 Build 7601; Repres. IU: predet.; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: threaded
Comment 4 Buovjaga 2020-05-16 14:14:30 UTC 
Sounds good -> NEW