https://bugs.documentfoundation.org/show_bug.cgi?id=172386
--- Comment #5 from Robert Lacroix <[email protected]> --- (In reply to Heiko Tietze from comment #4) > You can use the (collapsed) section Source and Destination in the Pivot > Table Layout to move the table to another sheet. Do you need this function > so often that it deserves an extra command/dialog? No, the Pivot Table and linked Pivot Chart must be on separate tabs with the data still linked to the Pivot Table. This is a requirement in an assignment for a university course "IDM 1020 Data Software for Business" that I am taking for credit. https://catalog.umanitoba.ca/undergraduate-studies/course-descriptions/idm It doesn't say anywhere in the course description that this course is mostly about Excel. I dared to do every assignment in LO-Calc but was unsuccessful with the Pivot Charts as described in this bug. To finish the assignment I had to load my .xlsx file into Excel at the school lab and redo that part of the assignment. [Off-topic] I am most certainly the first person ever taking this course to attempt to do any of it with LO-Calc (or Linux), especially considering that this course is aimed at people who know little to nothing about spreadsheets. Thankfully I did learn about some functions which I have never used in 30+ years of spreadsheet use. The instructor knew about LO-Calc but was surprised that it implements Conditional Formatting so well. Microsoft almost pwns this city. PS I did not attempt the Word formatting assignment with LO-Writer since I had an unpleasant result a few weeks ago in a different course with MarkDown interpretation while pasting Python source code into a .docx file prepared by the instructor. -- You are receiving this mail because: You are the assignee for the bug.
