I am having problem with some versions of LibreOffice Calc that does not filter correctly when used date.
As shown in the image below I select the year 2016 in the date filter but it pulls records from 2017
https://uploaddeimagens.com.br/imagens/3-png--2403
I have tested with several worksheets and it happens the same way.
I am using version 5.4.1.2 (I tried with the previous 2 and it happened the same way)