Created attachment 205175 [details] Spreadsheet with corrupted filter Open the attachment, select some cell within the list on the first sheet and call the standard filter dialog. The filter dialog shows Name = 67 It has been stored with: Name = <not empty> Reproduce: 1. Apply Name = <not empty> which selects a list of distinct names on the second sheet because the filter was set with options to copy without duplicates. 2. Save and reload the file. 3. The filter is reset to Name = 67
Yes, I did reset my user profile.
And yes, it's a regression, I suppose.
(In reply to Andreas Säger from comment #2) > And yes, it's a regression, I suppose. Not really a regression. But it is nevertheless a bug. In version 3.5.4 the value field is empty. From version 4.0.1 up to now the value field shows a 0. And the daily build has a 67. The file markup has table:operator="!empty". That is correct. But in the same element the table:data-type="number" and table:value="0" or "67", respectively. Perhaps LibreOffice should implement that the attributes table:data-type and table:value are ignored in case table:operator="!empty" or table:operator="empty". AOO 4.0 shows "- not empty -" in the dialog, but I don't know why.