Created attachment 133866 [details]
The attached simple pivot table was created in Excel 2013 with the same method as in bug 108343, but as an XLS.
In this case if the file is opened in LibreOffice, the structure is different, instead of "Row Labels", the first item (Banana) is the selector, but if you click into Country or Banana cells, the view changes slightly, the table becomes a row taller, and Product becomes the selector again (see attached comparative screenshots).
The roundtripped table looks similar in Excel as its state in Calc, but the border is blue when the pivot area has been clicked into.
Observed with LO 5.4beta1 & 18.104.22.168 / Windows 7.
Created attachment 133867 [details]
Screenshots for comparison
I can confirm with Version: 22.214.171.124.alpha0+
Build ID: 6533c30f7f8b62671fef9e636c49b11127812ed1
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-05-26_02:35:54
Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":
tdf#108352: Structure of pivot table coming from XLS is altered in LO
It will be available in 6.0.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Main issue (selectos's position) is fixed, so I close it.
The border difference is only a runtime difference. MSO highlights borders with blue color in some cases, LO does not. Not seems an actual issue.