[Libreoffice-ux-advise] [Bug 145966] [PIVOTTABLE] Add =GETPIVOTDATA(...) formula when referencing data inside a pivot table

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=145966

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|libreoffice-ux-advise at lists |heiko.tietze at documentfounda
                   |.freedesktop.org            |tion.org
           Keywords|needsDevEval, needsUXEval   |

--- Comment #3 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(In reply to Heiko Tietze from comment #2)
> So the question is a) does inserting a formula helps to understand how to
> use it, b) what benefit does this have (the result is the same as with =B3),
> and c) what type of formula to use.
> 
> Me struggles with b) and somewhat a).

Answering myself: Benefit of =GETPIVOTDATA("<Col>";A1) over =A1 is clearly to
keep the value even when the table changes. Plus, it educates the users to use
the right functions.

So let's do it.

-- 
You are receiving this mail because:
You are on the CC list for the bug.