Bug 239526

Summary: kspreadsheet:msoffice2007: Auto filter with blank criteria is not working
Product: [Applications] calligrasheets Reporter: Lassi Nieminen <lassi.ta.nieminen>
Component: filter/xlsxAssignee: Ariya Hidayat <ariya>
Status: VERIFIED FIXED    
Severity: normal CC: inge, lassniem, swathi.vegesna999
Priority: NOR    
Version First Reported In: unspecified   
Target Milestone: ---   
Platform: unspecified   
OS: All   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:
Attachments: Test data created in MS excel 2007
Screen shot when viewed in Kspread
Screen shot when viewed in msoffice 2007
pyodconverter converted testdata
koconverter converted testdata
koconverter converted testdata opened in openoffice
pyodconverter converted testdata opened in koffice

Description David Faure 2010-05-28 03:22:43 UTC


---- Reported by lassi.ta.nieminen@nokia.com 2009-09-22 16:50:39 +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_blank_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 non blank cells are also displayed wjen filtered with blanks
EXPECTED OUTCOME:
Only blank cells should be displayed
ACTUAL OUTCOME:
Non-blank cells also displayed when filtered with blanks
FREQUENCY OF OCCURRENCE: 
always



---- Additional Comments From lassi.ta.nieminen@nokia.com 2009-09-22 16:51:19 +0300 ----

Created an attachment
Screen shot when viewed in Kspread



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

Reassigning bugs from Thomas to Lassi



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

Created an attachment
Screen shot when viewed in msoffice 2007



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-04 07:50:04 +0200 ----

Created an attachment
pyodconverter converted testdata



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-04 07:50:20 +0200 ----

Created an attachment
koconverter converted testdata



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-04 07:50:38 +0200 ----

Created an attachment
koconverter converted testdata opened in openoffice



---- Additional Comments From lassi.ta.nieminen@nokia.com 2010-03-04 07:51:20 +0200 ----

Created an attachment
pyodconverter converted testdata opened in koffice

Observation (1096327) : File got corrupted when converted using koconverter and when loaded in open office error message is displayed.

KOffice loaded the OOo-converted document correctly.



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

This bug was previously known as _bug_ 140176.

Imported an attachment (id=46099)
Imported an attachment (id=46100)
Imported an attachment (id=46101)
Imported an attachment (id=46102)
Imported an attachment (id=46103)
Imported an attachment (id=46104)
Imported an attachment (id=46105)

Unknown bug field "example" encountered while moving bug
   <example>2010-03-04 07:51:20</example>

Comment 1 Lassi Nieminen 2011-05-17 10:55:02 UTC
fixed in 3d412a0c19eeb197b49236c851cac237f706efe7
Comment 2 swathi 2011-06-29 07:02:18 UTC
Verified in 5f6f9401b53343b140d2bae8587ec3a01f103fe1.