Contents tagged with XLW
-
XLW Download
Note: XLW has been replaced by WrapCreator. Learn more at https://help.excelwraps.com/.XLW is a free software addin to create Wraps using Excel for Windows (2007 or later). See software release notes and version history.
Download XLW setup file - Run the windows installer so that XLW runs every … 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
-
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
-
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
-
XLW
XLW is a software add-in for Excel to help you create wraps on your ExcelCalcs site. It's a free download. more