[Libreoffice-bugs] [Bug 137321] New: Improve pivot table workflow and usage

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137321

            Bug ID: 137321
           Summary: Improve pivot table workflow and usage
           Product: LibreOffice
           Version: 7.0.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dev at rhoatech.com

When creating a using pivot tables in LO Calc, it's a relatively jarring
experience that takes you out of the workflow of using the spreadsheet. I have
some recommendations to improve the workflow.

1)  Improvement: Applying changes

Current behaviour: Editing the properties of a pivot table requires you to
Right-click on the Pivot Table > go to properties > make the changes > then
click ok to apply changes which closes the dialog, then If you're not happy
with the result you need to start the whole process again.

Recommendation:  When editing the properties of a pivot table, the changes
should be seen immediately without having to click apply or exit the properties
dialog. Live updating could be optional to the user, with the option to click
apply without exiting the properties dialog.

Reason: It takes far too many steps to edit properties and make multiple
changes if you're trying to experiment and get the right pivot table.

2) Improvement: Don't lock main window

Current behaviour: When editing the properties, the main window of LO Calc is
locked from editing.

Recommendation: Do not lock the main window when editing the pivot table
properties, but keep the pivot table properties on top.

Reason: Locking the main window prevents you from making other changes, such as
adjusting columns or fonts, or even cell values, which you may want to affect
the Pivot Table.

3) Improvement: Allow the Pivot Table Properties to be docked to the side panel

Current behaviour: The pivot table properties does not integrate with the main
window, and is it's own dialog window.

Recommendation: Allow the user to dock the properties to the side panel

Reason: This will solve #2 listed above, but will also need improvements from
#1 to have it function correctly.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201008/19b0159d/attachment.htm>