Using bash script to do open calc operations?

I am trying to create a bash script to do something very mechanical on open office calc. I have a big spreadsheet that will do calculations on aircraft sizing for me. I need to go through many different iterations of calculations and copy a row of those calculations to another area on that same spreadsheet. Like this is just a lot of copying and pasting for me, I thought I could do this much more efficiently if I could just write a script to do this. I am not very familiar with bash scripting yet. I need help.

Basically all I know how to do is to open my excel sheet with the assosciated open calc. can someone please point my in the right direction?

Not sure about bash. Sounds more like a task for python with python-xlwt package.

OpenOffice.org/LibreOffice supports Python as its macro language.
http://wiki.openoffice.org/wiki/Pyth...macro_language