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

Ahah, at last.  Thanks for helping rather than blaming.  This type of answer is 
one of the perfect ways of handling the problem.  It is the type of thing that 
make LO great.  


Unfortunately it shows that bottom posting involves more work than most office 
workers are prepared to do and if we demand that they do all this then they will 
often consider it easier to reinstall MS Office rather than deal with this.  I 
know that is ridiculous.  Mostly they wont have un-installed MS Office so there 
is even less reason for them to stay with LO.

Regards from
Tom :)





________________________________
From: Charles Marcus <CMarcus@Media-Brokers.com>
To: users@libreoffice.org
Sent: Thu, 17 February, 2011 12:01:41
Subject: Re: [libreoffice-users] Re: FEATURE REQUEST: CALC -- Repeating a Table 
Header on a New Page

Hi Tom,

First of all, thank you very much for trying to abide by the list
guidelines wrt inline-posting... and yes, I'm top-posting this for a
reason - sometimes top-posting is ok... ;)

One thing you are forgetting, which is now making your replies very
painful to discern/read, is to snip/trim/cut any unnecessary and/or
irrelevant content in the quoted text... hint: you *never* want to quote
the entire message, since that would include list footers, people's
signatures, etc, etc. Usually only a sentence or small paragraph is
enough to preserve context...

Also, you are apparently using the Yahoo Webmail client, which doesn't
seem to use the standard quote character '>' for showing quotes in plain
text emails... this is too bad, because it makes inline-posting
extremely easy, both for composing and reading/comprehension. There are
plenty of examples of how clean/neat these replies can/should be from
myself and others who have been discussing this in the bottom vs top
posting thread...

You might consider using a real mail client, like Thunderbird, that
handles quotes properly and easily - in Thunderbird, if you
highlight/select some text before clicking reply, *only* that text is
included in the quoted text in your reply... I use this feature all the
time...

But regardless, at a minimum you should always endeavor to delete any
unnecessary quoted text, leaving only enough to show context... in this
case, your reply could/should have looked something like:

***************** Begin example

On 2011-02-17 4:11 AM, Tom Davies wrote:

<snip>

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.

-- Harold Fuchs
London, England
=== end quote ===

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.

Regards from
Tom :)

***************** End example

instead of the mess (no offense) below, which I'm intentionally quoting
in it's entirety below so you can compare...

Last hint: bottom posting + 'mindlessly quoting the entire message' is
far worse than top-posting... most people who argue against
bottom/inline posting do so while failing to recognize the need to trim
the quoted text...

On 2011-02-17 4:11 AM, Tom Davies wrote:
> 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 :)

-- 

Best regards,

Charles

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



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