It may be that the file is exported from Numbers as a plaintext XML file, instead of the "packaged XML" that constitutes a proper Excel file. That has been the cause with several XLS files from other sources. Try to change the filename extension (aka "file type") to ".xml".
I suspect that AOO selects import filter from extension, while the other applications you mention are more "content sensitive".
Apache OO 3.4.1/4.1.2, on Ms Windows 7/10 and Mac OS-X. LibreOffice 126.96.36.199 on Mepis Antix MX