https://bugs.documentfoundation.org/show_bug.cgi?id=147209
Bug ID: 147209
Summary: FILTER: Libreoffice Basic filter fails if a date is
used as a criterion
Product: LibreOffice
Version: 7.1.2.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
