Bug 122471 - FILEOPEN XLSX, Pivot missing columns and rows in LO
Summary: FILEOPEN XLSX, Pivot missing columns and rows in LO
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx, regression
Depends on:
Blocks: Pivot-Table-XLSX
  Show dependency treegraph
 
Reported: 2019-01-04 10:27 UTC by NISZ LibreOffice Team
Modified: 2019-03-08 00:56 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot of the original document side by side in Excel and Calc. (362.42 KB, image/png)
2019-01-04 10:27 UTC, NISZ LibreOffice Team
Details
The original document. (362.42 KB, image/png)
2019-01-04 10:27 UTC, NISZ LibreOffice Team
Details
This is the original spreadsheet. (149.01 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-01-08 07:42 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-01-04 10:27:10 UTC
Description:
When the attached file gets opened in LO there are some missing columns and lines. It is probably caused by the remote file that could not be loaded.

Steps to Reproduce:
    1. Open the attached file in LO and MSO
    2. Notice the differences.

Actual Results:
In LO the pivot has less columns and lines.

Expected Results:
It should keep the same amount of lines.


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 NISZ LibreOffice Team 2019-01-04 10:27:31 UTC
Created attachment 148011 [details]
Screenshot of the original document side by side in Excel and Calc.
Comment 2 NISZ LibreOffice Team 2019-01-04 10:27:49 UTC
Created attachment 148012 [details]
The original document.
Comment 3 Julien Nabet 2019-01-04 17:56:59 UTC Comment hidden (obsolete)
Comment 4 raal 2019-01-05 13:29:39 UTC Comment hidden (obsolete)
Comment 5 NISZ LibreOffice Team 2019-01-08 07:42:41 UTC
Created attachment 148126 [details]
This is the original spreadsheet.
Comment 6 Aron Budea 2019-03-08 00:41:36 UTC
Confirmed with LO 6.3.0.0.alpha0+ (4f810905fa74128871f2fe924a3d28a79f4e4261), 6.0.0.3 / Windows 7.
However, it looks complete in 5.4.0.3.
=> regression
Comment 7 Aron Budea 2019-03-08 00:56:03 UTC
Bibisected to the following commit using repo bibisect-win32-6.3.
https://cgit.freedesktop.org/libreoffice/core/commit/?id=9fa34e9f2cebe2cfc551668f2a67ddcb799d3fb8
author		Tamás Zolnai <tamas.zolnai@collabora.com>	2017-10-05 15:13:46 +0200
committer	Tamás Zolnai <tamas.zolnai@collabora.com>	2017-10-05 17:55:18 +0200

tdf#112893: Pivot table: filtering of error item is not imported