Open Office - Calc

[cKGunslinger]

Well, I decided to recreate some old MS Office spreadsheets of mine into Calc. Spent a few hours inputting and designing several worksheets, only to realize that the print options (orientation, margins, etc) seem to apply to the entire workbook, not to individual worksheets like in Office.

So, if I have a worksheet in portriat mode with tabular data, and another worksheet in landscape mode with a chart of that data, it seems I have to manually change the print options for each sheet before printing.

Someone tell me there is a way around this! :|


As much as I dog on MS sometimes, I have to admit that Excel is about 120% better than OO's Calc. Even Gnumeric seems to support this option..

I hope I'm just missing it..

 

[xSauronx]

so basically youre not happy that you have to adjust print options per worksheet? *shrug* office is better, thats no secret.
if you dont get help here, try this place or google for others:

http://plan-b-for-openoffice.org/calc/index

theres a printing section, but i have to go to work so i cant check it out and see if it has what you want, and while i do a spreadsheet in calc every now and again, its always simple and i rarely print them.

 

[cKGunslinger]

Originally posted by: xSauronx
so basically youre not happy that you have to adjust print options per worksheet? *shrug* office is better, thats no secret.
if you dont get help here, try this place or google for others:

http://plan-b-for-openoffice.org/calc/index

theres a printing section, but i have to go to work so i cant check it out and see if it has what you want, and while i do a spreadsheet in calc every now and again, its always simple and i rarely print them.

I don't think that I'm being "too particular." It's a pretty common spreadsheet occurance to have multiple worksheets in a file, each rotated and formatted differently. I was just more likely surprised that something I took for granted doesn't seem to be there. It's like finding out that, "oops, you can only add even numbers together, sum() doesn't work with odd values!"

But, since I'm having a hard time finding any references to this - even other complaints - maybe it's not quite as common as I thought.