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 [email protected] Sent from my APad On 21 Jan 2016 7:38 pm, "Brian Barker" <[email protected]> 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 > >
