Hi HS

This may not be the solution you were looking for but the way I sometimes deal with the disparity of how I want to use a spreadsheet and how I want it to print can easily be handled by adding another sheet that is set up the way you want it to look when it is printed with the data gained through links to the working sheet.

The great thing about doing this is that you don't need to muck around with hiding and unhiding columns you don't want printed and the formatting can be different to the working sheet if that is of benefit.

Works for me anyway

Neil


H.S. wrote:
Hello,

On OOo 2.4, I am trying to print only certain columns of a spreadsheet. For example, the data may be in columns A~H, but I want only columns A,B,C and F in the print out.

So far I have tried to define ranges and then select that range and print it. Doesn't quite work right, it just prints all adjacent columns first, then the next group of adjacent columns, etc. This method, however, seems to work in OOo 2.3.

I have also tried to select the columns I want printed and choosing to print the selection. That also doesn't seem to work. It appears as if OOo 2.4 is ignoring my selections altogether.

So I just ended up deleting the unwanted columns from a copy of the spreadsheet and then printing the whole spreadsheet -- I was pressed for time and it had to be done, one way or another. It worked, but it is not way it is supposed to.

So, what gives? What am I missing here? How do I go about printing only a selected number of columns in a spreadsheet such that they appear side by side on the printout?

thanks,
->HS


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to