(Fedora-34, Gnome, LibreOffice 7.1.8.1, HP LaserJet Pro MFP M180nw)
I have a LibreOffice Calc spreadsheet. It has a chart. On my workstation monitor, the chart looks as I desire: border, x and y axes, legend, axis labels, data curves, tick marks along the axes, and a grid in the plot area. When I print the chart to a PDF file and then display the PDF file, it look the same as in LibreOffice Calc. But, when in LibreOffice Calc, I print to the printer, there are no axes and no grid lines. How do I get the axes and grid lines to show?
And what about the line widths?
Please upload a sample file here.
I could not find a way to control grid line style, width, or color. So the width should be whatever the default is.
The actual Calc file is attached.
ancestors.ods (105.1 KB)
The chart is in the “sorted_full” sheet, starting in row 247, column H.
The PDF file generated by printing the chart to a file may be viewed on the goggle drive here:
“ancestors.pdf - Google Drive”.
The Line Widths have zero values for the Axes and for the grid lines in your sample file. Try to modify them.
Double click on the Chart, and then double click on an axis: Line - Width (and color)
For the Grid lines: double click on a vertical grid line: x-Axis major Grid - Line Width (and color);
double click on a horizontal grid line: y-Axis major Grid - Line Width (and color)
That worked. Thank-you.
But I’m still puzzled:
Before those edits, the axes and grid lines did show up in the PDF file. Why? The lines should either show up both in the PDF file and the printout, or in neither the PDF file nor the printout.
I suppose that the line widths will be converted with a default (non-zero) values into the PDF format. But the real printing try the print the “near zero” width lines, and the printer resulution is not enough to appeare the lines.
But the screen’s resolution is coarser than the printer’s resolution.
…by quite a bit.
…at best 100 pixels per inch for the screen, at worst 600 dots per inch for the printer.
Well, the real problem is solved. Thank-you for your help.
I wish you a great new year 2022.
This past Thursday (02/03/2022) I further adjusted the grid lines down to a thickness of 0.01 inch, and the color to light gray (decimal RGB = (191,191,191)). The resulting printed graph is excellent. Thank-you!