Re: [libreoffice-users] Re: FEATURE REQUEST: CALC -- Repeating a Table Header on a New Page

Harold,

Thanks for the information.

You would not credit it but I did double check the help prior to 
posting. The problem was I searched on row headers, insert headers, 
etcetera. Searching for "repeating rows and columns" did not come 
immediately to mind.

I also scoured the menus of Calc to see if the functionality could be 
found easily. Again I did not expect to see this in the print range 
dialog so missed it all together.

No matter. I am a happy man now, it's rare to get a feature request 
addressed so quickly :).

Cheers Simon

   Simon Cropper
   Principal Consultant
   Botanicus Australia Pty Ltd
   PO Box 160, Sunshine, VIC
   W: www.botanicusaustralia.com.au

On 17/02/11 19:44, Harold Fuchs wrote:
> "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 ===

--
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 ***