Bug 107641 - FILEOPEN XLSX: Database ranges column has extra dropdown arrows
Summary: FILEOPEN XLSX: Database ranges column has extra dropdown arrows
Status: RESOLVED DUPLICATE of bug 91567
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.2 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, filter:xlsx, regression
Depends on:
Blocks:
 
Reported: 2017-05-04 22:07 UTC by Gabor Kelemen (allotropia)
Modified: 2017-05-05 21:39 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Example file with data range on the second sheet (9.45 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-05-04 22:07 UTC, Gabor Kelemen (allotropia) 		Details
Same example file but with switched sheets (9.44 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2017-05-04 22:07 UTC, Gabor Kelemen (allotropia) 		Details
The two example files in Excel 2013 (70.29 KB, image/png)
2017-05-04 22:08 UTC, Gabor Kelemen (allotropia) 		Details
The two example files in Calc 5.4alpha (193.08 KB, image/png)
2017-05-04 22:09 UTC, Gabor Kelemen (allotropia) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (allotropia) 2017-05-04 22:07:06 UTC 
Created attachment 133078 [details]
Example file with data range on the second sheet

Attached file was made with Excel 2013, and has a database range defined on the second sheet for A1:A4 with the first sheet being empty.

When opened in a current Calc 5.4 master it has dropdown arrows in all cells of the given column have extra dropdown arrows, while in Excel only the top cell has a dropdown. The ones at the top 4 cells display the usual filter widget, the others don't do anything.

I think it is an important detail that the range is on the second sheet, as if I switch the two sheets in Excel the problem does not appear.
Comment 1 Gabor Kelemen (allotropia) 2017-05-04 22:07:57 UTC 
Created attachment 133079 [details]
Same example file but with switched sheets
Comment 2 Gabor Kelemen (allotropia) 2017-05-04 22:08:23 UTC 
Created attachment 133080 [details]
The two example files in Excel 2013
Comment 3 Gabor Kelemen (allotropia) 2017-05-04 22:09:07 UTC 
Created attachment 133081 [details]
The two example files in Calc 5.4alpha
Comment 4 Xisco Faulí 2017-05-05 08:16:15 UTC 
Regression introduced by:

author	Markus Mohrhard <markus.mohrhard@googlemail.com>	2013-11-02 16:04:34 (GMT)
committer	Markus Mohrhard <markus.mohrhard@googlemail.com>	2013-11-02 16:09:11 (GMT)
commit 512a14438c4098ca2e30d0b10b6e18506c8475f1 (patch)
tree 57a09381a4dd86945673b7169b1b5d1a2aaf6676
parent 2c92030ff07aff9b10e49844343390925b81545c (diff)
remember column style during XLSX import, fdo#70315
WE overwrote the column style that was set earlier with the default
style.

Bisected with bibisect-42max

Adding Cc: to Markus Mohrhard
Comment 5 Aron Budea 2017-05-05 21:39:53 UTC 
This is a duplicate of bug 91567.

*** This bug has been marked as a duplicate of bug 91567 ***