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: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted