Bug 97671

Summary: Calc does not save filter condition "Empty"
Product: LibreOffice Reporter: HD <kg_ooohelp>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: 79045_79045, raal
Priority: medium    
Version: 4.0.0.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103512    
Attachments: sample document
Screenshots of steps

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].
Correct:
  Filter Criteria changes to [col2 = 66].
Comment 2 raal 2016-02-09 08:21:46 UTC
I can not confirm with LO  5.0.4.2, win7

Please test with current version, version 3.5.6 is outdated
You van download actual version here:
http://www.libreoffice.org/download/
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.

LibreOffice 5.0.4.2
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: 5.2.0.0.alpha0+
Build ID: f4e703aa39e9c294441b6dd86189d8aff32db8bf
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; 
and Version 4.0.0.3
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

Version: 6.3.0.0.alpha0+
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