https://bugs.freedesktop.org/show_bug.cgi?id=47562
Bug #: 47562
Summary: Can't pivot table the same ms excel (Result False)
Classification: Unclassified
Product: LibreOffice
Version: unspecified
Platform: Other
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: itcen...@thaituan.com.vn
Created attachment 58735
--> https://bugs.freedesktop.org/attachment.cgi?id=58735
the file pivot False
I have a file .xls (file attachment) when pivot by MS Excel then result True
else pivot by LibreOffice Calc then result False. I want to pivot sheet2 sum
amount 1, amount 2, amount 2 flowing department and group by items.
However result is False the row number 44 and row number 206 the same is Items.
I try use function "TRIM" column Items but result False, oh! surprise if i use
function TRIM items to other column and group by this column then result True.
I think, the libreOffice do not auto format, auto trim before pivot. I wish the
error to fix the soon.
Thanks you very much!
note: I user LibreOffice 3.5.1 on OS Ubuntu and Window
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
