Bug 239526 - kspreadsheet:msoffice2007: Auto filter with blank criteria is not working
Summary: kspreadsheet:msoffice2007: Auto filter with blank 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 normal
Target Milestone: ---
Assignee: Ariya Hidayat
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-22 15:50 UTC by Lassi Nieminen
Modified: 2011-06-29 07:02 UTC (History)
3 users (show)

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


Attachments
Test data created in MS excel 2007 (7.61 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2009-09-22 15:50 UTC, Lassi Nieminen
Details
Screen shot when viewed in Kspread (120.88 KB, image/x-png)
2009-09-22 15:51 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
pyodconverter converted testdata (8.97 KB, application/x-zip-compressed)
2010-03-04 06:50 UTC, Lassi Nieminen
Details
koconverter converted testdata (169 bytes, application/x-zip-compressed)
2010-03-04 06:50 UTC, Lassi Nieminen
Details
koconverter converted testdata opened in openoffice (87.51 KB, image/x-png)
2010-03-04 06:50 UTC, Lassi Nieminen
Details
pyodconverter converted testdata opened in koffice (86.25 KB, image/x-png)
2010-03-04 06:51 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: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.