Am 08.08.2012 01:01, Steve Morris wrote:
I am trying to reproduce spreadsheets created at work in Excel 2002
in Libreoffice 3.6 under Linux and can't do it because pivottables and
charts are not functionally compatible.
When I create the pivottable and drag the fields to the layout I
have the following issues:
At field add time I cannot rename the field nor can I specify
the format of the field if I want a different format to the source
(Excel allows both at drag time).
1) Pivot functions, calculated pivot fields and pivot charts are not
implemented as they used to be implemented in Excel 8 (1997).
2) You can not edit the pivot labels.
3) All pivot cell formats are bound to auto-generated cell styles except
for the number formats which are taken from the source data.
You've got to use MS Excel or find your own work-arounds. For calculated
fields I use to use pivots from databases or database queries instead of
For unsubscribe instructions e-mail to: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy