The Sheets tab

The Sheets tab lets you select the worksheets that will be visible on the web page. If your users need to print some of the information in a form or calculator, you may provide a specially formatted print sheet. 

The Sheets tab of the task pane contains a list of all the worksheets in the workbook you are currently editing with Excel. You can hide all the background sheets that you don’t want to be visible in the wrap. You can hide or lock worksheets for users without the required permissions. A special worksheet can be used when printing a wrap.

Screenshot of the Worksheets shortcut to the WrapCreator task pane

Hide background worksheets in the wrap

When there’s more than one worksheet in your workbook, we automatically hide all but the first during the conversion to a wrap. This is because an overwhelming majority of the workbooks with two or more worksheets use only the first worksheets for display – the rest of the worksheets just provide background information for the “front page”.

Screenshot of the Sheets tab

If you want to make more than one worksheet visible in the converted web page, click on the corresponding “eye” symbols in the list so that they turn green before you convert the spreadsheet.

By default, each worksheet appears as a separate tab in the wrap.

If you add a new worksheet to the Excel workbook, it may not be immediately visible in this list, To refresh the list, click on the Refresh button at the top.

Lock or hide sheets by role

Removing redundant detail from a Wrap can be useful to reduce the technical complexity of a Wrap for office workers. You may want to show information in a read-only mode for users that aren’t authorized to edit it. You can lock or completely hide a tab on the Sheets tab, depending on the user’s roles.

You set the roles that lock or hide each tab separately in the list of worksheets on the Sheets tab. Navigate to the sheet in question and a Lock or Hide dialog will pop out when you hover your mouse over the corresponding column. In both cases, you are expected to select user roles.

Screenshot of the Lock Sheet option on the Sheets tab in the task pane

You may lock a tab

  • if the user has a certain combination of roles – the user is qualified
  • if the user does not have this combination of roles – the user is not qualified.

The methodology you choose largely depends on your business requirements, but also on convenience – when it comes to roles, it’s always best if the definition is as brief as possible to reduce the risk of errors. If a tab is meant to be updated only by users with a few particular competences, and you want to lock it for all other roles, you will probably end up listing the few qualified roles and using the option (lock the sheet if the user is) not qualified.

Select the first role that makes users qualified. If additional roles are required for a user to be qualified, add them to the same group. A user must have all the roles in a group to qualify, e.g. “users must be both Administrator and Supervisor”.

To add an alternate combination of roles that also makes users qualified, click on New Group and add all the roles to the new group that a user must alternatively have. A user must have all the roles in at least one of the groups to qualify.

  • If you lock a tab if the user is qualified, the tab will be locked for users that have all the roles in at least one of the groups.
  • If you lock a tab for users that are not qualified, the tab will be locked for users that do not have all the roles in any of the groups.

Again, use the locking methodology that you find the easiest to define.

Hide sheets by role

When you lock a worksheet, its tab is still visible in the Wrap, but the fields cannot be modified. If you want to make a tab invisible for certain users, you can hide it completely. The role definitions that hide sheets work exactly like when you lock sheets as described above.

Screenshot of the Hide Sheet option on the Sheets tab in the task pane

  • If you hide a tab if the user is qualified, the tab will not be visible for users that have all the roles in at least one of the groups.
  • If you hide a tab for users that are not qualified, the tab will not be visible for users that do not have all the roles in any of the groups.

Selecting print sheets

If your users may need to print some of the information in a Wrap, you can provide a specially formatted print sheet that looks better on paper than just a plain print or a screenshot of the browser tab. If you want to print a few of the tabs as they are, any combination of tabs can be selected as print sheets.

You select a sheet for printing by clicking on the corresponding printer symbol on the Sheets tab. Any number of worksheets can be selected for printing. To unselect a currently selected print sheet, click on the printer symbol again.

Screenshot of the Sheets tab with two print sheets

A print sheet is not hidden by default, but if you have created it specifically for printing it’s unlikely that you want the print sheet to be visible in the converted web page. You can hide it by clicking on the eye symbol in the left-hand column until it’s red.

There is a help page about Print Sheets.

Selecting the initial tab layout for a Wrap

Wraps are often split into sections, with each section occupying one worksheet in the source spreadsheet. Each worksheet is represented by a separate tab in the converted Wrap. To switch to another section of a Wrap, the user clicks on a different tab.

Sometimes it’s convenient to see more than one tab at the same time, e.g. to compare values from different dates. The user can select to have one or multiple tabs appear in the same window using a button in the user interface.

Screenshot of the main user interface for a Wrap with multiple tabs visible, and a button to switch to single-tab mode

In the screenshot above, both the Task and Discuss tabs are visible in the same window, and accessible through horizontal scrolling. The <> button in the menu bar toggles between the single- and multi-tab layouts.

The developer can select either tab layout to use initially, when the Wrap is first opened, on a wide screen. The option for this is located at the bottom of the Sheets tab in WrapCreator. The user can always use the toggle button in the menu bar to switch to the alternate layout.

Screenshot of the Sheets tab with the default layout selector at the bottom

The initial tab layout setting is only with wide screen displays. When a Wrap is displayed on phones and other devices with narrow screens, the multi-tab layout is automatically disabled.