There was a time when office compatibility was a bit of a problem on Linux, but with the latest office suites out there available for Linux, this is not an issue anymore. The applications here mimic MS Excel’s behavior, so switching to one of them should be pretty straightforward. Exporting and importing to and from MS Excel format works as well, and there aren’t many compatibility issues – however, the native format these programs use is the OpenDocument Spreadsheet (ODS) format.
This is the spreadsheet application which comes with the powerful LibreOffice suite. This seems to be the most feature-rich and powerful spreadsheet application for Linux. It has support for formulas, charts, text/cell formatting, inserting images, macros, exporting/importing files from MS Excel, saving to OpenDocument Spreadsheet (ODS) format, PDF export function, powerful configuration options.