https://bugs.documentfoundation.org/show_bug.cgi?id=172614
Bug ID: 172614
Summary: EDITING in Calc: insert into multiple selected tabs
with Pivots attached works incorrectly
Product: LibreOffice
Version: 26.2.3.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If I make a small spreadsheet (2 columns, 3 rows) and make a pivot table from
it (separate tab, with source A1:B3) and then insert a third column between the
two, it works correctly (the source selection is updated to A1:C3, fields
remapped). Now if I have e.g. three identically structure tabs and all of them
have their own pivot tabs and then I select the three data tabs and insert a
third column between A and B then the referencing is done incorrectly.
Practically all three columns (one each tab) is inserted into the pivot of the
first tab. So the first pivot becomes A1:E3 (with the fields correctly mapped),
but the other two pivot tabs do not update the range (remains A1:B3) and so the
field mapping also disappears.
Steps to Reproduce:
1.Make three sheets (Sheet1..3), all with 6 cells (A, C, 1, 2, 11, 12)
2.Make a pivot table for all of them one-by-one (Source range A1:B3)
3.Select the three data sheets at the same time and insert a column before B
4.Check the pivot tables and their ranges.
Actual Results:
Pivot1 is using a too large source area (A1:E3), while the other two are not
updated (A1:B3), but because the data moved out of the range, it fails with
(empty) field.
Expected Results:
Do not add three columns to the first pivot, but add one column to each pivot
tables
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 26.2.3.2 (X86_64)
Build ID: 70e089b17412e4cb7773e41413306b17a2328c34
CPU threads: 4; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
