Release Notes

These are the release notes for the most recent versions of the ExcelWraps server and the WrapCreator development environment. 

ExcelWraps is a computer environment hosted on the Microsoft Azure infrastructure that provides database and computational resources to Wraps.

WrapCreator is an add-on to Excel for Windows that is used to develop and maintain Wrap templates.

Registered users receive download links for new versions via e-mail. If you don’t have the most recent links, please contact client services. If you are not yet a customer but are interested to learn more about EcelWraps, please visit the website and use the contact form to request a personal demonstration.

This page summarizes the major changes in the most recent versions. For a history of older versions, please visit the Release Notes Archive.

ExcelWraps server 133 September 2022

• The ability to Import wraps and their templates into a Live wrapsite is now governed by a feature permission that you can grant or revoke for any user role.
• When you import wraps that don’t currently exist, you can set the owner for the new wrap using a CreatedBy column in the import file. This mimics the operation of the CreatedBy parameter for Wraplinks. The owner of a wrap cannot be changed after the wrap has been created.
• Faster loading of wraps in large wrapsites.
• Additional look-and-feel improvements, also when using wraps on phones.
• Easier access to the ExcelWraps backend from external systems with longer authentication periods.
• All parts of your wrapsite are protected by modern security protocols like TLS 1.2 and secure designs like Microsoft Azure Virtual Networks.

WrapCreator 10.13 August 2022

• Wraps generated with version 10.13 and later of WrapCreator get the new look and feel introduced in ExcelWraps server version 132.
• Cells can be read-only, i.e. they can only get an initial setting during the creation of the wrap. When the wrap is later edited, these cells cannot be changed, the same way we lock the Unique Keys. The read-only cell attribute can be selected for a Text or Utility widget.
• The WrapSignOff widget can now take eligible roles or a user name from a read-only cell, making signoff more flexible but still just as secure.
• The Media Upload widget permits the upload of almost any designated file type. Executable files cannot be uploaded for security reasons.
• The TextGlue function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the function references text ranges that contain “Jisoo”, “Jennie”, “Rosé” and “Lisa”, and the delimiter is “-“, the resulting string will be “Jisoo-Jennie-Rosé-Lisa”. An identical function is provided by Excel 2019 or later under the name TextJoin.
• The XYTableGroupBy function can be used to perform SUM, MIN, MAX, or COUNT aggregations over a table that is saved as a delimited text string.
• To simplify the developer’s work, the Account tab in WrapCreator now has links to the Import Wraps and Excel source file download pages in the Wrap Administration section of the wrapsite.
• This version adds support for several new features in the ExcelWraps server 132 released simultaneously, e.g. read-only and non-searchable fields.
• Our example wraps convert without issues in Windows on ARM devices. If you get unexpected results when using WrapCreator with Windows on ARM, please contact Client Services.

ExcelWraps server 132 June 2022

• This version of the server has a much-enhanced user interface. Many small changes together create a more modern look that is easier to use. When you generate wraps with WrapCreator 10.13, your wraps will automatically have the same look and feel as the new version of the server.
• In previous versions, all cells in a wrap could be searched for cell contents in MyWraps filters. Unfortunately, this has an enormous impact on the server’s performance. Starting with this version, unnamed cells in a wrap and cells that contain a MyWraps2() function call are no longer searchable. This removes a lot of irrelevant data from the search function, which greatly improves performance.
• In support of non-searchable cells, MyWraps may not allow you to add them to new reports and does not allow filters to be set for the cells that aren’t searchable. If you find that one of your favorite cells is missing on the setup page or no longer has a filter, you can easily get it back just by naming the cell in the wrap template.
• Cells can be read-only, i.e. they can only get an initial setting during the creation of the wrap. When the wrap is later edited, these cells cannot be changed, the same way we lock the Unique Keys.
• The WrapSignOff widget can now take the eligible roles from a read-only cell, making signoff more flexible while still being just as secure.
• The Media Upload widget permits the upload of almost any designated file type. Executable files cannot be uploaded for security reasons.
• To increase performance, the Audit Trail is now saved as a separate file. We no longer provide a user interface for viewing the audit log online since it is so much faster and easier to download the log and analyze it in Excel.
• The Download button on the MyWraps toolbar has been removed. You can download the current report data in CSV or HTML format from the Action menu.
• When you use the Copy button to create a MyWraps link for the MyWraps2 function, the copied link is optimized for clarity. All redundant options are automatically removed, including all settings that will be defaulted anyway, which may make the link much shorter. If you want to include one or more options with their default values, you may of course manually add them back to the link in the MyWraps2 call.
• MyWraps2 observes the default wrapsite culture (the locale set for the wrapsite) and will format returned dates and numbers accordingly.
• You can reorder the data series when creating a MyWraps chart, e.g. to get the most important series at the top of the legend.
• MyWraps has a new action Intersect Names to automatically include only the common columns between the current wrap and target wrap in preparation for a WrapStack operation.
• When importing wraps, AutoNumber is supported.
• When importing wraps, you have the option to recalculate also frozen wraps after an import operation has been completed.
• Some things cannot be imported back into ExcelWraps, like media files and signatures. There is a complete list on the help page.
• The behavior of WrapStack has been changed so that if a cell in the instance data table is empty, the corresponding cell in each updated wrap is also emptied. WrapStack also ignores columns in the instance data table that don’t have a field name in the heading.
• Some new ExcelWraps feature permissions have been added:
  • A user with the Manage MyWraps permission can customize reports.
  • A user with the Can download wrap source files permission can download the Excel source files for wrap definitions.
• The security of the ExcelWraps server has been hardened.

ExcelWraps server 131 January 2022

• When exporting and importing wraps, the default file format is now Excel .xlsx files. This is the recommended format.
• The new xlsx export file format includes signature metadata like the username and timestamp. For security reasons, signatures and their metadata cannot be imported back into the database.
• MyWraps now supports the sw() operator to filter wraps where a field starts with a certain string.
• If you just enter text into a MyWraps column filter, a co() operation – giving a match if the field contains the filter’s text in any position – is performed automatically. For performance reasons, you should use the eq and ne operators instead of co and nc if possible, in particular when filtering a large number of wraps.
• A warning may appear when you copy a MyWraps link that has a slow co or nc filter.
• When you set up a MyWraps report for a wrap with many cells, you can just begin typing the cell name and it will automatically complete it for you. This can save time when the list of cell names is very long.
• We have made it much faster to open wraps, especially if there are many roles and users.
• The Server Recalculation Queue offers additional information for recalculated wraps. The way we run recalculation jobs has been made more reliable.
• Admins can recalculate frozen instances when formulas are changed in an early version of a wrap template in a way that does not invalidate existing signatures.
• When you use Wrapstack, and an update operation detects a frozen wrap, it now just skips the frozen wrap and moves on to the next wrap. Previously, the entire row in the WrapStack Instance Data Table was terminated and rolled back.
• The final calculation of a TeamWrap after it has been frozen is now more reliable.
• When wraps are exported as PDF files, a 10 mm page margin is used.
• The Initialise Instances action for Wrap templates has been removed. We previously used this function to pre-fill the Unique Keys for a group of new wraps. This method of adding many new wraps has been superseded by the WrapStack widget.

WrapCreator 10.12 January 2022

• The new ImageGrid widget lets the user click to select a certain part of an image, e.g. to mark a seat that has stains. The developer creates the clickable area by superimposing a resizable grid over the image. A setup wrap is created with WrapCreator and uploaded to the wrapsite. The grid is configured online with a web browser. The grid configuration is copied to the inspection wraps. The user of the inspection wrap can report a new stain or see what stains have previously been reported for the same location.