has the file possibly been made read-only or locked?
On Tue, Aug 7, 2012 at 6:01 PM, Steve Morris <samor...@netspace.net.au>wrote: Hi, > 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 > added series). > > 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. > > regards, > Steve > > -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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