Skip to content
FixItFoundryPublic

About

Microsoft 365 defaults, Simplified Ribbon, shortcuts, and spreadsheet tools for LibreOffice

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

10 Commits

Folders and files

Repository files navigation

Libre365

Shell scripts and configurations to set up LibreOffice to feel more like MS Office with similar defaults, fonts, and spreadsheet tools.

Features

  • Fonts: Downloads and installs Aptos, Calibri, Segoe UI, Cambria, and core Windows fonts to /usr/local/share/fonts/msfonts/.
  • Profile Defaults:
    • Default formats: .docx (Word 2010–365), .xlsx (Excel 2010–365), .pptx (PowerPoint 2007–365).
    • Silences non-ODF format warnings on save.
    • Enables Microsoft 365 Simplified Ribbon (TabbedCompact), small icons, and Colibre theme.
    • Sets default document font to Aptos.
  • Keyboard Shortcuts: Maps standard Microsoft Office shortcuts for Writer (Word), Calc (Excel), and Impress (PowerPoint).
  • Calc Pivot Automation: Native StarBasic module for Excel-style double-click drill-down (insertDrillDownSheet) and auto-refresh on source data changes.

Quick Start (One-Command Install)

Run the master installation script to set up fonts, Simplified Ribbon, MS Office shortcuts, and PivotTable defaults:

./install.sh

Manual / Modular Steps

To apply only configuration, shortcuts, and pivot defaults without checking fonts:

./scripts/apply-msoffice-config.sh

To install Microsoft fonts manually (system-wide or user-level):

sudo ./scripts/install-ms-fonts.sh

3. Calc Excel-Style Pivot Features & Shortcuts

In modern Excel, drill-down is the default New Pivot-Table Style Layout. In Calc, initial table creation imperatively unchecks "Enable drill to details". Trying to set the default as True is a known bug, since the False flag persists in LibreOffice's programming, and this is the best workaround I could set. Pressing Ctrl+Alt+E sets DrillDownOnDoubleClick = True, and I'll update if that bug is ever fixed.

Shortcut Action Description
Ctrl + Alt + E Enable Drill-Down Activates Excel-style double-click drill-down and auto-refresh on all PivotTables in the workbook.
Ctrl + Alt + D Drill Down Cell Immediately generates a new sheet with underlying detail rows for the active summary cell.
Alt + F5 Refresh Pivot Refreshes the selected PivotTable.
Ctrl + Shift + V Paste Plain Text Pastes unformatted text (available suite-wide in Writer, Calc, Impress).

Tests

./tests/test_libre365.sh

License and Disclaimer

  • Code is licensed under the MIT License.
  • Microsoft fonts remain the property of Microsoft Corporation and are downloaded for compatibility and personal productivity use.
  • Disclaimer: This project is an independent community open-source customization. It is not affiliated with, endorsed by, or sponsored by Microsoft Corporation or The Document Foundation.

About

Microsoft 365 defaults, Simplified Ribbon, shortcuts, and spreadsheet tools for LibreOffice

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages