I'm just a user of this software, as are most of the others who respond
to questions on the [email protected] mailing list -- all the
discussion really should be carried out there, so the whole community
can help. I'll post this back out there. You might want to consider
subscribing to the list, so you'll see all the answers. To do that, send
an e-mail (no subject or content is needed) to
[EMAIL PROTECTED], then respond to the confirmation e-mail
you'll get. This is a really busy list, so you'll get lots of mail as
long as you're subscribed, but I've found it very valuable.
It would help if you described exactly what you are doing to try to set
the print range, and what version of what OS you're using. When I tried
this on my WinXP system, with OOo 2.3.1, it worked fine. Are you seeing
the dialog boxes described here? From Format > Print Ranges > Edit, you
should see a dialog that lets you select what part of the sheet you want
to print (for instance, whole sheet), which rows to repeat, and which
columns to repeat. When you click the icon to the far right of the part
about repeating rows, a dialog with one line should appear, and if you
then click in cell A1 this should now show $1. Accept that by clicking
the icon at the far right (not by closing the dialog), and the original
dialog should reappear with the $1 showing in the user-defined area.
Select OK, and you should be able to print with the first row repeating
at the top of each page, which should do the trick if your headings
start in cell A1.
If this is not what happens, please describe exactly what you are doing
and what happens instead.
As for the freezing you described, it sounds as if maybe it's busy
writing the recovery information to be used if OOo crashes while you're
working. Why that would take so long is a question I can't answer, but
the behavior is controlled through Tools > Options, under Load/Save -
General - Save AutoRecovery information every 15 minutes. (This is the
default, I think.)
Jithendra Rao wrote:
Dear Barbara,
This Option does not works I tried it.
I think There is a Bug in Open Office Calc.
Kindly look into this matter in Open Office version 2.3.1.
I had created a table which is of 5 pages but I wanted the heading of
the columns to be printed on each page. Even using the Option which
you have said, It does not work, infact it should have worked. Kindly
notify this Bug to Other Programmers so that this can be solved in the
next release of Open Office 2.4 stated in march 2008.
There is also another Bug in Open Office i.e when I am working on a
table , the entire application gets stuck for a period of 1 min every
15 min.
Kindly look into this also.
Thanking you,
Jithendra
On 1/10/08, Barbara Duprey <[EMAIL PROTECTED]> wrote:
Sorry: I missed that part of the subject line, and didn't think about
Calc because as far as I know it doesn't really have a concept of
"Tables." I'm not as familiar with Calc, but here's something from its
built-in Help that may be what you're after:
Printing Rows or Columns on Every Page
If you have a sheet that is so large that it will be printed multiple
pages, you can set up rows or columns to repeat on each printed page.
As an example, If you want to print the top two rows of the sheet as
well as the first column (A)on all pages, do the following:
1.
Choose *Format - Print Ranges - Edit*. The *Edit Print Ranges*
dialog appears.
2.
Click the icon at the far right of the *Rows to repeat* area.
The dialog shrinks so that you can see more of the sheet.
3.
Select the first two rows and, for this example, click cell A1 and
drag to A2.
In the shrunk dialog you will see $1:$2. Rows 1 and 2 are now rows
to repeat.
4.
Click the icon at the far right of the *Rows to repeat* area. The
dialog is restored again.
5.
If you also want column A as a column to repeat, click the icon at
the far right of the *Columns to repeat* area.
6.
Click column A (not in the column header).
7.
Click the icon again at the far right of the *Columns to repeat* area.
Rows to repeat are rows from the sheet. You can define headers and
footers to be printed on each print page independently of this in
*Format - Page*.
Jithendra Rao wrote:
Madam,
This is correct when it comes to OpenOffice Writer. What about in
OpenOffice Calc?
Regards
Jithendra
On Jan 10, 2008 2:15 AM, Barbara Duprey <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Jithendra Rao wrote:
> Dear Sir / Madam,
>
> I am using 2.3.1 version of OpenOffice.org. My problem is I want
to know how
> to add table headings to the second page. i.e If in the first
page there is
> column heading of the table like quanity, price, extended price,
I want it
> to be shown even in the second page if the table is continued.
Kindly let me
> know how to do this..
>
> Thanks for the last Advice on Writing Two Sentences in a single
Cell.
>
> Regards
>
> Jithendra
>
>
Right click in a cell of the table, select Table, then the Text Flow
tab. There is an option called "Repeat heading" that should do
what you
want.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
