I am trying to add a watermark to a three-page report from CALC. This was fairly easy to do in EXCEL but the “imported” EXCEL file no longer shows the watermark when opened in CALC. I have beat my brains out trying to figure out how to do this, I am sure it can be done. Please advise.
file no longer shows the watermark
Doesn’t it show at all? Even in print preview?
Shows up nowhere, not even in print preview. I am OK to add it , but don’t know how.
Try Format / Page / Background / Bitmap / Add/Import
Yup. Watermark created in Excel 2010 disappears completely on opening in Calc 7.0.6.2, Win 10 20H2
Create your watermark. So in Draw or Writer insert a Text Box and write some big text, 120pt at 40% grey or thereabouts. Right-click the Text Box and select Rotate, rotate text box to desired angle.
With text box selected, click *File > Export. In the dialog select PNG as type (try with SVG for better scaling) and tick the box Selection, enter a name and OK. A new dialog will open select a resolution (dpi) first, then a physical size, OK. You now have a png of your watermark; so far just like Excel 2010.
Click Format > Page, select the Background tab and click Bitmap. The pane will change a little, click the Add/Import button and select the image you made earlier. Under Style select Custom size/position, choose your height, width, and position then OK. Click File > Print Preview to check layout.
NOTE: Export to pdf gives a different size watermark but there is a possibility for a different watermark in export to pdf. Also see tdf#75261 for another issue, also tdf#54053
Alternative:
Insert the image on each “page” of your print area and make transparency 50% or to suit
Cheers, Al