https://bugs.freedesktop.org/show_bug.cgi?id=58036
Priority: medium
Bug ID: 58036
Assignee: [email protected]
Summary: EDITING: GETPIVOTDATA function only works with dates
fields as text.
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.0.0.0.beta1
Component: Spreadsheet
Product: LibreOffice
Created attachment 71222
--> https://bugs.freedesktop.org/attachment.cgi?id=71222&action=edit
Sample pivot table with GETPIVOTDATA() function
Win7x64 Ultimate
LODev Version 4.0.0.0.beta1+ (Build ID:
465d3512cca457c79e6ef85ad1cbf6bcc88e888)
Two tables with a pivot table every one.
Same data only change the format of date column.
First table:
GETPIVOTDATA in B13 does not work, looking for a reference date in the pivot
table.
GETPIVOTDATA in B14 works using a date format with TEXT() function in A14.
Second table (only change the format of date column):
GETPIVOTDATA in B29 works looking for a reference date in the pivot table.
Seems that only dates as text or dates with a format with text works as
expected.
--
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
