Re: Calc rows as footer

[Keith Bainbridge <ke...@gmail.com>]

Thanks Brian,  and my apologies for my late response.

I did mean the equivalent of the repeat these rows at the top, but it would
be more convenient to have some rows at top, and some at bottom.

I have to re-sort the list regularly, so the copy/paste suggestion sounds
best.

Again, thanks for your time.

I've also found a gotcha in my mail filteringcausing me to miss your
reply.  And I'd been wondering why a couple of things seemed awry.  Next
problem to solve.


Keith Bainbridge

0447667468

keithrbaugroups@gmail.com

Sent from my APad
On 21 Jan 2016 7:38 pm, "Brian Barker" <b....@btinternet.com> wrote:

> At 08:07 21/01/2016 +1100, Keith Bainbridge wrote:
>
>> I am trying to use 4 rows on a calc sheet as a footer, in addition to a
>> header row. Can only see how to use rows as a header. Any hints please?
>>
>
> I don't think you can use spreadsheet rows in a header or a footer:
> strictly, what you describe here is a heading rather than a header.
>
> A couple of workarounds:
>
> o Repeat the necessary rows in your spreadsheet, so that they appear in
> all the correct places. If desired, insert manual page breaks to control
> what happens. Don't enter the data or formulae for your repeated rows
> multiple times; instead, insert references to a first instance. This will
> maintain reliability as you edit the spreadsheet.
>
> o Maintain your spreadsheet as before. Copy and paste material from it
> into a header and a footer as well as the main text of a text (Writer)
> document. In each case, use Paste Special and choose "DDE link". Your
> spreadsheet material will become a table in the text document and it will
> be updated as you edit the source spreadsheet.
>
> I trust this helps.
>
> Brian Barker
>
>