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.
Gnumeric is a spreadsheet application included as a part of the GNOME Office suite. It supports a slew of different formats, including Microsoft Excel, CSV, OpenDocument, and LaTeX, just to name a few. It copies most of the features available in the more ubiquous, proprietary spreadsheet programs, including charts, random number generation, statistical analysis, styling, and batch processing.