Hey there! I feel your pain—sticking with Ubuntu but needing to meet Excel requirements for class is such a common dilemma. Here are some practical, teacher-approved solutions to avoid switching back to Windows:

1. 直接在Ubuntu上运行正版MS Excel（最稳妥的方案） #

If you have a valid Excel license, you can run it natively on Ubuntu using Wine or PlayOnLinux:

• Install Wine via the Ubuntu Software Center, or run sudo apt install wine in the terminal.
• Download the Excel installer from your Microsoft account, right-click it, and select "Open with Wine Windows Program Loader".
• Follow the installation steps just like you would on Windows. This gives you the exact same Excel experience, so all functions will match what your teacher expects—no compatibility issues at all.

2. 把LibreOffice Calc调成Excel兼容模式（免费且无需额外软件） #

Your initial suggestion of LibreOffice Calc is great, but you can tweak it to match Excel's function behavior perfectly:

• Open Calc, go to Tools > Options > Load/Save > General.
• Set the "Default file format" to Microsoft Excel 2007-365 (.xlsx).
• Switch to the Calc > Formula tab, check the box for "Use Excel function names".
• Most statistical functions (like T.TEST, ANOVA, VLOOKUP, COUNTIF) will now work exactly like in Excel. I’d recommend grabbing a sample spreadsheet from your teacher with the specific functions they use and testing it out beforehand to confirm everything works.

3. 使用Excel Online（浏览器版，零安装） #

If you don’t want to install anything, Excel Online is a perfect fit. Just log into your Microsoft account in any browser (Chrome, Firefox, etc.) on Ubuntu, and you’ll get the full Excel interface with 100% function compatibility. You can save files to OneDrive or download them as .xlsx to share with your teacher—this should meet all their requirements without leaving Ubuntu.

4. 备选方案：OnlyOffice Desktop Editors #

OnlyOffice has better Excel compatibility than LibreOffice for some edge cases, especially with complex formulas or macros. It’s free for personal use, and you can install it on Ubuntu via the Software Center or their official package. It supports almost all Excel functions, so it’s worth trying if LibreOffice still has minor issues with your class’s specific needs.

额外小贴士 #

• Always test with the exact functions your teacher uses before the exam—ask for a practice sheet if you can.
• If macros are required, Wine/Excel Online/OnlyOffice all support them (LibreOffice does too, but sometimes with minor tweaks).

No need to switch back to Windows—these options should cover your needs perfectly!

备注：内容来源于stack exchange，提问作者Abishek Neupane