Contents tagged with Help
-
Presenting Your Wraps
ExcelWraps give you the ability to create online forms (wraps) for your business. We encourage you to fully personalise your wraps using the tips below.
Make Use of the Excel's Show/Hide Features
When creating a wrap extra data, such as number ranges, is required but the user does not need to see … more
-
Boolean Logic Guide
Excel Boolean logic formulas are an area worth revising before writing your first wrap. Wraps use them extensively but they are not so common in general spreadsheets. The notes below will help you get to grips with Boolean logic. There are 5 key Boolean Logic formulas:
Function … more
-
XLW Borders
Set XLW's border color using the 'BC' button. This both sets XLW's border color. Use 'BV' lines to add vertical lines and 'BH' to add horizontal lines; using both buttons in succession produces a grid.
Why does XLW need its own border controls? Excel understands that a border exists between two … more
-
Site Management
Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/help-wrapsite-administration/.Business and Corporate users assigned the role 'AdminTenant' have full access to standard website controls:
New>Page - Create … more
-
WrapLinkAggregate
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-wraplinkaggregate-widget/WrapLinkAggregate functions operate on cell values over a number of instances to compute a SUM or an AVERAGE or similar … more
-
User Selector
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-userselector-widget/User selector is a dynamic dropdown list that will be populated with all users that satisfy the sole selection logic. The following … more
-
Wrap Version Control
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-making-changes-to-your-wraps/Making Changes to Your Wrap
ExcelWraps allows you to make changes very easily. Simply make the required changes to the source … more
-
Device Simulator
Simulates many devices and helps you design for a target device (PC, tablet or smartphone).
NOTE: All wraps support pinch zoom and are usable on even the smallest devices. As a rough guide:
PC - Set Excel zoom size to 100% and the size in Excel is the size in your PC browser. On PCs wraps do not … more
-
Holder Cell
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-holder-widget/Set dummy values in a holder cell as a place to start a calculation thread. When converted to a wrap the holder cell's dummy value will be … more
-
WrapLinkList
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-wraplinklist-widget/
Populate a drop down list of unique key values from another wrap. This is a useful way to create dynamic lists rather than static … more
-
WrapLink
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-wraplink-widget/
A WrapLink pulls a cell value from another wrap instance. The XLW WRAPLINK() function is inserted into the cell. You will be guided … more
-
About XLW Subdomain
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-for-the-account-tab/Your Excel subdomain contains information about users, user roles, wrap definitions and their unique keys and wrap group permissions. … more
-
Validate Wrap
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-ribbon-menu-in-excel/#convertCheck that you are ready to submit your wrap. You may submit your spreadsheet for wrap conversion only if it validates … more
-
Map Hyperlinks
Select the range of cells containing hyperlinks strings then hold the CTRL keys and select the top left cell of the cells you wish add hyperlinks to and then press the ‘Map Hyperlinks’ button. more
-
Map to Comments
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-tools-menu/Select the range of cells containing comment strings then hold the CTRL keys and select the top left cell of the cells you wish add comments … more
-
Map to Names
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-tools-menu/Select the range of cells containing name strings then hold the CTRL keys and select the top left cell of the cells you wish to name then … more
-
Widgets
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-use-the-basic-widgets/.Extend Wrap functionality using HTML, JavaScript and external libraries. Widgets do no function within Excel they work only when they … more
-
Auto Number
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-for-the-wrap-tab/Auto Number Control will create a sequential integer to index a new wrap instance. XLW's AutoNumber() function is inserted in the active … more
-
Insert Media Control
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-media-upload-widget/
Upload pictures, pdfs, office documents or any supporting file into your wrap. It allows you to add any file attachments to a … more
-
Conditional Input
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-cinput-widget/
A conditional input cell becomes active if a user has a particular subdomain role and an enabling cell becomes TRUE. XLW's CINPUT() … more
-
Wrap Signoff
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-wrapsignoff-widget/Wrap signoff control replace conventional paper signatures and integrates with user roles. The control will be available for signoff … more
-
Show Roots
This selects precedent cells of all cells containing formulas that do not contain formulas themselves. It is likely that these cells will need to be input cells (although they may hold a fixed value too).
-
Show Inputs
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-ribbon-menu-in-excel/Select all Wrap input cells on the current worksheet.
NOTE: This is a useful button to set a common cell background to identify … more
-
Wrap Input
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-the-ribbon-menu-in-excel/
Any unlocked cell becomes a wrap input cell. The toolbar button becomes clear when an input cell is selected and shaded when it … more
-
Wrap Properties
Note: This page has been replaced by an updated and extended help page for WrapCreator at https://help.excelwraps.com/support/online-help/help-for-the-wrap-tab/Wrap properties include a description and version history notes, the wrap group, the unique keys definition, the locking behaviour and the … more
-
Excel Conversion to Wrap
Your wrap will look like the original spreadsheet (however some compromise occurs as HTML tables don't follow exactly the same specification as Excel). We believe we get a pretty good match. It is possible to fully debug inside Excel before conversion to wrap so your wrap will function just as your … more
-
Wrap Maps
A wrap map is simply a type of wrap which uses XLW’s WRAPLINK() function to pull cell values from many wraps. The value is gathered in the wrap map and each item comes with a hyperlink back to the URL of the wrap instance holding the data. A wrap map is both a great way of summarising data in one … more
-
MyWraps Reports
Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/help-mywraps-reports/.MyWraps reports looks at wrap cell values over all available wrap instances to plot in live charts or in tables. Switching between chart … more
-
Read Only Wrap Property
You can set Wrap properties so that data is never stored on the cloud database by making it read only. The read only behaviour of a wrap is set using XLW's Wrap Properties button. more
-
Edit Locking
Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/help-the-excelwraps-page/.
The ExcelWraps system is designed so that two people never have to open the same wrap instance at the same time. Were this to … more
-
Wrap Instances
Note: This section has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/introduction-to-wraps/It is important that you understand the difference between a wrap and a wrap instance. They are analogous to an Excel template and an … more
-
XLW
XLW is a software add-in for Excel to help you create wraps on your ExcelCalcs site. It's a free download. more
-
Wraps
Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/introduction-to-wraps/Wraps are web apps available on your ExcelWraps site and their purpose is to gather data into the cloud database. Wraps are created using … more
-
Roles and WorkGroups
Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/help-users-and-roles/.Roles are basically a set of permissions that define how you can use the ExcelWraps site. Here are typical user roles - shop floor … more
-
Access Controls
Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/help-permissions-model-and-access-control/.This section sets out how particular users get access to particular information and how permissions are given to … more
-
User Management
Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/help-users-and-roles/.User accounts are created with a unique username and a password to access the site. User profiles add additional user information (email … more
-
Getting Started and Terminology
Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/help-quick-start-guide/.Follow this guide to take the first step towards your paperless future.
User Roles – Users can be assigned one, or any number, of … more