Re: [libreoffice-users] page subtotals

Hi :)
You can set-up various things in the "Header" and/or "Footer" sections of
all pages.  Such things as the;
*  path-name and/or file-name
*  today's date (the day of printing)
*  page of pages (ie page 1 of 50 or whatever)

I'm not sure if Calc allows some pages to be different by using "Sections"
but i get the feeling you are trying to keep it much simpler than that for
now! ;)

However i am not sure if you can include the types of formulas you use
inside the spreadsheet.  It might be possible but i have never had any
reason to try.

Once you try a "Print Preview" you might notice that page-sized areas of
the spreadsheet are surrounded by "marching ants" or a slightly
darker/thicker lines or (if you are lucky) by different colour lines.  This
can help you work out the divisions between pages.  I often change the
width of quite a lot of the cells (usually entire columns but sometimes
rows too) to help with layout.


On a side-issue = Sorry about messages going off-list!

This mailing list is set-up to make it trickier to keep replies on-list so
messages often go off-list quit by accident.  Unlike most mailing lists we
have to keep remembering to use "Reply to all" or "Group reply" or "Reply
to list", depending on whixh option our different emailers give.  Almost
all have the "Reply to all" but some have more elegant options in addition
to that.  So, sorry the previous reply went off-list.

Another peculiarity about this mailing list is that a lot of people use
bottom-posting rather than the top-posting so prevalent in the world
today.  The reason we use both, and interspersed replies is to help prepare
people for other mailing lists.  Many mailing lists insist on
bottom-posting despite that being completely unfamiliar to any office
worker i've ever met or dealt with outside of OpenSource projects.  In many
ways bottom-posting does make a LOT more sense but sadly almost the entire
world is set-up to top-post these days.

So this mailing list attempts to help ease people into the OpenSource world
by allowing top, bottom and interspersed replies.  So if you appear to get
a blank reply with nothing in it then try scrolling down to the bottom.
Actually bottom-posters tend to "trim" replies so scrolling becomes less of
an issue but by doing so they sometimes/often remove context that may have
been crucial to understanding previous posts.

Regards from
Tom :)







On 25 September 2015 at 13:21, Dave Howorth <dhoworth@mrc-lmb.cam.ac.uk>
wrote:

> Thanks for that. It's actually the whole problem I need help with.
>
> Starting with how do I print a page subtotal?
>
> And then how do I print some calculated data at the top of a page?
>
> Please keep replies on-list.
>
> Thanks, Dave
>
> Wade Smart wrote:
> > --
> > Registered Linux User: #480675
> > Registered Linux Machine: #408606
> > Linux since June 2005
> >
> >
> > On Fri, Sep 25, 2015 at 6:20 AM, Dave Howorth
> > <dhoworth@mrc-lmb.cam.ac.uk> 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?
> > >
> > > Thanks, Dave
> > >
> > > --
> > > 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
> > In the cell at the top of the next to-print page put =Ax  so you are
> > referencing the
> > cell that has the subtotal. A is the column name and x is the line number
>
>
> --
> 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

-- 
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