<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Improve pivot table workflow and usage"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137321">137321</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Improve pivot table workflow and usage
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.0.1.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>dev@rhoatech.com
</td>
</tr></table>
<p>
<div>
<pre>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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>