Bug 239209 - kspreadsheet:msoffice2007: Auto filter with "OR" criteria is not working
Summary: kspreadsheet:msoffice2007: Auto filter with "OR" criteria is not working
Status: VERIFIED FIXED
Alias: None
Product: calligrasheets
Classification: Applications
Component: filter/xlsx (show other bugs)
Version: unspecified
Platform: unspecified All
: NOR wishlist
Target Milestone: ---
Assignee: Ariya Hidayat
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-22 16:16 UTC by Lassi Nieminen
Modified: 2011-06-28 12:53 UTC (History)
4 users (show)

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:


Attachments
Test data created in MS excel 2007 (7.69 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2009-09-22 16:16 UTC, Lassi Nieminen
Details
Screen shot when viewed in Kspread (123.51 KB, image/x-png)
2009-09-22 16:17 UTC, Lassi Nieminen
Details
Screen shot when viewed in msoffice 2007 (2.25 MB, image/bmp)
2010-02-19 07:58 UTC, Lassi Nieminen
Details

Note You need to log in before you can comment on or make changes to this bug.
Description David Faure 2010-05-28 03:09:28 UTC

---- Reported by lassi.ta.nieminen@nokia.com 2009-09-22 17:16:02 +0300 ----

Created an attachment
Test data created in MS excel 2007

SOFTWARE VERSION:
  Kubuntu 9.04
  Koffice (svn version 1026239)
  Test document (MS excel 2007): me07_auto_filter_or_criteria.xlsx

STEPS LEADING TO PROBLEM: 
  1. Open the attached document in MS excel 2007.
  2. Open the same document in KSpread.
  3. Observe that all items in list are displayed when filtered with "OR" criteria

EXPECTED OUTCOME:
Items filtered with "OR" criteria should be displayed
ACTUAL OUTCOME:
All items in list are displayed when filtered with OR criteria
FREQUENCY OF OCCURRENCE: 
always



---- Additional Comments From lassi.ta.nieminen@nokia.com 2009-09-22 17:17:05 +0300 ----

Created an attachment
Screen shot when viewed in Kspread



---- Additional Comments From lassi.ta.nieminen@nokia.com 2009-12-04 10:35:52 +0200 ----

Reassigning bugs from Thomas to Lassi



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-02-19 08:58:24 +0200 ----

Created an attachment
Screen shot when viewed in msoffice 2007



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-02-25 15:40:02 +0200 ----

Changing severity to enhancement



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-10 12:52:44 +0200 ----

Moving to Community sub component



--- Bug imported by faure@kde.org 2010-05-28 03:09  ---

This bug was previously known as _bug_ 140182.

Imported an attachment (id=44660)
Imported an attachment (id=44661)
Imported an attachment (id=44662)

Unknown bug field "example" encountered while moving bug
   <example>2010-03-10 12:52:44</example>
Unknown Component Community
   Using default product and component set in Parameters 

Comment 1 Lassi Nieminen 2011-05-17 10:53:48 UTC
fixed in 3d412a0c19eeb197b49236c851cac237f706efe7
Comment 2 keerthi 2011-06-28 12:16:08 UTC
verified in c7da761cd2cf245608e1498198a81cee6994f46e.