https://bugs.documentfoundation.org/show_bug.cgi?id=162617
Bug ID: 162617
Summary: Enhancement: automatically extend source data
selections for pivot tables when a non-empty row
appears below the source data
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Problem: The standard way has a user interacting with the Pivot Table Layout
dialog box to extend the source data Selection to include new data below the
existing range. This is unsatisfactory when data rows are added frequently, as
there can be more fiddling with the dialog box than with the data being added.
This problem is magnified when multiple pivot tables use the same source data
range.
Workaround: Use an "end-of-data" value as the last row of source data and
insert rows before this value to automatically change the source data Selection
range of all pivot tables using the same source data range. This workaround is
good when source data does not include formulae, but more difficult when the
source range includes computed cells containing relative references, because
generally a table of values with a computed column should use the same relative
formula in all the rows. It is more difficult because formulae referencing
cells below the insertion point will differ from cells above the insertion
point, so that formulae cells must be adjusted, typically with copy and paste.
Wishlist: Automatically extend the source data Selection range to contain
contiguous nonempty rows upon refreshing a Pivot Table, so that interacting
with the Pivot Table Layout dialog box, or the workaround, become unnecessary.
Issue: If a named range is used as the source data Selection, extend the named
range, or not?
Issue: Should this be a user-selectable attribute of individual pivot tables,
or of the source range (especially if it is a named range)? For example, a
named range may be the source Selection for multiple pivot tables. Then it is
desireable to have all such pivot tables extend when new data is appended to
the source data range.
Steps to Reproduce:
1. Create a source data range containing a few columns in LO-Calc.
2. Create 20 or more pivot tables which depend on this source data range. They
should differ in which field values are checked and/or which columns are
selected for pivot tables fields, so that each pivot table gives a different
summary statistic about the source range. This will be time-consuming, but you
only have to set it up once for the life of the spreadsheet.
3. Take a few seconds to add a row to the source data range.
4. Spend several minutes updating all the pivot tables. Have fun doing this
repetitive mind-numbing task.
5. Add another row of data tomorrow. Have fun all over again. Wash rinse repeat
- this is a daily business activity, time which you could spend more
productively.
Actual Results:
6. Subscribe to online accounting software.
7. Transfer the data from your LO-Calc spreadsheet to the accounting system.
8. Throw away LO-Calc, and mourn the loss of flexible custom management
reporting.
9. Pay monthly subscription fees for the life of the business.
Expected Results:
5. Add another row of data tomorrow.
6. Refresh pivot tables.
7. Relax.
Reproducible: Always
User Profile Reset: No
Additional Info:
Automatically extend the source data Selection range to contain contiguous
nonempty rows upon refreshing a Pivot Table, so that adding data to the source
data range does not necessitate working with the Pivot Table Layout.
--
You are receiving this mail because:
You are the assignee for the bug.
