Created attachment 197629 [details] Example with pivot table and pivot chart Open attached file. It has a pivot table in range F4:L13 in Excel. The opened file has no pivot table there but only ordinary direct cell content.
Created attachment 197630 [details] Screenshot left Excel right LO To verify that it is no pivot table: Change a value in column C, go to Data > Pivot Table. If it were a pivot table, the item 'Refresh' would be enabled.
Reproducible Version: 25.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 83910246044c1e05a3b50e25d21ac6a31566cc38 CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Seems this happens only with pivot in the same sheet. If I create similar pivot in another sheet, that one open in 25.2+, albeit workout theme colors.
Seems this happens only with original pivot in the same sheet. If in MSO I create similar pivot in another sheet, that one opens in 25.2+, albeit black&white, without pivot theme colors.
Created attachment 200268 [details] The pivots source in Excel The source of this pivot is the myData table, provided as if it was from an external file.
Created attachment 200270 [details] Modified version of the example Here a second pivot table was added using the myData table as source. This works, but only because the import changes it to a direct cell range A1:C30. This is just to show a missing feature: in Excel, the pivot tables source can be a named range or table, but in Calc only the named range is supported when creating a new pivot. So the first step would be to add support for creating pivot tables (Data - Pivot table - Insert or Edit) from Database Range names (see Data - Select Range, the "myData" table name is mapped to these).