--On Thursday, May 06, 2010 07:42:01 AM -0700 "James E. Lang" <[email protected]> wrote:

--On Thursday, May 06, 2010 06:29:58 PM +1000 Russell Butler
<[email protected]> wrote:

On 06/05/10 14:47, James E. Lang wrote:
Further follow-up:

I have tried the pure keyboard method for defining the print ranges and
the repeated rows and columns that I want. I have also tried the "select
and click" technique as described in the OOo Help. They produce
identical results on the Ubuntu version of OOo 3.2.

I guess it could be that nobody else on this list uses print ranges but
I rather doubt that to be true and I doubt that it is all that unusual
to want one or more rows and/or one or more columns to be repeated on
every page.

Is there anyone who has made this work on any recent Linux version of
OOo? If so, I need help finding that version and installing it properly
on my Kubuntu 10.04 system. I would prefer a distribution neutral
version 3.2 of OOo.

Since OOo is open source, I suppose I could compile my own from source
code but I don't want to. I would have to obtain the source code, make
sure I have the needed tools to Make OOo, actually perform the Make, and
finally figure out what files to install where to install them. Then I
would have a version that nobody would trust if I report any future
troubles.

As no one else has responded, I have 3.2 (320 M12) on ubuntu 9.04 AMD-64
This is the generic OOo. I am by no means an expert.

Opening a spreadsheet, I found I could select a range by clicking in a column
at the right end of the range and at the bottom row I wanted to select, then
swiping the mouse across to A1, I could then do Format-Print Ranges-Define
and it showed the correct area when I went to Print Preview.

I could also then Format-Print Ranges-Edit and the cell references were shown
there.

Thank you Russell for your response. The only problem with it is that you did
not discuss the part that is really the problem -- "Rows to repeat" and/or
"Columns to repeat." Please try that part and reply back. Then if that works
I want to know how to install the generic OOo properly.

_Temporary_ work around (aka kludge): I saved the file to a thumb drive and safely removed it(*). I plugged the thumb drive into the Windows machine and opened the file in OOo 3.2 there, made my print range changes, saved the file back to the thumb drive, and safely removed it(*) again. I finally plugged the thumb drive back into the Kubuntu system, opened the file in OOo 3.2 there, and saved it back over the original on my hard drive. OOo honored the settings that I had made on the Windows system. This is a very dirty way to do things but it worked. I still want a version of OOo 3.2 that works right on my Linux system.

(*) Safely removing the thumb drive involves also closing the file from Calc.

--
Jim


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to