Make Spreadsheet Text Readable in LibreOffice Calc Dark Mode

If text disappears when LibreOffice Calc is in dark mode, first check whether the problem affects the whole sheet or only cells with custom formatting. The application theme controls Calc’s interface and document canvas; a cell can still have a fixed font color or fill saved in the spreadsheet. For a quick cell-level fix, select the affected range and set Font Color to Automatic, which LibreOffice documents as black on light backgrounds and white on dark backgrounds.

The menu paths below match LibreOffice 26.8 Help. Names and menu placement can vary slightly by operating system or interface layout.

Identify what is actually dark

Look at the sheet and the cells separately. The worksheet canvas is the area behind cells that have no fill. A cell fill is a background color stored as part of that cell’s formatting. Font color is the color stored for the cell’s contents. These settings can interact: dark text on a dark cell fill is difficult to read even when menus and toolbars look correct.

If the workbook is important, save a copy before changing many cells. Start with a small range so you can see whether the fix affects only the intended cells.

Choose the sheet appearance you want

To change LibreOffice’s overall appearance, open Tools > Options > LibreOffice > Appearance on Windows or Linux. On macOS, open LibreOffice > Preferences > LibreOffice > Appearance. In the LibreOffice Themes list, choose Automatic, Light, or Dark. Automatic follows the desktop environment’s theme; Light and Dark select the corresponding LibreOffice appearance.

To keep the dark menus but use a white sheet canvas, select Use white document background. LibreOffice describes this setting as overriding the theme’s document background color and setting it to white. It does not recolor the font or fill in cells that already have their own formatting. If a dark-filled cell still has dark text after changing this option, correct the cell formatting in Calc.

Make the affected cell text readable

1. Select only the cells whose contents are hard to see. To choose a rectangular range, click the first cell and drag to the last, or use the Name Box to enter a range such as B2:F20.
2. On the Formatting bar, open the arrow beside Font Color and choose Automatic. This is the best first test when the cells should adapt to light or dark backgrounds.
3. If Automatic is not suitable for the colors in your sheet, choose a deliberate high-contrast font color. For a dark fill, use a light text color; for a light fill, use a dark text color. Avoid medium gray text on charcoal cells.
4. For precise settings, open Format > Cells, then use the font or font-effects controls to set the font color. The same dialog lets you inspect the cell’s background fill. Apply a new fill only if you want to change the cell background itself.

LibreOffice documents Automatic font color as black against light backgrounds and white against dark backgrounds. A fixed color may be appropriate for a carefully designed template, but it will not adapt as well if users change cell fills or switch between light and dark backgrounds.

Check styles and conditional formatting

If the text becomes unreadable again when a value changes, a conditional format may be applying a cell style. Conditional formatting is a rule that changes a cell’s style when its contents meet a condition; LibreOffice says the resulting style overrides formatting applied manually through the toolbar or Styles sidebar.

Select an affected cell and choose Format > Conditional > Manage. Review the rules covering that cell, then edit the rule or its associated cell style so both the font and fill have adequate contrast. If the same issue affects every cell using one named style, edit that cell style through Styles > Manage Styles rather than changing each cell individually.

Use Format > Clear Direct Formatting only when the cell’s manual formatting is accidental and can be removed. This command clears direct formatting, which may include more than the font color; it can also remove intentional emphasis or other cell formatting. If you need to preserve the fill, number format, or borders, set the font color directly instead.

Verify the fix

• Check several cells with both dark and light fills, including headings, numbers, and formulas.
• If conditional formatting is used, change a test value so the rule activates and confirm the text remains legible.
• Switch temporarily between Dark and Light appearance, or reopen the workbook, to see whether the text color behaves as intended.
• Use Print Preview if the sheet will be printed. The screen theme is an interface preference; it does not replace checking the spreadsheet’s actual cell colors on the printed page.

For the current options and formatting details, see LibreOffice’s Appearance settings help, Calc Formatting bar documentation, and Manage Conditional Formatting help.