Jerry left a comment saying that he had trouble with the following:
“cannot find how to show/hide themes in calc”
I’m not sure if this is exactly what you mean, but some refer to the Gallery in OpenOffice as ‘themes’. (Please leave a comment below if this is not what you meant.)
To show and hide the Gallery (in Calc, Writer or Impress) simply select the following in the menu: Tools >> Gallery
Keep the questions coming – I currently have a bit of a backlog, but will continue to work through the answers.