Excel xlsx to LibreOffice


How can I keep the formatting of an .xlsx file when I open it with LibreOffice. When I open it on Windows 7, 10 etc. the xlsx file has colored columns and so on but when I open it with LibreOffice on Linux the file has only the text and numbers without any formatting.

How can I fix this?

Thanks in advance.