Open Office Calc - Insert backgrounds, bullets or other object

April 2018

Under Calc all the themes, background, bullet are regrouped in the "Gallery".
  • Simply click on the the Gallery button to access the different options

To add an any of these items (e.g adding a ruler):
  • Select the starting cell
  • Click on the Ruler tab in the Gallery
  • Choose the one you seems appropriate
  • Right-Click on it > Insert>Copy

  • It shall be automatically be inserted
Published by jad05. Latest update on January 10, 2011 at 10:11 AM by jad05.
This document, titled "Open Office Calc - Insert backgrounds, bullets or other object," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
OpenOffice Calc - Protect your spreadsheet with a password
Open Office Calc - Adding borders to the cells