Issue 93087 - autofilter broken for merged cells in header of .xls
Summary: autofilter broken for merged cells in header of .xls
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0 Beta 2
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 120882 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-08-25 08:12 UTC by pmike
Modified: 2013-01-29 21:50 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
sample (8.83 KB, text/plain)
2008-08-25 08:12 UTC, pmike
no flags Details
sample (8.83 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-08-25 08:12 UTC, pmike
no flags Details
sample XLS (53.00 KB, application/vnd.ms-excel)
2008-08-26 14:06 UTC, pmike
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description pmike 2008-08-25 08:12:26 UTC
If autofilter's header have vertically merged cells, then dropdown arrows is
invisible and inaccessible from UI
Look at sample file, it was imported from Excel
Comment 1 pmike 2008-08-25 08:12:45 UTC
Created attachment 55984 [details]
sample
Comment 2 pmike 2008-08-25 08:12:50 UTC
Created attachment 55985 [details]
sample
Comment 3 Rainer Bielefeld 2008-08-25 18:12:43 UTC
I checked with "Ooo-dev 3.0.0 Beta Multilingual version English UI WIN XP:
[OOO300m3 (Build9344)]" and can confirm the reported effect for "test1.ods", but
an 'Autofilter - off - on' can heal the problem.

@pmike:
can you attach a .xls created with EXCEL?
Comment 4 pmike 2008-08-26 14:06:39 UTC
Created attachment 56026 [details]
sample XLS
Comment 5 Rainer Bielefeld 2008-08-26 14:28:46 UTC
Yes, checked with 'm3' and Ðвтофильтр.xls; import problem as reported. 
Comment 6 louqle 2012-09-20 06:34:35 UTC
*** Issue 120882 has been marked as a duplicate of this issue. ***