Created attachment 88656 [details]
An ODS spreadsheet demonstrating the issue described above.
Using GETPIVOTDATA function with the second syntax variation, not that which is used in the Function Wizard, the function returns the #REF error.
Steps to reproduce:
1. Open the attached spreadsheet and examine the two formulae in cells A31 and A32.
2. The formula in cell A32 is entered using the second syntax style available for this function.
Returns a #REF error.
It should return the same result as the formula entered in cel A31.
Also included in the spreadsheet is a screen-shot taken from Open Office for illustration purposes relating to the syntax.
Operating System: Windows XP
Version: 220.127.116.11 rc
Hi John, thanks for reporting.
Version 18.104.22.168 (Build ID: 2e2573268451a50806fcd60ae2d9fe01dd0ce24)
Version: 22.214.171.124.0+ Build ID: d6ee64b75581cbeb92534271ee6f4e87f07aa5c
Version: 126.96.36.199.alpha0+ Build ID: 7c19dd02d9241e06ecfeeb9ba4ab2971cba7ef43
Not verified in 3.6
Last version working:
LibreOffice 188.8.131.52 Build ID: 3215f89-f603614-ab984f2-7348103-1225a5b
Works too on LO 184.108.40.206 portable, Windows 7 Home Premium.
*** This bug has been marked as a duplicate of bug 69518 ***
*** Bug 72963 has been marked as a duplicate of this bug. ***