On 08/08/12 22:52, anne-ology wrote:
No, I have these problems irrespective of whether I try to work in an
existing excel spreadsheet or have Calc create a new odf spreadsheet and
work in that. The excel spreadsheets are normally locked by default, but
that does not stop this functionality in excel as I added a new sheet to
the spreadsheet in question in Excel 2002 and then proceeded to create a
pivottable using the functionality Calc doesn't support, all while excel
said the spreadsheet was locked.
With the chart issue, if I select a series on the chart, right click and
select chart type, then select say line to change from a column chart to
a line chart, instead of changing just the selected series it changes
the entire chart.
has the file possibly been made read-only or locked?
On Tue, Aug 7, 2012 at 6:01 PM, Steve Morris <email@example.com>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).
I am not allowed to rename at any time the fields in the page
section of the layout (Excel allows this at drag time).
There is no pivottable toolbar, hence there is no way to add
calculated fields to the pivottable (Excel provides this functionality
along with additional functionality available from the toolbar).
I cannot click on a column in the data portion of the pivottable
and drag the column to a new location in the data portion (Excel allows
this, and I have a spreadsheet where this functionality is mandatory for
the data to be displayed from month to month as a new months worth of data
is automatically added to the table).
When I create a chart and define 2 data series to be plotted, Calc
appears to not allow me to display each series as a different chart type
(Excel allows this by plotting both series using the same chart type, then
by clicking on the series excel allows it to be changed from say a bar
chart to a line chart, and allows this to be done for any subsequently
What is the possibility of getting this functionality in calc so that
it can be used as a functional replacement for older versions of excel.
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
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