Bug 157418

Summary:	EDITING: when you copy sheets with a Pivot table to another spreadsheet, the copy is not a Pivot table
Product:	LibreOffice	Reporter:	Gilward Kukel <gilward.kukel>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	normal	CC:	buzea.bogdan, miguelangelrv, stephane.guillou, wojtek
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=104780
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	103381, 108912

Description Gilward Kukel 2023-09-24 19:32:45 UTC

Description:
When you copy sheets with a Pivot table to another spreadsheet, the copy is not a Pivot table.

Steps to Reproduce:
1. make a new spreadsheet
2. make a Pivot table
3. copy all sheets to a new spreadsheet

Actual Results:
The newer spreadsheet contains no functioning Pivot table, it's just a copy of the values.

Expected Results:
The copy should be a functioning Pivot table.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.0.3 (X86_64) / LibreOffice Community
Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: de-AT (de_AT); UI: de-DE
Calc: CL threaded

Comment 1 m_a_riosv 2023-09-25 17:34:33 UTC

Reproducible
Version: 7.6.1.2 (X86_64) / LibreOffice Community
Build ID: f5defcebd022c5bc36bbb79be232cb6926d8f674
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
and
Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: b97f7b6bee733e108d8214d5387b2dc019d93d8f
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Jumbo

Comment 2 Wojtek 2023-10-02 08:25:43 UTC

I have the same issue with one ODS spreadsheet I use since a long time ago (and copy was working fine all the time).

Initially pivot tables were copied as tables and I was wondering what's happening.

Then after removing new spreadsheet and saving the file the pivot tables were gone from 2 last sheets (those are monthly sheets) which would suggest that they weren't detected as pivot tables to start with hence the issue with copying.

And after saving and reopening the file pivot tables are gone from the two sheets altogether.

I tried to replicate it in brand new spreadsheet but it seems to be working fine...


Version: 7.6.2.1 (AARCH64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 10; OS: Mac OS X 14.0; UI render: default; VCL: osx
Locale: pl-PL (es_PL.UTF-8); UI: en-US
Calc: threaded

Comment 3 Stéphane Guillou (stragu) 2023-11-22 21:14:25 UTC

Same in OOo 3.3, so inherited.