Pasting in Calc

[firetrain2]

I am trying to find out how to copy from one sheet to another in CALC and include the column widths and row heights.
If this can be done, is it possible to copy data, widths and heights to multiple sheets at once?

[mgroenescheij]

Hi,

You can copy data to multiple sheets when you select these sheets.
You select sheets by holding the Control down and click on the sheet tabs.
While multiple sheets are selected you could drag the width of the Column and Height of the rows, but copy only copies data and formulas.
Be aware that it is not visible which sheets you have selected hence it is could create more problems than it solved.
Don't forget to click on a single sheet when done.

Martin
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).

[qaz1qaz1qa]

if you select the tab you want as the templet and right click it the option to Move/copy comes up in the shell menu.
choose it and make sure you tick the COPY option at the bottom.
The newly created tab will then have all the data and have all the columns and rows set as well. a perfect copy except for the name

[firetrain2]

Thanks mgroenescheij,
Your suggestion worked very well.