I have created an excel sheet in MS Office 2010 and used Pivot Table Now I am going to give this spreadsheet to my head who uses LibreOffice. Can someone please tell me what are the issues which I can find while opening Pivot table spreadsheet (developed in Office ) in LibreOffice platform and how to tackle it ?
This may not be the solution. I haven’t had any problem using Pivot table between LibreOffice vs. MS-Office, but I can’t guarantee you will be free of problems.
There are plenty of Pivot table problems reported on bug tracker, so I suggest to search the bug tracker:
https://bugs.freedesktop.org/buglist.cgi?list_id=293065&short_desc=pivot%20table&query_format=advanced&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&short_desc_type=allwordssubstr&product=LibreOffice
To be sure everything is working fine I suggest to install LibreOffice https://www.libreoffice.org/download - but you also need to know what is the version of LibreOffice that end-user will be opening your file with. If you need some old version of LibreOffice, then download from: http://www.filehippo.com/download_libreoffice/