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/4.1.3, on Ms Windows 7/10 and Mac OS-X 10.8.5 and 10.11.
LibreOffice 22.214.171.124 on Mepis Antix MX 14