Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


Hi :)
Were you able to resolve this issue?  Did you get any decent answers from the Users List?  If not 
then it might be good to ask again now.  Sometimes people just need time to mull over questions but 
by then they have forgotten what they were mulling over as there are constant distractions.  Also 
new people join the lists all the time and everyone has different experience in different areas.
Regards from
Tom :)  





________________________________
From: Steve Morris <samorris@netspace.net.au>
To: users@global.libreoffice.org 
Sent: Wednesday, 8 August 2012, 0:01
Subject: [libreoffice-users] Pivottable/Chart Compatibility in Calc 3.6 with Excel 2002

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




-- 
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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.