Re: [libreoffice-users] use Calc rows as footer

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+unsubscribe@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