https://bugs.documentfoundation.org/show_bug.cgi?id=96977
Bug ID: 96977
Summary: PIVOTTABLE FORMATTING: pivot table uses the formatted
column label which cause errors when calling
GETPIVOTDATA
Product: LibreOffice
Version: 5.0.4.2 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 121810
--> https://bugs.documentfoundation.org/attachment.cgi?id=121810&action=edit
Test-case and comparison with WPS Office and MS Office
Context:
Format Accounting imported from Excel produces a space prefix and suffix (e.g.
"sales" => " sales ").
This is probably the expected behavior as the space prefix is clearly visible
in LibreOffice 10, Excel 2010 and WPC Office 2016 Beta.
Moreover, when the cell is copied into text format (e.g. in Windows Notepad),
the value with spaces is copied.
The LibreOffice Pivot table uses the formatted content converted to text ("
sales ") instead of the value itself ("sales"). This is clearly visible in the
Pivot table layout (see attached file).
The consequence is that formulas such as '=GETPIVOTDATA("sales",A1)' returns
"#REF!" because "sales" is not found (but '=GETPIVOTDATA(" sales ",A1)' work as
expected)
In Microsoft Excel 2013 and WPS Office 2016 Beta, the Pivot table is using the
original value and not the formatted content. Thus '=GETPIVOTDATA("sales",A1)'
returns the expected content.
Expected result:
PIVOT TABLE uses the raw column labels.
Actual result:
PIVOT TABLE uses the formatted column label.
Test-case to reproduce the issue:
See the attached file.
Potential similar issues:
https://bugs.freedesktop.org/show_bug.cgi?id=73305
https://bugs.documentfoundation.org/show_bug.cgi?id=70275
https://bugs.documentfoundation.org/show_bug.cgi?id=89186
--
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
