[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-users] Re: Pivottable/Chart Compatibility in Calc 3.6 with Excel 2002
- Subject: Re: [libreoffice-users] Re: Pivottable/Chart Compatibility in Calc 3.6 with Excel 2002
- From: Steve Morris <firstname.lastname@example.org>
- Date: Fri, 10 Aug 2012 08:06:24 +1000
- To: email@example.com
On 09/08/12 18:46, Andreas Säger wrote:
Am 08.08.2012 01:01, Steve Morris wrote:So basically your saying that if we have pivottables in excel 2002 that use calculated fields we cannot replicate that in Calc, hence Calc could never be a replacement for excel?
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.Calc allows pivot labels to be edited in all areas of the pivot table except the page area. In my view the method for doing this renaming is extremely archaic.
3) All pivot cell formats are bound to auto-generated cell styles except for the number formats which are taken from the source data.So basically if we want individual numeric fields to display with different formats to each other, and in a format that is different to the raw data, we have to define special styles for each format? Also, correct me if I'm wrong, I thought styles were tied to cells, which would mean we would have to highlight all the cells in the pivot table and select the style, which would then mean that next time the raw data is refreshed, if that causes more rows to be added to the pivot table the formatted will be wrong on the new rows. This seems to also mean that if the layout is changed and additional fields inserted or existing fields change position, the formatting has to be reapplied because because it is tied to the cells rather than the pivot field.
In addition to this, these sorts of changes are not necessarily available if the spreadsheet is set up to refresh the raw data and pivot tables automatically at spreadsheet open time, or does Calc not support this either.
Using databases is not necessarily an option when producing the raw data from an application that does not have access to databases and is outputting the data for the spreadsheet as xml.
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 pivots.
As a side issue to this (I haven't investigated this functionality yet) does Calc support pivot charts?
For unsubscribe instructions e-mail to: firstname.lastname@example.org
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
|[libreoffice-users] Pivottable/Chart Compatibility in Calc 3.6 with Excel 2002||Steve Morris <email@example.com>|
|[libreoffice-users] Re: Pivottable/Chart Compatibility in Calc 3.6 with Excel 2002||Andreas Säger <firstname.lastname@example.org>|
- Prev by Date: Re: [libreoffice-users] Do You Share ODF Documents With MS Office Users?
- Next by Date: Re: [libreoffice-users] Do You Share ODF Documents With MS Office Users?
- Previous by thread: [libreoffice-users] Re: Pivottable/Chart Compatibility in Calc 3.6 with Excel 2002
- Next by thread: Re: [libreoffice-users] Pivottable/Chart Compatibility in Calc 3.6 with Excel 2002