I have a spreadsheet that I have used for over seven years. It contains financial data along with some buttons and filter criteria used to produce reports. Suddenly it stopped working. To be precise, no data was produced for the reports even though there were candidate rows matching the specified filter criteria. FYI: I had just upgraded LibreOffice and that is what I thought had contributed to the problem. Eventually, I located a sample spreadsheet (https://ask.libreoffice.org/uploads/short-url/lT0EfZexPIYYIi3SGf7NJEytu8I.ods) that I could use as a test case. I tried it on multiple devices in the home with the following results (all X64 and all Windows): 6.2.5.2 Works 7.0.0.3 Works 7.0.1.2 Works 7.1.2.2 Fails 7.1.6.1 Fails The strange thing is that if you replace the date criterion with its equivalent number (i.e instead of >2018-03-17 you specify >43176) it works. FWIW, I am reporting the bug against the following version: Version: 7.1.6.1 (x64) / LibreOffice Community Build ID: 71560dedfc85ea19274c42531f6929b2ee41d3f6 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win Locale: en-AU (en_AU); UI: en-GB Calc: threaded
Please describe what is wrong and steps to reproduce. I opened the file - what should I do to reproduce the bug. Thank you.
Press the "apply Filter" button
Sorry - I'll be a bit clearer. The filter criteria are in E1:H2 The filtered results (from pressing the "Apply Filter" button) are displayed in columns J, K and L. The table of results I provided in the original post were from merely pressing the "Apply Filter" button. I did not change the criteria. When the filter works, results are display in J, K and L. When it fails, nothing is displayed in those columns. Hopefully, this should clear things up for you - sorry about not being precise enough.
BUMP Is someone going to look at this incident - after all it is (allegedly) regression
I confirmed the problem by testing with the latest in 7.1 bibisect repo, but the problem is gone in 7.4 Arch Linux 64-bit Version: 7.4.3.2 / LibreOffice Community Build ID: 40(Build:2) CPU threads: 8; OS: Linux 6.0; UI render: default; VCL: kf5 (cairo+xcb) Locale: fi-FI (fi_FI.UTF-8); UI: en-US 7.4.3-1 Calc: threaded