Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

OpenOffice Calc Page Styles / Scaling

  • Please log in to reply




  • Member
  • PipPip
  • 35 posts
Hello, I need help doing something in OpenOffice Calc.

I have several hundred sheets in four files. Let's just focus on a single file right now. The problem is that I have a hundred sheets in the project file and I want to change the page style for all of them at once.

I have created the sheets individually. I didn't know when I was creating them that OpenOffice would create a different page style for each sheet by default. Now the problem is that the scaling is the wrong size. I had been counting on it to fit the print range (all non-empty cells) into one page per sheet.

I can change the scaling on each individual page, but I have to do it one at a time. One way to change the scaling is to edit the page style. However, I can only do THAT one page at a time.

If I edit the page style of the first sheet, I can apply that corrected page style to OTHER sheets too. But I can't figure out how to apply it to every sheet in the project at once.

Can anyone help me? I'm going to be working on this all evening until I figure out a way to get it to print right. I will be printing it to PDF so I can email the file to a copy shop. Right now it's in XLS format for compatibility, but I am indeed using OpenOffice Calc. Thanks. :)
  • 0


Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP