Module 6 · Office Suite — Word, Excel & PowerPoint replacements
The big worry: "If I switch to Linux, can I still open the Word document my boss just emailed me?" Yes. Two free programs on Linux open and save .docx, .xlsx and .pptx files perfectly: LibreOffice and OnlyOffice. Your colleagues won't be able to tell the file ever touched Linux. This module shows you which one to pick, how to set it up so it saves in Microsoft format by default, and the five things to know when you send a file back.
By the end of this module, you will:
- Choose between LibreOffice (classic menus, already on Ubuntu) and OnlyOffice (ribbon UI, free download), and know when each one fits
- Know which LibreOffice app replaces each Microsoft app: Writer = Word, Calc = Excel, Impress = PowerPoint, and which file extensions each opens
- Open a
.docxattachment from Thunderbird, edit it, save it back as.docx, and email it to a Windows-using colleague, for a full round-trip with no formatting loss - Turn off the "Use Word?" save pop-up permanently via Tools → Options → Load/Save → General
- Open Excel spreadsheets in Calc: formulas (
=SUM,=VLOOKUP,=IF), charts and conditional formatting all round-trip to.xlsx - Open PowerPoint decks in Impress: slides, animations, speaker notes; press F5 to present full-screen
- Install the Microsoft core-fonts pack (
ttf-mscorefonts-installer+ Carlito + Caladea) so Linux renders Word docs at the exact same width as Windows - Use the Microsoft 365 web apps at
office.comas an alternative: Word / Excel / PowerPoint in the browser, full-featured - View, export, annotate, sign, reorder and edit PDFs using Evince, LibreOffice, Xournal++, PDF Arranger and LibreOffice Draw
- Know the 5% of files that don't round-trip cleanly (heavy VBA macros, exotic PowerPoint transitions, niche corporate fonts, real-time co-authoring) and the workaround for each
There isn't one Linux Office. There are two.
On Windows you get one Office, Microsoft's. On Linux you choose between two free programs. Both open Word, Excel and PowerPoint files, and both save back to Microsoft format. Same job, slightly different feel. Here is how to choose.
| LibreOffice | OnlyOffice | |
|---|---|---|
| Looks like… | Old Office 2003, with a menu bar at the top, then a toolbar | Office 365, with the "ribbon" you know from modern Word/Excel |
| Made by | The Document Foundation (a free-software charity) | Ascensio System SIA (a Latvian company) |
| Ships with Ubuntu? | Yes, already installed | No, one-click install from Ubuntu Software |
| Best for… | People who never loved the ribbon. Students. Lots of .odt work. | People who use Microsoft 365 every day and want the same buttons in the same places |
| .docx round-trip | Excellent | Excellent (slightly closer to Microsoft because OnlyOffice uses the same Office Open XML core) |
| Cost | Free forever | Free (desktop version) |
If you are not sure, start with LibreOffice. It is already installed, takes nothing extra, and 9 out of 10 people stay with it. If you spend all day in Microsoft 365 and miss the ribbon, install OnlyOffice too. You can keep both, opening each file with whichever you prefer.
The three apps inside LibreOffice: what each one does
| The Microsoft app | The LibreOffice app | Files it opens and saves |
|---|---|---|
| Microsoft Word (documents) | LibreOffice Writer | .docx, .doc, .odt, .rtf |
| Microsoft Excel (spreadsheets) | LibreOffice Calc | .xlsx, .xls, .ods, .csv |
| Microsoft PowerPoint (slides) | LibreOffice Impress | .pptx, .ppt, .odp |
Bonus apps you also get for free (do not worry about them on day one): Draw for diagrams, Base for simple databases (like Access), Math for typesetting equations.
Open a Word document from email: the five-minute walk-through
Your colleague sends a file called Q1-report.docx and you are on Linux. Here is the full round-trip, start to finish.
Q1-report.docx. Double-click the attachment in Thunderbird — Linux opens it in LibreOffice Writer.Make LibreOffice save as Word by default: turn off the "Use Word?" pop-up
By default, LibreOffice nags you every time you save a Word document. Easy fix: Tools → Options → Load/Save → General. Three "Always save as" rows at the bottom of the panel:
- Text document → set to
Word 2007–365 (.docx) - Spreadsheet → set to
Excel 2007–365 (.xlsx) - Presentation → set to
PowerPoint 2007–365 (.pptx)
Click OK. From now on, Ctrl+S saves quietly in Microsoft format. No pop-up, no thinking. Your files round-trip exactly. (You can still pick .odt from Save As when you specifically want it.)
Why does it ask in the first place?
LibreOffice's own native format is .odt / .ods / .odp (Open Document, an international standard). It is a tiny bit safer for archival and shares perfectly between Linux/Mac/Windows people who all have LibreOffice. The downside: nobody else uses it. So most office workers set the default to Microsoft format and forget about it.
Spreadsheets: Calc opens Excel files with formulas and charts intact
LibreOffice Calc is the Excel replacement. Same grid of cells. Same column letters and row numbers. Same =SUM(A1:A10), =VLOOKUP, =IF, =COUNTIF, =AVERAGE. Calc speaks the exact same formula language as Excel. Open an .xlsx file and the formulas keep working, the charts keep drawing, the conditional formatting keeps highlighting.
| In Excel you press… | In Calc you press… | Result |
|---|---|---|
| F2 | F2 | Edit the current cell |
| Ctrl+Shift+L | Ctrl+Shift+L | Toggle autofilter on a table |
| Ctrl+1 | Ctrl+1 | Format Cells dialog |
| Alt+Enter (inside a cell) | Ctrl+Enter | Line break inside a cell. The only common shortcut that differs. |
| F9 | F9 | Recalculate |
| Ctrl+Page Down | Ctrl+Page Down | Switch to the next sheet tab |
One gotcha worth flagging: heavy Excel macros (the VBA scripting kind your accountant might use) sometimes do not translate cleanly. If your job depends on a complex .xlsm macro file, open it once on Linux to check it works before you commit. For 95% of spreadsheets (invoices, schedules, simple reports), no problem at all.
.xlsx file in Calc. The grid, the formulas (=SUM, =VLOOKUP, =IF), the conditional formatting and the charts all work — and round-trip back to .xlsx intact.Slideshows: Impress opens PowerPoint files
LibreOffice Impress is the PowerPoint replacement. Open a .pptx, the slides look the same. Click Slide Show (or press F5), the presentation runs full-screen with your speaker notes on the second monitor. Same outline view on the left, same slide thumbnails. Save back to .pptx and your colleague gets exactly the deck you built.
Two small "but"s: some PowerPoint animations do not translate one-to-one (the simple fade-in / fly-in ones work; the elaborate "morph" transitions sometimes simplify). And a handful of Microsoft-only fonts (e.g. Calibri Light, Cambria) are not on Linux by default. See the font tip below.
.pptx in Impress — slides, fonts, layout intact. Slide thumbnails on the left, speaker notes at the bottom, press F5 to present full-screen. Save back to .pptx and your colleague gets exactly the deck you built.Microsoft fonts: the one easy install that fixes most "looks different" complaints
If you open a Word document and the text reflows ever so slightly, it is almost always because Linux does not have the Microsoft font the doc was using (Calibri, Cambria, Arial, Times New Roman). Linux substitutes a similar free font, which is nearly the same width, but not quite, so a heading might wrap differently. The five-second fix:
Need the Microsoft 365 web apps? They work too.
If your company gives you a Microsoft 365 subscription, you can use the web versions of Word, Excel and PowerPoint on Linux. Go to office.com, sign in, click Word (or Excel or PowerPoint). Full-featured editing in the browser, same as on Windows. The only thing you cannot do in the browser is open files that are not already in your OneDrive (you would upload them first).
Tip: in Firefox or Chrome on Linux, right-click the tab and pick "Pin Tab". Word/Excel/PowerPoint live as pinned tabs the way they live as taskbar icons on Windows. Or "Install" the PWA (browser menu → "Install Office") to get a real dock icon.
PDFs: view, fill, sign, edit, combine
Almost every office document gets exported to PDF eventually: to send, to sign, to archive. On Linux, the everyday PDF actions are covered by a handful of small apps. Most are already installed.
| What you want to do | Linux app | Notes |
|---|---|---|
| Read a PDF | Document Viewer (Evince) | Pre-installed. Double-click any .pdf in Files; it opens. Same key shortcuts as Acrobat Reader: Ctrl+F search, Ctrl+P print. |
| Export ANY document to PDF | File → Export as PDF (in LibreOffice) or Ctrl+P → Print to File (in any app) | Built in. No extra software needed. |
| Annotate: highlight, sticky notes | Xournal++ | Install from App Centre (search “Xournal++”). Highlights, freehand notes, stamps. Saves back as PDF. |
| Fill in a PDF form | Firefox (built-in form filler) or Xournal++ | Drag the PDF into Firefox, fill it in, save back out. |
| Sign a PDF | Xournal++ → Insert image of signature | Take a photo of your signature on white paper, crop it, drop it onto the doc. Save as PDF. Done. |
| Combine / split / reorder pages | PDF Arranger | Install from App Centre (search “PDF Arranger”). Drag-and-drop pages between PDFs. |
| Edit text inside an existing PDF | LibreOffice Draw | Open the PDF in Draw (yes, Draw, not Writer). Most text becomes editable. Save back as PDF via Export. |
| Compress a big PDF | ps2pdf -dPDFSETTINGS=/ebook in.pdf out.pdf | Command-line one-liner. Cuts file size 50–80% on scan-heavy docs. |
.pdf in Files; it opens. Ctrl+F search, Ctrl+P print.Things that do NOT round-trip perfectly: the short, honest list
Being straight with you. For 95% of office work (letters, reports, school essays, invoices, simple spreadsheets, regular slide decks), no difference at all. The 5% that does not translate perfectly:
- Heavy VBA macros in
.xlsm/.docmfiles. Some basic ones run; complex ones do not. If your accounting workflow depends on a 2,000-line Excel macro, test it on Linux before you switch, or keep one Windows machine just for that file. - Fancy PowerPoint transitions (Morph, 3D, certain camera-zoom effects). Simple fades, wipes and fly-ins all work fine.
- Microsoft-only fonts not in the core-fonts pack. Most documents are fine after you install the fonts above. Some exotic corporate fonts may need to be manually copied across from your old Windows machine to
~/.fonts/. - Co-authoring with a colleague in real time in
.docxvia the desktop apps. For real-time co-edit, use the web version of Word atoffice.comin your browser, or Google Docs.
The safe rule: if your job depends on a specific super-complex Office file, open a copy of it on Linux before you commit to the switch. For everyone else (students, regular office workers, freelancers), LibreOffice and OnlyOffice handle every document you are likely to send or receive.