The Image Command

Last updated:

    Image Command

    AP can print one or more images within the accounts.  This feature can be used to add a logo to the front cover, or a graph to the Directors Report for example. The accounts can contain multiple images as required. Images to be printed can be referenced directly from disk or from the new Image Library.

    The new '=Image' command allows you to define the image file to use and its size and position within a format:


    =IMAGE("name","size","location","horizontal","vertical","horizontal offset","vertical offset")

    • Name Can be either a file path of an image on disk (eg "C:\MyDocuments\Pictures\Logo1.jpg") or the name of an image stored in the Image Library (see below for guidance on how to use the Image Library). The 'name' value is case sensitive.
    • Size Enter this as a percentage of the "natural" image size.  Eg "50%" will reduce the image size, "150% will increase the image size.
    • Location This may be either "Cell" or "Page".  If set to "Cell", then the image will be positioned relative to the cell which contains the Image command.  If set to "Page", then the image will be positioned relative to the A4 page, regardless of which cell contains the Image command.
    • Horizontal This may be set to "Left", "Centre" or "Right".  The horizontal position of the image will reflect this choice in combination with the Location value of "Cell" or "Page".
    • Vertical This may be set to "Top", "Centre" or "Bottom".  The vertical position of the image will reflect this choice in combination with the Location value of "Cell" or "Page".
    • Horizontal Offset This may be used to alter the image position slightly from the position determined by the "Location" and "Horizontal" values.  The offset may be input as a measurement unit (eg "2 cms" or "1 in") or expressed as a proportion of the image size (eg "25%").
      • If the Horizontal value is set to "Left", then the Horizontal Offset will move the image to the right by the defined amount.
      • If the Horizontal value is set to "Right", then the Horizontal Offset will move the image to the left by the defined amount.
      • If the Horizontal value is set to "Centre", then the Horizontal will have no effect.

     

    • Vertical Offset This may be used to alter the image position slightly from the position determined by the "Location" and "Vertical" values.  The offset may be input as a measurement unit (eg "2 cms" or "1 in") or expressed as a proportion of the image size (eg "25%").
      • If the Vertical value is set to "Top", then the Vertical Offset will move the image down the page by the defined amount.
      • If the Vertical value is set to "Bottom", then the Vertical Offset will move the image up the page by the defined amount.
      • If the Vertical value is set to "Centre", then the Vertical Offset will have no effect.

    A sample Image command is provided below.  You may find it easier to copy this into your format and experiment with the different options.

    =IMAGE("Logo","100%","Page","Right","Top","1cm","1cm")