Description: Saving a document with data filtered could lead to an inconsistent state where filtered data is shown, but clearing the filter will remove all results. It seems that the set filters are lost somewhere between saving and reopening Calc. At some point I noticed that even all of my column headers had been replaced with the same headers in my original document, indicating possible data corruption. However I do not know how to reproduce this result. Steps to Reproduce: 1. Open the attached file. 2. Set the filter in column B to "32" 3. Save the document. Close Calc. 4. Open the document again. Now deselect some item in the filter for column A. 5. Save the document again. Close Calc. 6. Open the document again, it is broken now. Actual Results: Clearing the filter in column A will remove all results. You can see that the filter for column B is still active, but "32" is no longer selected. Expected Results: Clearing the filter in column A should show all entries with "32" in column B. Reproducible: Sometimes User Profile Reset: No Additional Info: Version: 24.8.3.2 (X86_64) / LibreOffice Community Build ID: 48a6bac9e7e268aeb4c3483fcf825c94556d9f92 CPU threads: 8; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win Locale: de-AT (de_AT); UI: en-US Calc: threaded
Created attachment 197752 [details] Document with AutoFilter
Created attachment 197753 [details] Sample file, recreated filter. I think there were two different filters, not one. Recreated the filter, please test.
(In reply to m_a_riosv from comment #2) > Created attachment 197753 [details] > Sample file, recreated filter. > > I think there were two different filters, not one. > > Recreated the filter, please test. Same issue with your file using the same steps.