Created attachment 196025 [details]
Excel file with a pivot table defined

I'm using:

Version: 24.8.0.3 (X86_64) / LibreOffice Community
Build ID: 0bdf1299c94fe897b119f97f3c613e9dca6be583
CPU threads: 8; OS: Linux 6.9; UI render: default; VCL: qt5 (cairo+xcb)
Locale: en-US (en_DK.UTF-8); UI: en-US
Calc: threaded

Problem: 

You can find attached a file produced in excel, example.xlsx, this file has a pivot table that was created in excel, as shown in https://i.imgur.com/1CHF7s7.png

When opening this file in calc, the result is https://i.imgur.com/KjFSakf.png

The row header that show up in excel in cell A5 is gone. All the other columns of the pivot table are shifted one column to the left.

I expected to get in Calc exactly the same we have in excel, or, at least, do not have the data columns of the pivot table shifted one column to the left.