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.

Planned maintenance windows

Maintenance windows occur 19:00-21:00 UK time.

August 3
September 7
October 5
November 2
December 7

ExcelWraps server 135a January 2023

If you run a RecalculateLastFrozen job you may now get a new message if the job is not completed because of a 504 gateway timeout error. The first corrective action is simply to rerun the job and then it usually completes correctly.
Admin-related apps are only visible in a special Admin view. ExcelWraps uses some of these “system” wraps for quality assurance and they need to be protected from inadvertent manipulation by unauthorized users.
A new permission has been added for the CreateUserToken API.

ExcelWraps server 134 December 2022

Introducing the WrapConnector API for real-time connections to other systems. The initial deployment has been to remotely monitor and control intelligent torque wrenches.
A new permanent limitation has been introduced: cells that may contain more than 2048 characters can no longer be searchable and cannot be used in MyWraps reports.
The method of releasing future versions of ExcelWraps has been simplified internally in order to be even less disruptive to clients.

WrapCreator 10.13 November 2022

ExcelWraps is an open system that easily communicates with many other systems. Existing integrations include an Internet-of-things application where ExcelWraps controls and audits the advanced use of torque wrenches using a built-in, generic interface called WrapConnector. The most recent version of 10.13 includes the WrapConnector interface.

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.