On 07/05/10 00:42, James E. Lang 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.
Hi James
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.
OK James
Setting it up by the Format-Print Ranges-Define as before, I could then
go to Format-Print Ranges-Edit and set the "rows to repeat" to
"user-defined" then put in $1 and the header row was repeated on the
Page Preview. Likewise Column to repeat as $A and it repeats.
Installing generic OOo IIRC was just a matter of downloading the
tarball, untar it, then do a sudo dpkg -i *.deb in the appropriate
directory, then cd to the "desktop-integration" directory and repeat.
Does that help?
Russell
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
