https://bugs.freedesktop.org/show_bug.cgi?id=71234
Priority: medium
Bug ID: 71234
Assignee: [email protected]
Summary: UI: GETPIVOTDATA function returns #REF error
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 88656
--> https://bugs.freedesktop.org/attachment.cgi?id=88656&action=edit
An ODS spreadsheet demonstrating the issue described above.
Problem description:
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.
Current behavior:
Returns a #REF error.
Expected behavior:
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: 4.1.3.2 rc
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
