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

At 08:06 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

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.