Description: When creating a pivot table, it is created in a new sheet within the work folder. Each time a pivot table is generated, Calc creates a new sheet. Since the majority of users tipically need at least 2 or 3 pivot table on a sheet, it should be possible to cut & paste pivot tables both within a single sheet both among sheets in the same wotk folder. Today it is not possible while in Microsoft Excel is ordinary business. This flexibility enhancement would be appreciated by all users worldwide.. Actual Results: When creating a pivot table a new sheet containing the pivot table is created. The creation od further pivot tables generate further new sheets. At the moment in CALC it is not possible to create pivot tables in an existing sheet. Furthermore it is not possible to MOVE or COPY the pivot table inside the existing sheet. The only way to move the position of the pivot table (which is always positioned at the top left corner (cell A1) is by adding rows and columns before the table.. Expected Results: Often, when using pivot tables, it is needed to view multpile views (= pivot tables) in the same sheet in order to evaluate the data or build up for other uses. Microdoft Excel allows to create pivot tables anywhere in a sheet and also to build up a new pivot starting form an existing one. I believe that would help all users (from novice to experts) to allow CALC to: - move or copy a pivot WITHIN the same sheet once is created - move or copy a pivot AMONG sheets in the same work folder - create a new pivot starting from an existing one The implementation of these enhancements could help many people to migrate from MS Excel to Libreoffice.. Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (Windows NT 6.1; Trident/7.0; rv:11.0) like Gecko
Would it be enough to close your report as duplicate of bug 34107?
Create the pivot table on the same sheet it's as simple as when on the pivot table loyout, selecting source and adding destination range on selection. The same can be do it to move the pivot table. A workaround to copy the pivot table is copying the sheet to a new one, move the pivot table and delete the last created temporal sheet. So only copy the pivot table in a direct way is not implemented.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170628
Dear Bug Submitter, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-20170727
nice enhancement request. Especially with larger data sets, that one wants to see various options easily side by side (above/below ;) ) Note: it is allowed for Diagrams, and useful there indeed.
*** Bug 136483 has been marked as a duplicate of this bug. ***