Question: how to copy data from one sheet to another in open office?
Answer: Then choose Edit > Sheet > Move/Copy. The option to Copy will already be marked and dimmed so you can't change it. Select the sheet after which you want the copies to appear. Click OK and you'll see the copies.