Latest Software and Release Notes

Note: This page has been replaced by the release notes for WrapCreator at https://help.excelwraps.com/support/release-notes/

This is a summary of full source code changes which is available to the MoreVision Development Team in the source code repository. It is intended to notify end users of any software changes and notify them of system shut downs typically lasting one hours to allow site software updates.

Sprint 106 - Work In Progress

1. 'Big Data' work continues. Optimisation of WRAPLINKAGRREGATE() functions for rapid rendering of Key Performance Indication reports (KPI)
2. New feature requests continue.

Sprint 105 - 21st August 2018

1. Faster MyWraps reports as 'fast' filters extended to include signature data.
2. Faster MyWraps reports as 'fast' filters extended to include csv data.
3. OWASP penetration testing reconfigured to improve site security. 
4. New SSL certificates installed to improve site security.
5. New Action in Administrators Wrap Instance view (Export Wrap Definition And All Instances).
6. Faster disabling/enabling of users with new user controls.
7. Simpler method of adding users who do not have an emails address.
8. Faster WRAPLINKAGRREGATE() functions now incorporating a 'State' filter. 
9. New XLW features 'TabHideRole and 'TabVisibleRole' widgets controls what tabs are visible in a wrap based on user roles.
10. Faster XLWPackage.zip downloads.
11. XLW V18.08.07 released.

Sprint 104 - 21st June 2018

1. NEW FEATURE REQUIRED FOR WABTEC CL225: New MyWraps co() filter (contains). It is the default operator for strings. eq(hello) now means exactly equals, previously it meant contains. We have migrated all MyWraps reports on WrapSites buttons and WrapMaps so they should continue to work without modification but please keep a look out for any anomalies.
2. BUG FIX REQUESTED BY SIEMENS: Usenames do not allow apostrophes (as in O'Brien, O'Gorman) as it prevents wraps loading correctly. 
3. NEW FEATURE: Import instances scripts now contained within XML Wrap export/import feature.
4. NEW FEATURE REQUESTED BY SIEMENS: Clarify what 'default' means in the context of autonumber '+' button.
5. NEW FEATURE: MyWraps fast filter feature now works with integer and datetime types.
6. NEW FEATURE REQUESTED BY WABTEC HST: MyWraps can now include images from media upload cells (image size can be either small or tiny as configured in your XLW media upload controls).
7. NEW FEATURE: Faster default wrap instances view on site dashboard including new filter features and an expanded action menu.
8. NEW FEATURE: Media Uploads re-sized on server if a wrap instance last modified date is older than the wrap definition.
9. NEW FEATURE REQUIRED FOR EVERSHOLT: Input cell Number format can now include , 1000 separator (although it will not invoke a touch devices number keypad as this does not include "," character).
10. NEW FEATURE REQUIRED BY SIEMENS: New MyWraps fast filter for wrap headers.
11. NEW FEATURE: Extend permissible length of URL to ensure wrap hyperlinks always work regardless of length.
12. NEW FEATURE REQUIRED BY WABTEC: XLWPackage.zip now includes user workgroup.
13. NEW FEATURE: Recalculate Instances using new state Filter = Live
14. NEW FEATURE: Media Upload for Excel files is improved.
15. NEW FEATURE: MyWraps now supports all properties CREATION and LASTMODIFIED wrap headers.
16. NEW FEATURE: XLW Holder Cells supports all properties from CREATION and LASTMODIFIED wrap headers.
17. BUG FIX: https://excelwraps.com/ now load exactly the same way as https://www.excelwraps.com/.
18. XLW V18.06.21 released.

Sprint 103 - 23rd May 2018

1. MoreVision Task Manager MyWraps report improved on the dashboard landing page.
2. Wrap ReadOnly check box is removed from the site dashboard or the Wrap Definition XML. This is now controlled from the Wrap Permission group.
3. MyWraps reports include hyperlinks using unique keys rather than WrapIDs.
4. MyWraps has faster filtering feature to improve performance. Additional enhancements will be available in future sprints.
5. MyWraps report can now filter on multiple signature fields.
6. MyWraps reports now extract additional signature details (sig-roles & sig-workgroup).
7. XLW now extracts more signature details using holder cells (User Profile Nick Name, User Profile First Name, User Profile Last Name, User Profile Company, User Profile Location, User Roles (csv list) and User WorkGroup).
8. Last Modification date in Dashboard WrapDefinitions view now appear to be in Server local time rather than UTC.
9. It is now possible to edit wrap definition properties from the site dashboard.
10. It is now possible to install a wrap definition without the need to recalculate instances.
11. It is now possible to selectively recalculate instances.
12. Wraps are now locked when importing instances to prevent confusing behaviour for end users.
13. Assignable roles now are arranged in alphabetic order when managing users and workgroups.
14. XLW Media upload height and width calculations are no longer depend on device points per pixel.
15. Wrap Media tiny small and zoom images are now re-created if Wrap Definition is updated.
16. Release XLW Version 18.05.23

Sprint 102 - 2nd May 2018

1. Dashboard controls to export instances based on filters and checkbox selection. 
2. Dashboard controls to delete instances based on filters and checkbox selection.
3. MyWraps can now list files contained in wrap media uploads.
4. Automated Build, Deployment and Unit Test verification.
5. MyWraps string filter on columns containing unique keys is enhanced.
6. MyWraps with a new Title parameter to overwrite the default MyWraps titles.
7. MyWraps Hyperlinks work with unique key query strings in place of wrap ID. 

Sprint 101 - 14th March 2018

We have jumped to sprint 101 as the team moves to a new location for 'agile' development.

1. Confirmation is now required before deletion of wrap instances via the red "X" at the bottom of a wrap.
2. MyWraps improvements to allow filtering on blank dates.
3. MyWraps Charts improved to prevent string handling complications.
4. WrapLinkLists have been enhanced so they can be used for unique keys.
5. Web app upgrade to conversion code (initially for Administrator testing).

The remaining enhancements listed below have been developed to better manage large Wrap data sets. This is the first instalment of our ‘Big Data’ initiative with additional functionality is being planned for the next sprint. Such powerful tools require careful handling so they are only available to MoreVision Administrators.

1. Previous 32 bit zip algorithm limits zip file to about 2GB. This is enhanced to 64 bit which allows ExcelWraps to create much larger zip files. This was done at the request of Brush Traction who wanted to archive a 13.5GB wrap instance collection. Most of the data is uploaded media, the wrap metadata files are insignificant in comparison.
2. Speed improvements for listing large numbers of wrap instances in the back end. This has been achieved by moving MyWraps *** WARNING: Data Limited to MaxRows of 500 *** to the site dashboard. The ….&Options.MaxRows=600 or similar can be added to a dashboard URL to increase the MaxRows limit if required.
3. XLW can now generate Wrap Instance XML files which can be imported from the wrap instance listing page. This introduces a new XLW WRAPINSTANCE() function followed by up to 26 pairs of cell name and cell value separated by commas. Cell names that are unique keys are specified and the combination of unique keys will identify a particular wrap instance (a new unique key combination will create a new instance or an existing unique key combination will update cell values in an existing wrap instance). It is also possible to poke in wrap instance creation date, Wrap Instance creator, wrap instance AdminFreeze Boolean, wrap instance Freeze Boolean and wrap instance awaiting signature Boolean.This method is a direct modification of values in the database and care must be taken that the calculation method in the wrap definition is consistent. 
4. Administrators can import new Wrap Instance XML files created using XLW new WRAPINSTANCE() fuction. A new new ‘Import Instances’ button on the Dashboard wrap instance listing will load in the file. It can both create new and update existing wrap instances.
5. 'Import Instances' is much faster method than our ‘Recalculate Instances’ method, which requires each instance to be recalculated by a browser and is more appropriate for large data sets (wraps with many Wrap Instances).
6. 'Import Instances' is much faster method than our  ‘Initialise Instances’ method for pre-population, which requires each instance to be recalculated by a browser and is more appropriate for large data sets (wraps with many Wrap Instances).

Sprint 49 - 12th December 2017

1. New MyWraps MaxRows feature.
2. New MyWraps csv type. Comma separated values in a cell will be presented as a list in a MyWraps report.
3. Improved User importing feature.
4. Improved site setup recipe.
5. Configurable Google Analytics in site setting. 
6. XLW new XML Export feature for Data Migration to Wrap instances. This feature was required to migrate 15 years of legacy data for new Siemens Rail Wrapsite.

Server RAM Increased - 30th November 2017

1. Server RAM has been increased by a factor of 4. We had reports of sluggish performance on Thursday 16th November. This turned out to be because our service provider was running some background maintenance processes. The increase in RAM will reduce the impact of this plus we have rescheduled so that these tasks are always run out of normal hours. We have already noticed that the site is more responsive and snappier.

Sprint 48 - 13th November 2017

1. New wrap pre-population button - A new "+" button is added at the bottom of a wrap to automatically create all wraplink. In an overhaul application this will allow users to track un-started work as well as finished work in MyWraps reports.
2. Pre-poulation will further optimise our 'Matrix and Morph' technique making it even quicker than before! This development could use MyWraps to replace the current WrapMaps (e.g. 'Unit Management' and 'Sign Off Lists'). Since MyWraps are generated by the server navigation will be faster and easy to customise. It would make introducing a new 'Job Matrix' almost instantaneous.
3. Auto-numbering better handles missing numbers in auto-number sequence.
4. Increased speed of wrap loading time by optimising database role checking queries.
5. Change header color on staged wrapsites so that they cannot be confused with live wrapsites.
6. Security improvements to achieve A rating using Security Headers Assessment by implementing the following:
   • Content Security Policy is an effective measure to protect your site from XSS attacks. By whitelisting sources of approved content, you can prevent the browser from loading malicious assets.
   • X-XSS-Protection sets the configuration for the cross-site scripting filter built into most browsers. Recommended value "X-XSS-Protection: 1; mode=block".
   • X-Content-Type-Options stops a browser from trying to MIME-sniff the content type and forces it to stick with the declared content-type. The only valid value for this header is "X-Content-Type-Options: nosniff".
   • Referrer Policy is a new header that allows a site to control how much information the browser includes with navigations away from a document and should be set by all sites.
7. XLW debugging improvement - widgets shades first column in Excel to indicate that a row is being hidden.
8. New XLW widgets to configure our multi-role wrap solutions (e.g. where staff, subcontractors and clients share information in a single wrap). Currently this is achieved using custom widgets these new XLW tools will automate the process completely.
   
   • Tab lock-out for users with a particular 'role' (e.g. staff, subcontractor or client). Lock-out means you can see wrap inputs but you cannot change them.
   • Tab lock-out linked to a wrap signature. Once signed nothing can be changed.

Sprint 47 - 11th October 2017 at 22:00

1. MyWraps data base optimisation to handle more appended wraps.
2. MyWrapsGeneratorII is released making it even easier to generate MyWraps report URLs.
3. MyWraps Chart improved 'points' series rendering.
4. MyWraps can now Average a column of dates and datetimes.
5. MyWraps new filters ('eq', 'lt' and 'gt' already exist).
   • 'le' - less than or equal
   • 'ge' - greater than or equal
   • 'ne' - not equal
6. MyWraps now filters for blank values using eq()
7. MyWraps now filters on non-blank values using ne()
8. MyWraps can re-cast values into many TYPEs (string, integer, double...)
9. ExcelWraps templates now supports even bigger screens (4K UHD). 
10. XLW warns if you links to an external workbooks.
11. XLW shows disable color when a row is being hidden by a rowhide or row show widget.
12. XLW validation optimised for large workbooks.

Sprint 46 - 4th September 2017 at 22:00

1. Prevent users being created with no user 'Nick Name' (this is used as part of digital signature).
2. Press return or enter on digital signature dialog to automatically submit (without pressing the 'Submit' button).
3. Press return or enter key in a MyWraps filter box to automatically filter (without pressing 'Filter' button). 
4. XLW release 17.08.22.
5. MyWraps now supports OAdate and OAdatatime (Excel's universal date and datetime format).

Sprint 45 - 21st August 2017 at 22:00

1. Speed improvement for large wraps.
2. Improvements to Matrix and Morph technique.
3. Allow multiple freeze signatures on wrap instance.
4. Wraplinks never update once the wrap instance is frozen to reflect the state at time of sign off.
5. Administrator password reset clears number of failed login attempts to provide an exception to site penetration protection feature.
6. AND and OR logic added to USERSELECTOR feature.
7. Multi-role shared wrap instances can now be achieved with role based read-only tab controls.
8. MyWraps 'Signed by me' report improved.
9. Chart data point link button improved.
10. Clearer identification of wraplink target cells (blue font plus yellow background).
11. Media upload icons improved.
12. Addition of insurance policies.

Sprint 44 - 26th June 2017 at 22:00

1. Database caching implemented delivered up to 360% speed improvement when wraps contain many wraplinks.
2. Limitless points in MyWraps chart reports (a 1000 point arbitrary limit was removed).
3. Addition of new WRAPLINKAGGREGATE() functions including COUNT, COUNTA, COUNTBLANK.
4. Disaster recovery policies reviewed in light of British Airways IT failure.
5. XLW validation speed improved for wraps with many input cells.
6. XLW speed profiling tools added.

Sprint 43 - 1st June 2017 at 22:00

1. Improved AdminTenant Controls for ExcelWraps Permission Groups.
2. Increase maximum Wrap Media Upload file size to 64MB to support video file uploads at a client's request. Introduction of Fair Usage Policy ExcelWraps user charge assumes that an average user requires 2GB of file storage (i.e. a 50 user system is contained within 100GB). Typically Wrap data storage is extremely compact and this limit is unlikely to be exceeded. However some Client's may require larger file storage capabilities and in these circumstances MoreVision will provide additional space for an additional monthly cost.
3. Restyled MyWraps Reports so that more information can fit on the screen.
4. Remove carriage return and line feeds characters from MyWraps reports so that appearance can be better controlled and MyWraps charts can be correctly displayed.
5. MyWraps automatic typing of date and datetime data.
6. Administrator override when Wrap definitions are locked (i.e. when recalculate instances is triggered)
7. Administrator password tab now showing in site dashboard user menu.
8. User import/export controls improve to include user workgroups.
9. Wrapsites can be configured to suppress printing. A client requested this feature so that paper copies are never allowed and that the site content becomes the only controlled copy.
10. XLW improved automatic cell naming for HTML Widgets.
11. XLW will prevents double validation of Excel files.
12. XLW v17.06.01 released.

Sprint 42 - 20th April 2017 at 22:00

1. Server Software improved to allow users to create new accounts.
2. New Wrap Row Show Widget
3. New Text Export Widget
4. New image hotspot widget
5. Server Software improved with automated build and deployment script to verify Unit and QUnit tests pass.
6. Server Software improved with site setup recipe
7. Wraps improved to so that user css or javascript refreshes are never required.
8. Server Software improved with automated test tools for driving the web site.
9. Site improved with updated Help pages.
10. As Developers we need to ensure no client data is on development machines.
11. New XLW border line controls to complement native Excel border controls.
12. XLW now shows Wrapsite and Wrap group information in XLW validation dialog.
13. Release XLW v17.04.20

Sprint 42 - 14th March 2017 at 22:00

1. Wrap load time improvement - Wrap permissions database is optimised with a dramatic reduction in wrap load time (17 fold improvement in the worst cases). 

Sprint 39, 40 and 41 - 8th March 2017 at 22:00

1. Low severity security vulnerabilities identified OWASP ZAP have been removed.
2. Assessment of OWASP top ten vulnerabilities including A1 Injection; A2 Weak authentication and session management; A3 XSS; A4 Insecure Direct Object References; A5 Security Misconfiguration; A6 Sensitive Data Exposure; A7 Missing Function Level Access Control; A8 Cross Site Request Forgery; A9 Using Components with Known Vulnerabilities; A10 Unvalidated Redirects and Forwards.
3. Addition of anti-spam CAPTCHA controls on site comment feature and contact us feature. These apply to anonymous visitors only (users who are not logged into the site).
4. Upgrade to latest release of CMS 1.10.2.
5. Simplification of site controls and dashboard for AdminTenant to provide protection against possible corruption. Management of some CMS features can now only be undertaken by Administrators including Roles, Modules, Site Settings, Themes, WorkFlows, Import/Export, Spam Controls, Custom Forms, Queries, Content Definition, Widgets, Tenants and Reports. Please note that AdminTenant's still retain permission for Wrap Import/Export Wrap and MyWraps reports. 
6. User 'Creation Time' and 'Last Login Time' now available on the 'User' menu on the site dashboard. 
7. Configurable password controls added - Password must contain at least one lower case letter (a-z); Password must contain at least one upper case letter (A-Z); Password must contain at least one number (0-9); Password must contain at least one special character (e.g. !@#$%^&*(){}[].); Set Minimum Password length; Set Password expiration (30 days by default); Set Password format (hashed or encrypted);
8. Support for users without email address - Many organisations do not supply all their staff with email addresses which is required for our 'Lost Your Password' routine. We have devised an alternative method which requires the support of site Administrators to reset user passwords and pass it onto users with no email address. When the user first logs in with the administrator's reset password the user is forced to reset the password to one of his own. This ensures that only the user ever knows his own passwords and digital signatures cannot be falsely obtained.
9. Set site lockout after failed attempts to login (15 minute lockout after 4 failed login attempts).
10. Configurable session timeout after a period of inactivity (default 15 minutes). Re-direction to login page after session timeout.
11. All client data removed permanently from developer machines (now only on ISO27001 compliant secure servers).
12. Internal development team audit to demonstrate compliance to the newly instigated ExcelWraps Security Policy.
13. Addition of WrapLinkAggregate functions in Wraps.
14. Data sent to only Axis Label or Tooltip in MyWraps Reports.
15. XLW Rejects Excel tabs starting with a number (potentially problematic for wrap creation).
16. WrapLinks can now extract all signature details ('&filter-sig-detail=cell'; '&filter-sig-summary=cell'; '&filter-sig-datetime=cell'; '&filter-sig-date=cell'; '&filter-sig-time=cell'; '&filter-sig-firstname=cell'; '&filter-sig-lastname=cell'; '&filter-sig-nickname=cell'; '&filter-sig-company=cell'; '&filter-sig-location=cell').
17. Wraplinks do not automatically update if the wrap state is 'frozen' which could trigger a recalculation and an error warning that you cannot change a frozen wrap instance.
18. Option to use non-minimised javascript to assist developers with wrap debugging.
19. Comment feature now has simpler interface.
20. MyWraps Aggregate AVERAGE function now ignores null values (the same behaviour as Excel's AVERAGE function).
21. AutoNumbers must now be explicitly defined in WrapLinks to provide improved error messages.
22. Addition of keyword WrapName in MyWraps reports which is useful for MyWraps reports with 'appended' wraps.
23. Release of XLW v.17.03.08

Sprint 38 - 1st November 2016 at 22:00pm

1. Optimisation of 'Matrix and Morph' solutions. Faster wrap load time.
2. Optimisation of 'Matrix and Morph' solutions. Faster report generation times by introduction of unique key pre-filtering algorithms.
3. Improved keyboard selection and MyWraps reporting. Automatic 'type' definition (text, number, date, datetime) for keyboard selection on tablet and phone devices and also default typing in MyWraps reports.
4. Improved WrapLinks now includes  to indicate that a user does not have correct permissions to create a new wrap instance. E.g.  will be shown to users with an electrical competence when the wrap is intended for users with a mechanical competence and vice versa. If you do have permission to create a new instance  is shown.
5. New version of XLW 16.11.01 to support new site functionality.

Sprint 37 - 12th October 2016 at 22:00pm

1. Improved keyboard selection responsive to cell contents (text or numeric keyboards - iOS short numeric keyboard suppressed as decimal point is not available).
2. Improved leave/stay warnings when navigating from a wrap instance.
3. Improved Aggregate functions in MyWraps reports (better handling of null values).
4. Improved WrapLink functionality (nothing displayed when URL="").
5. Improved Holder cell functionality to support UserCount with role selection logic.

XLW version 16.10.07 - 7th October 2016

1. Fixed Circular reference error if cell name matches XLW function.
2. New XLW Version Checker added.
3. Improved About XLW and Subdomain Controls.

XLW version 16.09.26 - 26th September 2016

1. Improved Holder cell to include UserCount function.
2. Improved status checking of Validation form.
3. Hyperlink widgets cell naming improved.
4. Improved sub-domain selector controls.
5. Cell naming enforced for all input cells (read-only relaxation removed).
6. Cell naming enforced for WrapLinkList cells.

Sprint 36 - 30th August 2016

1. Two dimensional zoom feature in MyWraps Chart Reports.
2. Wider filter text boxes in MyWraps Tabular reports.
3. Improved formatting to ‘visible’ Holder cells.
4. Export Wrap Excel source file with an without collected data.
5. Frozen wraps never update – all data frozen, even wrap links (never update and never trigger recalculation).
6. Security improvement – role administrator can never be assigned.
7. Bug fix – MyWraps handles cell values containing ‘ characters.
8. Enhanced user interface - Users warned if they move off a wrap without saving data.
9. More detail included in email notification (the domain, the wrap, the unique keys from the wrapinstance, the name of the signature cell, a link to my inbox to remind people of the inbox feature)

Sprint 35 - 3rd August 2016

1. MyWraps enhancement to append results from many wraps.
2. Improved MyWraps Aggregate functions.
3. MyWraps header colour change and filter box size change.
4. Improved syntax for MyWraps alias.
5. Userdropdown to include ‘SELECT!’ prompt and allow unselection of users.
6. Improved user feedback when a new wrap instance is created.

Sprint 34 - 1st June 2016

1. WORKGROUPS - Users may be placed into a Workgroup which define separate business areas.
2. User management of workgroups can be devolved to the role of 'AdminWorkgroup'. AdminWorkgroup can manage users in their own workgroup (add new users, disable users, assign roles). AdminTenant releases particular roles into a workgroup to limit the roles available to AdminWorkgroup. In the context of competence management it makes more sense for a local AdminWorkgroup to be responsible for user management rather than a remote Administrator.
3. Access to Content - Think of a WorkGroup as a ring fence around a set of users. If you are in a WorkGroup you can only see things within the WorkGroup and not outside of it. A WorkGroup restricts access to a single business area, it can be set to 'none' if you do not wish to set any WorkGroup restrictions.
4. Local Time Zone - Workgroups may be located in a different time zone to the core business. Wraps belonging to this workgroup will operate in the local time zone.

Sprint 33 - 27th April 2016

1. WORKGROUPS - Enhance WorkGroup for user management and access controls to all content type.
2. WORKGROUP trust settings. 

Sprint 32 - 14th April 2016

1. New Graphics on Wrap buttons.
2. XLW widgets automatically named. 
3. WrapLinkLists.
4. UserDropDown.
5. Wrap expanded view option.

Sprint 31 - 30th March 2016

1. Restrict email notifications within WorkGroup.
2. Site template changes. 
3. Removal of Wrap reset button.
4. Removal of Wrap Update button and replace with intelligent automatic updates.
5. Addition of UserDropDown control.
6. WrapLink motifs redesigned.

 Release notes page started with Sprint 31 (previous sprint release notes available in source code repository).