Re: [libreoffice-users] Pivottable/Chart Compatibility in Calc 3.6 with Excel 2002

       has the file possibly been made read-only or locked?



On Tue, Aug 7, 2012 at 6:01 PM, Steve Morris <samorris@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+help@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