AutoFilter option in Excel file

Hi, I’m having a problem in a Microsoft Excel file, that was created in Excel. When I open it in LibreOffice, by selecting its filter, it doesn’t perform properly. It is not showing exact filtered options I selected. It’s a major problem. Please help.

Which operating system are you using? Which version of LibreOffice? Is the file format XLS or XLSX?