Bug 89122 - FILEOPEN an xlsx file with autofilter shows the autofilter icon not only in the top row
Summary: FILEOPEN an xlsx file with autofilter shows the autofilter icon not only in t...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.2 rc
Hardware: x86-64 (AMD64) All
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-02-04 14:18 UTC by Christian Krützfeldt
Modified: 2016-09-20 20:30 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
screenshot of the problem. The file is larger but full of real data that I can't remove. (172.22 KB, image/png)
2015-02-04 14:18 UTC, Christian Krützfeldt
Details
oil.xlsx (468.74 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-06-30 19:40 UTC, aleksander.chuikov@gmail.com
Details
screenshot (255.01 KB, image/jpeg)
2015-06-30 19:44 UTC, aleksander.chuikov@gmail.com
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Christian Krützfeldt 2015-02-04 14:18:42 UTC
Created attachment 113126 [details]
screenshot of the problem. The file is larger but full of real data that I can't remove.

I have an 3rd party generated xlsx file with autofilters in it.

The bug is the autofilter button (triangle facing down) is displayed not only in the top row.

The button is displayed on most cells all the way down to row 1048576. to the right it only goes as far as the right most cell with data in it.

Saving the document in LibreOffice and then reopening it solves the problem the buttons are gone.

Except in the top row the buttons doen't have a menu if you click them, the button icon changes to pressed but nothing else happens.


I've attached a screenshot as I can't share the document in public. And as I didn't create it I can't create an empty one.
Comment 1 raal 2015-02-04 20:24:56 UTC
I can not reproduce with my xlsx file on LO 4.4 and LO 4.5, win7, linux. File created in excel2010.
Comment 2 Buovjaga 2015-02-06 17:56:33 UTC
It would be great, if you could anonymize the document in Excel and attach here. Otherwise it looks like this is doomed to be unreproducible.
Comment 3 raal 2015-02-11 13:24:55 UTC Comment hidden (obsolete)
Comment 4 aleksander.chuikov@gmail.com 2015-06-30 19:40:53 UTC
Created attachment 116954 [details]
oil.xlsx
Comment 5 aleksander.chuikov@gmail.com 2015-06-30 19:41:54 UTC
I have the same bug

Steps to reproduce:
1. Copy-paste data from browser (I use Chrome) to Excel workbook
2. Press Ctrl+T or "Format as Table"
3. Save as xlsx or xlsb
4. Open the file in Calc

Operating System: Windows 8.1 64 Pro
Version: 5.0.0.2, 5.1.0.0alpha1
Comment 6 aleksander.chuikov@gmail.com 2015-06-30 19:44:53 UTC
Created attachment 116955 [details]
screenshot
Comment 7 Buovjaga 2015-07-14 13:40:31 UTC
(In reply to aleksander.chuikov@gmail.com from comment #4)
> Created attachment 116954 [details]
> oil.xlsx

Ok, it seems to be the same bug.
For some reason I didn't see the buttons immediately, but after switching away and back I could see them. Save + reload makes them go away.

Win 7 Pro 64-bit Version: 5.1.0.0.alpha1+ (x64)
Build ID: 8de7d44f96252e97e224d42466698114370dbaa3
TinderBox: Win-x86_64@62-TDF, Branch:MASTER, Time: 2015-07-13_21:43:47
Locale: fi-FI (fi_FI)
Comment 8 QA Administrators 2016-09-20 10:17:48 UTC Comment hidden (obsolete)
Comment 9 Dr4K4n 2016-09-20 20:30:32 UTC
Just tested with Libreoffice 5.1.4.2 on Ubuntu Linux 16.04.1 LTS and it works, should therefore also work for my colleague Christian who initially reported the bug.