Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


See below for replies ... 




________________________________
From: Harold Fuchs <hwfa.libreoffice@gmail.com>
To: users@libreoffice.org
Sent: Thu, 17 February, 2011 8:44:57
Subject: [libreoffice-users] Re: FEATURE REQUEST: CALC -- Repeating a Table 
Header on a New Page


"Simon Cropper" <scropper@botanicusaustralia.com.au> wrote in message 
news:4D5C7B04.2010903@botanicusaustralia.com.au...

Hi,

Writer has the ability so define a number of rows at the top of a table that 
will repeat if the table extends over the page.

http://help.libreoffice.org/Writer/Repeating_a_Table_Header_on_a_New_Page

This sort of functionality would be great in Calc. At present it is necessary 
to manually manipulate the sheet to put a header at the top of each page.

Even if the process is not dynamic as for writer. It would be good if a tool 
could be created that automatically moved the headers to the right spot (~ 
automatic cut and paste based on page size).

Assuming a square table a designated number of rows at the top of the table 
could be tagged as header rows by the user. These could then be propagated down 
the matrix and inserted at the top of where the current page break occurs. These 
duplicate headers are also marked as headers but also that they are duplicates. 
If the page size changes and the tool run again the duplicate headers are 
removed and the process repeated.

This sort of routine would save considerable time manipulating quite sizable 
tables that can extend over many pages.


<snip>

From Calc's Help pages under "Headings>Repeating rows/columns as"
=== begin quote ===
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 dialogue box 
appears.
2. Click the icon at the far right of the Rows to repeat area.
The dialogue box 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 shrunken dialogue box 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 dialogue box 
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.
=== end quote ===

-- Harold Fuchs
London, England



-- Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***


Ahah, i thought this question ambiguous.  It could be about 
1. Printing (neatly solved by Harold Fuchs and something i didn't know.  Excel 
does this in "Page Set-up")
2. Onscreen

For Onscreen just click on any cell then go up to the menus and click on 

Window - Freeze

Then try scrolling up&down or side-to-side to see the effect.  Then unfreeze and 
set the freeze corner exactly where you need it.

Good luck and regards from
Tom :)



      
-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.