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]