https://bugs.documentfoundation.org/show_bug.cgi?id=104780
Bug ID: 104780
Summary: Impossible to move or copy pivot tables within a sheet
Product: LibreOffice
Version: 5.1.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
