At 12:20 25/09/2015 +0100, Dave Howorth wrote:
I have a spreadsheet that I need to print and send to the
government. When I print it, I need to print a page subtotal and
also repeat that subtotal at the top of the next page. Is there some
way to do this apart from doing it all by hand?
I don't think this problem is very well defined!
As has already been hinted at by another responder, the first
question is: is the number of items on each page fixed (whether or
not the same)? If you want to be able to add entries or expand them -
such as would spill items over to following pages - then I think the
problem is quite difficult, but it may be easier if, for example, you
need only to add material at the end of your data.
And do you really mean a page subtotal, i.e. the total for that page
alone? If so, I can't see any point in repeating this on the next
page. How, for example, would it be of any help to have the total for
page two copied at the top of page three, without any account being
taken of the values on page one? Why would page seventeen need to
have information just about page sixteen and not the previous fifteen
pages? Do you instead perhaps require a running total to appear (as
"carried forward") at the bottom of each page and the same value to
appear (as "brought forward") at the top of the next?
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
Context
- Re: [libreoffice-users] Clean up/optimize/canonicalize a .odt file (continued)
Re: [libreoffice-users] page subtotals · Brian Barker
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.