Hey there — we can definitely help with your LibreOffice Calc grid prints broken problem. In Calc it’s very common to see a sheet that looks fine on screen, but when you print or export to PDF the gridlines disappear, some cell borders don’t print, or certain border styles come out broken or incomplete.

Most of the time it’s a mix of three things: the difference between gridlines vs. real cell borders, the Page Style ▸ Sheet ▸ Print options, and a known Calc cell border style bug that affects very thin or custom line styles. We’ll walk through all three so you get a clean, consistent grid on paper.

To narrow it down: when you say the Calc grid prints broken, does it happen on every page or only in some areas of the sheet? And are you mainly missing automatic gridlines or manually applied borders around specific cells or tables?

Got it, that’s a classic LibreOffice Calc cell borders not printing scenario. Two important points:

1) Gridlines are just a visual aid. By default, Calc shows a light grid so you can see the cells, but that grid doesn’t always print. Real printed lines come from the Borders settings on the cells, not from the on-screen grid.
2) There’s a known Calc border style bug where very thin or mixed border styles look fine on screen but don’t render correctly in print preview or on the physical printer — especially when combined with certain zoom levels, scaling, or printer drivers.

When you see a broken grid on paper, it’s usually because some cells rely on the default grid instead of real borders, the Page Style ▸ Sheet ▸ Print ▸ Grid option is off or interacts badly with borders, or a buggy border style / width combination is used so Calc drops or merges lines during printing.

We’ll convert the important areas to solid borders with reliable thickness, adjust the Sheet ▸ Print options, and work around the border style bug so the grid prints correctly every time.

Yes, that combination is a usual trigger. Some printers and PDF exports struggle with very thin “hairline” borders or mixes of dashed and solid styles, so lines get merged, dropped, or look jagged. Here’s a reliable workaround when LibreOffice Calc grid prints broken:

1) Select the full table area you need to print (for example A1:H40).
2) Go to Format ▸ Cells ▸ Borders.
3) Under Line, pick a simple solid style and a medium width (not the thinnest option). A common safe choice is a standard solid line at about 0.50pt.
4) Click the preset for “Set All Borders and Inner Lines” so every visible grid line in that range is a real border, not just the default grid.
5) Apply and then check Print Preview again at 100% zoom — no scaling.

If your printer driver or PDF engine had issues with the original cell border style, forcing everything to a consistent, medium-thickness solid line usually fixes the cell border style bug and makes the Calc gridlines print properly.

Absolutely — the Page Style settings matter a lot. Calc has separate switches for the visual grid and printed borders. Here’s how to make sure the sheet is allowed to print all lines:

1) Click anywhere in the table, then choose Format ▸ Page Style (in older versions, Format ▸ Page).
2) Go to the Sheet tab.
3) In the Print section, make sure Grid is checked only if you really need the default gridlines. Otherwise, rely on your cell borders for a cleaner result.
4) While you’re there, confirm the paper size and orientation are correct so Calc doesn’t try to compress the grid and drop lines at the margins.

If the Calc grid prints broken or incomplete, I usually recommend turning Grid printing off for complex tables so you don’t mix visual gridlines with real borders, using cell borders only for the ranges that must be printed, and setting a safe border style on the entire range so no line depends on the buggy border style settings.

Once that’s done, print a small test range instead of the whole sheet to quickly see if the Calc border style bug is effectively bypassed.

Good observation. With LibreOffice Calc gridlines not printing it’s common to have a double interaction: Calc renders the PDF, then your PDF viewer and printer driver apply their own scaling.

Here’s what often happens: Calc draws ultra-thin borders that look okay on screen but are right on the edge of what the printer can render; the PDF viewer (Adobe Reader, browser, etc.) shrinks or scales the page to “fit” margins; as a result, some lines fall between physical pixels and the printer drops them, so the grid looks broken even if the PDF looks fine.

Quick test:
1) In Calc, use the solid, medium-thickness borders we discussed, then File ▸ Print directly to the printer (no PDF in between) with scale at 100%.
2) Compare that print to File ▸ Export as PDF, open the PDF, and print with “Actual size / 100%” in your viewer.

If the direct Calc print looks better, it means the PDF pipeline plus driver scaling is exaggerating the border style bug. In that case, stick to direct printing for critical sheets, or enforce “Actual size” in the PDF viewer and avoid extra scaling.

Yes, both the LibreOffice version and the printer driver can change how gridlines and borders print. Some releases fix specific Calc border style bugs while others still have regressions — and the Windows print driver stack behaves differently from CUPS on Linux.

To reduce surprises between machines, make sure both systems run a current, stable LibreOffice release, on Windows install the latest driver from the printer manufacturer instead of the generic “Class” driver, and in the document itself avoid exotic border styles that are known to be fragile; stick to solid, medium thickness borders for the main grid.

Once you standardize both the LibreOffice version and border styles, the same sheet is far less likely to have Calc grid printing issues when you move it between Windows and Linux.

Totally fair — we can keep the sheet recognizable and still fix the broken Calc grid. Here’s a minimal-impact approach I use for clients:

1) Identify the print area: select only the range you actually print and consider defining it via Format ▸ Print Ranges ▸ Define so Calc focuses on that zone.

2) Normalize the borders just in that range: apply a safe border style (solid, medium width) to all inner and outer lines of that print range. You can still use thicker borders to highlight header rows or totals, but avoid ultra-thin hairlines.

3) Keep the “design” extras on screen only: if you like decorative dashed borders or special patterns, you can keep them for areas that won’t be printed or export an “on-screen” version separately.

That way, you preserve the overall layout but ensure the part that goes to paper is optimized to avoid the LibreOffice Calc cell border style bug that causes missing or broken lines.

Yes — great idea. Once you’ve got a sheet where the LibreOffice Calc grid prints correctly, you can capture that setup and reuse it:

• Cell Styles: create a style like “Printable Table” with your safe border style and apply it to tables in other documents.
• Page Style: save a page style with the correct Sheet ▸ Print settings (grid on/off, print range, orientation).
• Template: save a working file as a Calc template. New spreadsheets based on that template will start with grid and border settings that don’t trigger the border style bug.

Doing this once means future sheets are much less likely to hit the “LibreOffice Calc grid prints broken” issue again, because they share the same, battle-tested configuration.

Absolutely — here’s the short playbook for LibreOffice Calc grid prints broken and cell border style bug issues:

1) Select the actual print area and apply real cell borders (not just the default grid).
2) In Format ▸ Cells ▸ Borders, use a solid, medium-thickness line for inner and outer borders — avoid ultra-thin or fancy dashes for critical gridlines.
3) In Format ▸ Page Style ▸ Sheet ▸ Print, decide whether you really need the Grid option; for most reports, rely on borders only.
4) Print a small test at 100% scale (no “fit to page”) and compare print preview vs. paper.
5) If the PDF route still breaks lines, print directly from Calc or ensure your PDF viewer uses “Actual size / 100%”.

Summary: when a LibreOffice Calc grid prints broken or cell borders vanish, fix the border styles, widths, and page settings — not the data. If you want, open the chat and an expert will walk through your exact Calc file and printer step by step.