Release Notes

These are the release notes for WrapCreator and the ExcelWraps server. 

WrapCreator is an add-on to Excel for Windows. The ExcelWraps server is hosted on the Microsoft Azure infrastructure and provides database and computational resources to Wraps.

Download links for new versions are e-mailed to registered users. If you don’t receive these links, please contact client services. If you are not yet a customer but 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 each update.

ExcelWraps server October 2020

  • Restore the previous version of a Wrap instance.
  • Download the previous version of a Wrap definition.
  • All data is copied from your Staged to Live wrapsite every Saturday.
  • The audit log has more filters and is faster.
  • Completely new Excel-friendly import and export formats for instances.
  • WrapStack improvements like autonumbers, permissions and undo.
  • MyWraps has some more filters for text data.

WrapCreator 10.6.8304.0

  • WrapCreator supports delimited lists for some operations, e.g. to provide options for the Dynamic Dropdown widget. When working with this kind of aggregated string values, the new TextSplit function allows you to parse the string and use each segment separately.
  • Multiple tabs are shown side by side on laptops by default. You can force the old single-tab layout using a new setting on the Sheets tab.
  • The QR code used to open a Wrap in a phone is now hidden by default. Click on the new QR code icon to open and scan the QR code.

WrapCreator 10.5.8276.0

  • If you click on the tab icon for a Wrap, the layout changes to a new columnar view with one tab visible in each column. You just click on a tab to make it appear as an additional column on the screen, and again to hide it. Having access to multiple tabs at the same time makes it much easier to compare numbers or copy information between tabs.
  • On phones, tabs can be visualized as a list of headings. In this accordion view, you just click on a heading to expand its content, and again to close it. Clicking on another heading hides the content for the previously opened heading and shows the content for the new one.
  • WrapCreator now supports the Concat and TextJoin Excel functions. Concat lets you concatenate cell values, e.g. within a range, like =CONCAT(B1:B10). It can save you time by not having to join each cell address with a separate “&” operator. TextJoin is similar but allows you to specify the separator and can skip empty cells, like =TEXTJOIN(“|”, TRUE, B1:B10).
  • Some Wraps don’t save anything and thus don’t create instances. Providing a Save button for them can be confusing to the user. The Wrap tab now offers a new NoSave Wrap Type that lets you generate Wraps without a Save button if they don’t need one.

ExcelWraps server September 2020

  • Standard Wrap code and style sheets used to be generated and saved with each Wrap. Now you can run these shared Wrap components from a single shared web location instead. If the shared components are updated in the cloud, your Wraps will automatically use the updated versions – no rewrap required, just clear the browser cache. The re-use of shared code in the cloud reduces the size of Wraps by up to 75%.
  • The facility to save KPIs now has support for the Network Rail Control Period.
  • The list of Users now has additional columns for Company, Location, Workgroup, and Roles. The new columns can be used to filter the User list.
  • You can now easily download the xlsx source file for any Wrap directly from the list of Wraps, eliminating the need for Dropbox or other file-sharing facilities between Wrap developers.
  • To increase data integrity, we have changed the way Wraps and instances are deleted.  The Wraps and/or instances that you have selected are now queued for deletion in the background, after which you are taken to the server queue where you can follow the job that was created.
  • Wrapsite administrators can also queue instances for deletion using a new Action item on the MyWraps toolbar, enabling more complex selection of instances also from multiple Wraps.

WrapCreator 10.4.8239.0

  • The HideColumnIf function hides a column using a function in a cell on the column.
  • You can copy a range of cells from a table in Excel to a table with the same dimensions in a Wrap. This enables you to quickly fill a Wrap instance with information copied from Excel. When pasting, select the upper left-hand field in the instance and all the cells affected by the paste will be highlighted. Press Ctrl-V to confirm and perform the paste. Your browser may require your initial permission to let the Wrap access the clipboard in this way.
  • A Utility widget can span over two or more lines, e.g. when used with a function that returns a variable amount of text.
  • A new Auto Height option for the Text and Utility widgets allows a multiline text field to dynamically expand or contract with the contents. If you don’t enable this feature, the field has a fixed height and a vertical scroll bar will appear when it becomes full to enable users to scroll back and forth across the field’s contents.
  • When you view a Wrap instance, you can save content from it as a spreadsheet in xlsx format using the Export to Excel widget.
  • The Dynamic Dropdown widget can use a delimited list of options, e.g. ABW|AFG|AGO|… for three-letter country codes.
  • The WrapLink widget supports the createdby parameter, e.g. to make a new instance of a sensitive Wrap private to a specific user.

ExcelWraps server July 2020

  • You can automatically save key performance indicators or other business intelligence data on a regular basis, e.g. to save periodical KPI data for easy use in tables or charts.
  • You can save all critical events on the server in the Audit Trail and review past events later.
  • A new instance may be created as a result of a WrapLink. If the link contains field/value pairs that are not part of the Unique Key, this data is used to pre-fill the corresponding fields in the new Wrap instance. The ownership of the new instance can be set with the createdby parameter in the link, e.g. to make a new instance of a sensitive Wrap private to a specific user. The createdby value can also be set for instances created with WrapStack.
  • In MyWraps reports, you can place filters also on columns that are not included in the report. It is now easier to navigate in a report using AutoNumber. MyWraps should be considerably faster in this version.
  • The WorkgroupSelector function can be used also in Wrapgroups that don’t belong to a Workgroup. This allows you to use a common Wrap for all your suppliers. When a new instance is created, the WorkgroupSelector is set to the supplier’s Workgroup, which hides the instance for all the other suppliers.
  • The UserSelector widget is now aware of Workgroup membership. If an instance has been trusted to another Workgroup, the users of the trusted Workgroup also appear in the UserSelector, if they have the designated roles.
  • We now allow users to save updates to an instance even when it doesn’t fulfill recent validation criteria. It can have an item selected in a list, e.g. a depot, but that item is no longer an eligible choice. The instance may be signed but the current signature enabling logic would not have permitted the signature because an additional processing step has been added since the instance was signed. The instance may reference a User that is no longer active. In all these situations, most database systems would prevent you from saving the instance. With ExcelWraps you can still save instances with previously accepted values that are no longer valid.

WrapCreator 10.3.8199.0

  • The Media Upload widget no longer requires that you press a button to upload documents.
  • The dialog for a WrapSignOff widget now states “I hereby certify that all information is true and complete”.
  • The help for input cells has been extended to clarify what you should do when merging two or more named cells.

WrapCreator 10.2.8178.0

  • The HideRowIf function hides a row using a function in a cell on the row.
  • The UserRole function assigns a User Role temporarily, from a Wrap.
  • Support for more than one Print Sheet.
  • Use Ctrl-S on a PC to save a Wrap, Cmd-S on a Mac.
  • Use Ctrl-Spacebar on a PC to work in expanded view with all tabs stacked vertically, Cmd-Spacebar on a Mac.

WrapCreator 10.2.8150.0

  • The WrapStack widget has a new option to perform either bulk updates or bulk inserts. With updates, all Unique Keys must already exist. With inserts, all Unique Keys are new and must not already exist. There is also a new option to omit the recalculation of added instances.
  • If an input cell is permanently hidden, i.e. it is in a row or column that is hidden in Excel, or a sheet that has been marked as hidden on the Sheets tab, it is not included in the Wrap and will not be saved in the database. You will receive a warning message during the conversion.
  • If you merge two or more named cells, the merged cell will have two or more names. This is not permitted. Only the name for the upper left-hand cell of the merged cell will be kept. You will receive a warning message during the conversion.
  • The Wrapsite Administrator can customize the logo, header background color, and QR code color of a Wrapsite. Go to Administration dashboard > Settings, select ExcelWraps, and scroll down to Settings Dictionary.

WrapCreator 10.2.8044.0

  • The official launch of the WrapCreator add-in for Excel.
  • WrapCreator no longer requires ExcelWraps staff to convert and install Wraps on their behalf. Users are doing things for themselves!
  • Wraps with extended reach using a new permissions model. A contract-specific Wrap can now cover every contract. Fleet-specific Wraps can now cover every fleet.
  • Bulk action wraps – This feature works like a Wrap macro so that just one signature updates many Wraps in one go.
  • Support for responsive design to “fold” wide layouts to fit narrow screens
  • New interactive charts.
  • The WrapStack widget lets you create many new instances in bulk.
  • The WrapLinkMedia widget can link to photos, PDFs, and other media uploaded to another Wrap.
  • The WorkGroupSelector widget allows you to trust a single instance of a Wrap to a different Workgroup.