Bug 97671 - Calc does not save filter condition "Empty"
Summary: Calc does not save filter condition "Empty"
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
Reported: 2016-02-09 03:54 UTC by HD
Modified: 2019-02-04 09:45 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

sample document (9.37 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-09 03:54 UTC, HD
Screenshots of steps (239.07 KB, application/pdf)
2016-02-10 01:46 UTC, HD

Note You need to log in before you can comment on or make changes to this bug.
Description HD 2016-02-09 03:54:00 UTC
Created attachment 122468 [details]
sample document

Steps to reproduce:
 1.Open attached sample document.
 2.Set "Empty" on col2 with Autofilter.
 3.Check "Standard Filter". You can see Filter Criteria is [col2 = Empty].
 3.Save the document.
 4.Click "File - Reload".
 5.Check "Standard Filter".

Current behavior:
 Filter Criteria changes to [Col = 66].
 (I don't know what "66" does mean...)

Expected behavir:
 Keep criteria [col2 = Empty] after save.

Best regards.
Comment 1 HD 2016-02-09 05:08:40 UTC
Hi again, I made a mistake in description.

> Filter Criteria changes to [Col = 66].
  Filter Criteria changes to [col2 = 66].
Comment 2 raal 2016-02-09 08:21:46 UTC
I can not confirm with LO, win7

Please test with current version, version 3.5.6 is outdated
You van download actual version here:
Comment 3 HD 2016-02-10 01:46:12 UTC
Created attachment 122492 [details]
Screenshots of steps
Comment 4 HD 2016-02-10 01:48:41 UTC
(In reply to raal from comment #2)

Thank you for your reply, raal.
I repoduce the bug with same version you tested.

Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78
Locale: en-US (ja_JP)
OS : Windows 7

I select "Empty" not "(empty)" in Autofilter items.

Would you see the attached PDF docement?
It describes the steps with screenshots.
Comment 5 raal 2016-02-10 08:07:59 UTC
I can confirm with Version:
Build ID: f4e703aa39e9c294441b6dd86189d8aff32db8bf
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
and Version
Comment 6 QA Administrators 2017-03-06 15:31:17 UTC Comment hidden (obsolete)
Comment 7 Roman Kuznetsov 2019-02-04 09:45:18 UTC
don't repro in

Build ID: ed707a4806a489467c6d9be7d1b787dab94b5f78
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded

Status-> WFM