Wrap user interface

This help page describes the end-user interface for a wrap created by WrapCreator and uploaded to a Wrapsite – how wraps look for users.

Wraps are created from Excel templates using WrapCreator. The converted result is uploaded as a web app to your Wrapsite, where it connects to the ExcelWraps database and to the other wraps in your system. You start a wrap by clicking on a link to it.

The appearance of a wrap is slightly different on narrow, medium, and wide screens. The screenshot below is from a medium-width screen.

Screenshot of a wrap as it appears to the user

Mobile screen

On a narrow screen like on a phone, the wrap is slightly more compressed, and the icons in the toolbar no longer fit on a single row. This may serve as a reminder not to design wraps in landscape mode that only works on desktop widescreens, but in portrait mode that works well on all screens.

Screenshot of a wrap as it appears to the user on a phone

Visual components

The display of a wrap has four main visual components:

  1. The page header
  2. The tab header for each tab
  3. The contents of each tab as defined by a worksheet in the wrap template
  4. The bottom toolbar

The page header

Screenshot of the page header for a wrap

Wrapsite logo

In the header at the top of the page, the Wrapsite logo will be at the top left.

Clicking on the wrapsite logo returns to the wrapsite without saving the changes you have made.

The QR code

ExcelWraps is very easy to use on mobile devices. If you have a wrap open on one device, and want to open it on another, you can click on the QR code button to display a link to the wrap in barcode format. If you scan this QR code with the camera of another device, it can decode the link and open the wrap in a web browser. If you aren’t already logged into the wrapsite, you need to provide your user credentials on the mobile device before you can access the wrap.

To see this in action, scan the QR code in the screenshot below with your phone’s camera.

Screenshot of a QR code for a wrap

The tab header for each tab

If the wrap has more than one visible tab, a header for each tab will appear on the screen.

Tab layout

To better exploit screen width and network bandwidth, wraps with multiple tabs can be shown in three different layouts. You select the layout using the button that looks like a window.

Screenshot of the tab layout button that allows you to switch to parallel tabs

  • Normal layout – on desktop widescreens, a tab header appears above the wrap content. You switch between tabs by selecting the corresponding tab. If there is only one tab in the wrap, the tab header does not appear.
    Screenshot of the tabs for a multi-tab wrap in widescreen mode
  • Multi-tab layout – on desktop widescreens, the multi-tab layout allows you to show the content from two or more tabs side by side, allowing you to compare the content of two tabs. Click on a tab to make it visible, and again to hide it. If the visible tabs don’t fit the width of your screen, a scroll bar appears at the bottom of the tabs that allow you to scroll horizontally to the tab you want to access.
    Screenshot of an example of parallel tabs presented side by side with horizontal scroll
  • Accordion layout – on narrow screens, e.g. on mobile devices, each tab header appears directly above its content. We call this the accordion layout. Click on the tab you wish to work with and its content will expand.
    Screenshot of an example of accordion tabs and the expand/collapse button

Expand/collapse tabs

The button with arrows (left/right if the multi-tab layout is available, up/down in the accordion layout) can be used to expand (open) or collapse (close) all the visible tabs.

The contents of each tab

A wrap is a web application designed to support a certain business process. Each tab in a wrap contains cells (we use the Excel name for them but you may prefer to call them fields) that were put there by a wrap designer in a way that was considered useful to the users of the web app. If you don’t understand what to use a particular field for, or have a suggestion for improvement, please contact your local wrapsite administrator. It is easy to customize wraps to local requirements.

The bottom toolbar

At the bottom of the wrap window, you will find a toolbar that provides navigation buttons and a few other helpful functions. The buttons in the toolbar vary depending on the type of wrap and the permissions granted to you.

  • Save – Saves your changes to the database.
  • PrePopulate – A wrap can be used to create new wraps, e.g. in preparation for a train arriving at the depot, you may have a wrap that creates inspection wraps for all the carriages in the train. With such wraps, the PrePopulate button saves time by allowing you to create all these new wraps in one go instead of creating them manually. This is a special case and you should not use this feature unless your instructions clearly say that you should.
  • Navigation buttons – If wraps form a numbered sequence, e.g. the numbered error reports for a specific train engine, a set of navigation buttons help you move back and forth between the wraps as ordered by their auto number.
    • First wrap – Takes you to the first wrap, with the lowest number in the list.
    • Previous wrap – Takes you to the previous wrap in the list, with the next lower number.
    • Wrap number – Shows the number for this wrap within the sequence.
    • Next wrap – Takes you to the next wrap in the list, with the next higher number.
    • Last wrap – Takes you to the last wrap in the list, with the highest number in the list.
  • New wrap – Creates a new wrap, with the same layout as the currently visible wrap. You can copy the cell values for the current wrap or see the default values from the wrap template.
  • Print to PDF logs – This lets you view the PDF Log for this wrap and optionally create a new PDF for it. Administrators can have wraps printed automatically when they are signed. Read more on the help page about printing wraps to a PDF file.
  • Export to Excel – Download the data content of this wrap to your device in Excel format.
  • Delete – Delete this wrap. Deleting wraps is a very unusual action and almost exclusively something you would do only during development and testing. Deleted wraps can be restored from history but please be aware that we don’t retain any media files (photos etc) so they may be lost forever unless you have copies of them elsewhere.

Special wraps

There are a few special kinds of wraps that you can recognize from the toolbar:

  • No Save wrap – These are mainly used for navigational purposes. The toolbar for a No Save wrap has no Save, New wrap, or Delete button.
  • Team Wrap – When a wrap has been designed to be used by multiple users simultaneously, it is called a team wrap. There is no Save button since saving is automatic. To the right on the toolbar is an orange button with a list of users currently editing the wrap.
    Screenshot of the toolbar for a Team Wrap
  • Private wrap – If a wrap is configured to be accessed only by its owner, we call it a private wrap. The owner of a private wrap can allow it to be accessed by others using a special Share checkbox that only appears for private wraps.
    Screenshot of a wrap toolbar with the Share option for private wraps

Status indicators

We use visual cues to alert you about the status of certain things.

Signature cells

Intermediate signature

An intermediate signature is used to sign off a unit of work as completed.

Screenshot of a normal signature cell

When an intermediate signature has been made, it shows the username and timestamp.

Screenshot of a normal signature field with a signature in it

Freeze signature

When a signature marks the completion of a unit of work and locks the wrap for further updates, the signature cell has a green “freeze” icon.

Screenshot of a signature cell that will freeze the wrap

When a wrap is frozen, the signature that locked the wrap has a blue “frozen” icon.

Screenshot of a signature cell that has been signed to freeze the wrap

Disabled signature

If a signature cell is grey, it means you cannot sign it because you lack the required authority. Please contact your local wrapsite administrator if you feel you should be able to sign a particular processing step.

Screenshot of a disabled signature cell


Signature warnings

If the rules that enable the signature have changed since the wrap was signed, the signature is prefixed by an apostrophe. Read more on the help page about Making changes to your wraps.

Screnshot of a signature that was made before the most recent update of the wrap and is prefixed by an apostrophe

If the rules that enable the signature have changed since the wrap was signed, and the signature would not have been permitted with the new rules, a red border appears around the signature field. Read more on the help page about Making changes to your wraps.

Screnshot of a signature that was made invalid by the most recent update of the wrap and is surrounded by a red border

Wrap status

If you open a wrap where one or more tabs are locked (visible but read-only), a lock icon appears to warn you that you will not be able to make changes to the content of these tabs. Please contact your local wrapsite administrator if you feel you should have access to any protected parts of a wrap.

Screenshot of a wrap with a lock icon on a locked tab

If you open a frozen wrap that cannot be updated, a blue “frozen” indicator appears at the top of the page. Please contact your local wrapsite administrator if you feel that a wrap has been frozen by mistake, to have the wrap unlocked again

Screenshot of the page header for a frozen wrap with a blue "frozen" icon

If you open a wrap in read-only mode, an icon appears to warn you that you will not be able to save any changes. Please contact your local wrapsite administrator if you feel you should have access to a read-only wrap.

Screenshot of the page header for a frozen wrap with a read-only icon

If you open a wrap that has not been recalculated, a flash icon appears. This says that the wrap may show different values if recalculated, but that since recalculation is a slow process, it was considered unnecessary for your use of the wrap. Please contact your local wrapsite administrator if you feel the wrap should have been recalculated before it was opened.

Screenshot of the page header for a wrap opened with openmode fast

Wrap paste

When you copy data between two windows, you usually copy one field at a time, paste it in, then go back to fetch the next field. If there is a lot of data to copy, e.g. many rows and columns in a table, copying one field at a time can be very time-consuming.

If you are copying data from Excel to a Wrap, ExcelWraps allows you to save time by copying larger chunks of data at the same time. To enable this feature you must select the Enable Wrap paste option on the Wrap tab of the task pane before you convert the spreadsheet.

Screenshot of the Enable Wrap Paste option on the Wrap tab

ExcelWraps has special support for tabular data in rows and columns that comes from Excel. If you copy a cell range in Excel and select an input field on a Wrap, all the fields that will be affected by the paste operation will be highlighted. The highlighted area always has the same proportions as the cell area in Excel, so if you copy a 2×2 area like C3:D4, you can only paste these four fields into a 2×2 selection of input fields on the Wrap.

In the screenshot below, we copied a 3×3 cell area from Excel, then placed the cursor in one of the input fields of a Wrap. As you can see, the highlighting clearly shows you what fields will be affected by the area paste. Notice that the right-most column – the one with the sixes –  is unaffected by the 3×3 range that is being copied.

Screenshot of a Wrap paste operation involving nine fields

When you’re happy with the selected field range, just press Ctrl-V to replace the content of the highlighted fields with the corresponding contents from Excel.

Upon completion of the paste operation, the Wrap is automatically recalculated.

Design restrictions

You can only paste into fields that are open for input. Only three field types are currently supported: Wrap input, Text widget, and Dropdown widget.

The input fields that we paste into don’t have to be absolutely next to each other. You can have intermediate sections of field labels, calculated output cells or other unsupported field types, or blank rows and columns. Just verify that you accept the automatic selection of fields to paste into before you press Ctrl-V.

Clipboard protection

For security reasons, your web browser may be protecting the data on the clipboard. In this case, it will issue a prompt the first time you select an input field in the Wrap. Click Allow or similar to enable the Wrap to see if you have prepared for an area paste.

Screenshot of a web browser requesting access to the clipboard

Too few input fields selected

Wrap paste may run out of fields to paste into. This can happen when the cell range on the clipboard contains more rows or columns than are available in the Wrap, starting at the currently selected input field.

Example: You have copied an area from Excel that is 5 columns by 5 rows, but starting from the current field, only a three-column range of input fields can be pasted. In this case, you get a warning message.

Screenshot of the prompt you get when the cells on the clipboard don't fit the wrap

If you press OK, you will lose the two right-most columns of data that you copied from Excel. If you expected the cell range in Excel to fit nicely into the input fields of the Wrap, you may have selected the wrong input field to start the paste operation from.

Protection from duplicate data

Once you’ve pasted a cell range into the Wrap, you cannot paste it again. This is to protect you from accidentally pasting the same data twice, which is likely to make the contents of the Wrap invalid. You must always fetch new data from Excel before you attempt the next paste operation.