Created attachment 200296 [details] Example file from Excel 2016 Attached example file has a pivot table, whose source is a named range, which is defined as a function. This is not imported as a pivot table, only the cell text/number contents are. Another pivot table in the file has its source as a named range, but directly referring to the same cell range. This is imported fine. Also there are some CountA function calls on the sheet, which demonstrate that referring to the range works in another function as plain named range, as function and as the named range defined as function. 1. Open attached document -> The first pivot table is not imported, only the second. Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 22ef238e820955f6f8ac84781289b8a1d8e477b9 CPU threads: 14; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win Locale: en-US (hu_HU); UI: en-US Calc: threaded seems like this has never worked.
Created attachment 200297 [details] Example file from Excel 2016 - second try
Created attachment 200298 [details] Screenshot of the file in Excel 2016 and Calc
Created attachment 200299 [details] When creating a new pivot in Calc, selecting the PivotSource range is allowed
Created attachment 200300 [details] Pivot layout dialog does not list the PivotSource range There seems to be some more problems inside Calc, creating a new pivot with this function-based named range is not working in the Pivot Table Layout dialog, despite the first Select Source dialog allows it to be selected.
Reproducible Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ddc3cf99a47cb76e1386783df782e4852a19307a CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-GB Calc: CL threaded Maybe it is in relation with Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: ddc3cf99a47cb76e1386783df782e4852a19307a CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-GB Calc: CL threaded Maybe in some relation with https://bugs.documentfoundation.org/show_bug.cgi?id=78486 Bug 78486 - Feature Request: Add Calculated Field in PIVOT TABLE