Bug 108352

Summary:	Structure of pivot table coming from XLS is altered in LO
Product:	LibreOffice	Reporter:	Aron Budea <aron.budea>
Component:	Calc	Assignee:	Tamás Zolnai <zolnaitamas2000>
Status:	RESOLVED FIXED
Severity:	normal	CC:	michael.meeks, raal
Priority:	medium	Keywords:	filter:xls
Version:	4.0.0.3 release
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=108343
Whiteboard:	target:6.0.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	124812
Attachments:	Sample XLS Screenshots for comparison

Description Aron Budea 2017-06-05 22:02:53 UTC

Created attachment 133866 [details]
Sample XLS

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 & 4.0.0.3 / Windows 7.

Comment 1 Aron Budea 2017-06-05 22:03:56 UTC

Created attachment 133867 [details]
Screenshots for comparison

Comment 2 raal 2017-06-06 18:48:12 UTC

I can confirm with Version: 5.5.0.0.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

Comment 3 Commit Notification 2017-08-29 22:08:22 UTC

Tamás Zolnai committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=b90bdb1c0d27fd87c85a2d1d6ea66070b97b7977

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:
http://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

Comment 4 Tamás Zolnai 2017-09-14 15:23:41 UTC

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.