On 7-12-2014 17:47, Mark Eaton wrote:
Thank you for your help Martin,
I would like to continue with the report being all on one sheet. In
the end it will be about 55 pages long.
Your free to do everything you prefer, but you make maintenance a
disaster when you want to
edit your forms. When you create each page on a new sheet you didn't
have the current problems.
Secondly as all your headings are 90% the same it is easy to copy a
sheet by selecting the Tab and Move/Copy Sheet from the drop down menu.
Can you tell me how to do the following
POSITION THE PICRURE IN THE CELL?
/Is that just a case of paste it there/
Make sure the Cell or Merged Cells are greater that the picture. Drag
your picture inside
the Merged Cells. Select Position and size with your Right Mouse Button
and tick the Protect field.
Select Anchor with your Right Mouse Button and select To Cell.
//
DEFINE PRINT RANGES?
Select the area you like to print and from the toolbar select Format -->
Print Ranges .. Define
A print ranges is only applicable for the selected Sheet.
INSERT MANUAL PAGE BREAKS?
Select a Cell which should be on the next page and select Insert -->
Manual Break ... Row Break
Thank you
And by the way please reply to the mailing list so anyone can answer /
learn.
*Mark Eaton*
Contracts & Service Manager
PRIDE Logo
The PRIDE Group (Qld) Pty Ltd
ABN 29 086 453 269
PO Box 4937, SCMC, Qld, 4560
Telephone - (07) 5442 1000
Facsimile - (07) 5442 1002
Mobile – 0413 871 430
www.pridesecurity.com.au <http://www.pridesecurity.com.au>
OHS_AS4801_HS_REDRGBwide.gifEnvironment-ISO-14001-PMS302.jpgQuality-ISO-9001-PMS302.jpg
Disclaimer - This message may contain privileged and confidential
information intended only for the use of the addressee named
above. If you are not the intended recipient you are hereby notified
that any use, dissemination, distribution or reproduction of this
message and any attachment is prohibited. If you have received this
message in error please notify *PRIDE* immediately. Any views
expressed in this message or any attachments are those of the
individual sender and may not necessarily reflect the views of *PRIDE.*
*From:*Martin Groenescheij [mailto:mar...@groenescheij.com]
*Sent:* Sunday, 7 December 2014 9:38 AM
*To:* users@openoffice.apache.org
*Cc:* Mark Eaton
*Subject:* Re: Assistance Please
On 5-12-2014 13:56, Mark Eaton wrote:
Hello,
I am trying to create a spreadsheet, that will be used as a report.
I have attached a copy and it is almost ready to go, but I have
one problem that I cant find a solution too.
You will see in the top left corner of each page, I would like to
have a logo/picture there.
It doesn’t seem to matter, how I put it there. It moves around the
document. You can see it in the “print preview” and after you have
come in and out of the document, you can it moved.
I did try to merge cells to see if that would be what was needed,
but I cant work it out.
Make sure you position the picture in the cell anchor it to the cell.
You also need to define print ranges and insert manual page breaks.
Attached is the modified document.
I think you make your live much easier if you have each form in a
separate sheet.
ARE YOU ABLE TO HELP?
Kind Regards
*Mark Eaton*
Contracts & Service Manager
PRIDE Logo
The PRIDE Group (Qld) Pty Ltd
ABN 29 086 453 269
PO Box 4937, SCMC, Qld, 4560
Telephone - (07) 5442 1000
Facsimile - (07) 5442 1002
Mobile – 0413 871 430
www.pridesecurity.com.au <http://www.pridesecurity.com.au>
OHS_AS4801_HS_REDRGBwide.gifEnvironment-ISO-14001-PMS302.jpgQuality-ISO-9001-PMS302.jpg
Disclaimer - This message may contain privileged and confidential
information intended only for the use of the addressee named
above. If you are not the intended recipient you are hereby notified
that any use, dissemination, distribution or reproduction of this
message and any attachment is prohibited. If you have received this
message in error please notify *PRIDE* immediately. Any views
expressed in this message or any attachments are those of the
individual sender and may not necessarily reflect the views of *PRIDE.*
---------------------------------------------------------------------
To unsubscribe, e-mail:users-unsubscr...@openoffice.apache.org
<mailto:users-unsubscr...@openoffice.apache.org>
For additional commands, e-mail:users-h...@openoffice.apache.org
<mailto:users-h...@openoffice.apache.org>
