Bug 125732 - CALC - insert a new column before the first column after the PivotTable
Summary: CALC - insert a new column before the first column after the PivotTable
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
Reported: 2019-06-06 08:42 UTC by kabilo
Modified: 2021-06-16 16:55 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:
Regression By:

error message (16.37 KB, image/jpeg)
2019-06-06 08:43 UTC, kabilo
test file attached (15.42 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-06-06 20:35 UTC, kabilo

Note You need to log in before you can comment on or make changes to this bug.
Description kabilo 2019-06-06 08:42:46 UTC
it is not possible to insert a new column before the first column after the PivotTable. Insert a new column after the last column of the PivotTable is possible. 

Actual Results:
it is not possible to insert a new column before the first column after the PivotTable

Expected Results:
allow insertion

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 kabilo 2019-06-06 08:43:57 UTC
Created attachment 151956 [details]
error message
Comment 2 Xisco Faulí 2019-06-06 11:04:42 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 3 kabilo 2019-06-06 20:35:45 UTC
Created attachment 151998 [details]
test file attached

cannot insert new column before column C  in test file (error message attached)
Comment 4 Roman Kuznetsov 2019-06-08 20:01:23 UTC
confirm in

Version: (x64)
Build ID: b170256fb6ebaf774b02b89835b19d9f3a1afb89
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-06-07_03:30:35
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

but I'm not sure it's really a bug

Mike, Eike, what do you think?
Comment 5 Eike Rathke 2019-06-13 11:24:57 UTC
Looks wrong to me, inserting at column C doesn't alter the pivot table. FWIW, one can insert a column after column B (which essentially is the same).
Btw, inserting after column A is also possible, which is wrong and shouldn't be. Inserting before column B is not possible, which is correct.
Comment 6 QA Administrators 2021-06-13 03:48:57 UTC Comment hidden (obsolete)
Comment 7 Roman Kuznetsov 2021-06-16 16:55:30 UTC
still repro in

Version: (x64) / LibreOffice Community
Build ID: b89ebf135818ccaa45bbfb164099a6e199bd7d11
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded