OpenOffice Copy/Move Sheet related

[acleaver]

I am using windows 7 and Open Office 3.4.1 . I want to simple copy a spreadsheet within a Calc document. I used Move/Copy sheet function successfully but the copied sheet has changed its size so it no longer fits on one screen. Font and font size remain the same. What have I done wrong please???

[MichaelZZ]

When you prepared your original spreadsheet did you change any of the column widths or other formatting?
When you copy your data to a new part of the spreadsheet the columns etc will be in the default format and have a width of 2.24cm (I think).
For more information go to
Help | Defaults | Program Configuration and the go to the adjacent screen and click on OpenOffice.org Calc to see all your options.

[JessicaEldridge]

You should have to use paste special option at the time of pasting copied spreadsheet because this option allows you to copy the content as it. Its different option like formulas, values, formats, comments and validations offers you how you want to copy content with.