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
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
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
Same in OOo 3.3, so inherited.