Get to know ExcelWraps from the inside. Learn what you can do to make your wraps run much faster.
Excel is a powerful development tool. We strive to support everything that can be done in Excel also with ExcelWraps, but there are a few common pitfalls that all ExcelWraps developers must know about.
Any visible data you add to a wrap will make it slower. Every cell must be fetched from the database, rendered by the browser, then saved back to the database. Dynamically hidden data, e.g. using HideRowIf(), also slows the wrap down.
Avoid having more cells in a wrap than you would have used in the corresponding paper form. If you want to provide easy access to supplemental data, use Wraplinks or text links.
Saving intermediate results in sheets, rows, and columns that are hidden in the Excel template using Excel methods costs very little.
Every cell will be delivered to your device and will contain a value that needs to be stored in the database. Hold down the Ctrl key while you press the End key to select what Excel considers the last cell in your spreadsheet. If Excel doesn’t select the expected cell, your spreadsheet may be carrying dead weight that will also become part of the wrap. Note the row and column number of the selected cell before you remove the surplus cells.
We encourage you to use all the signatures required by the business in your wraps – it is one of the major strengths of ExcelWraps. If you insert more than three signature fields on the same tab, however, you may be doing something wrong. Don’t create an electronic form in a way that you would never consider for a paper form.
If your business needs do dictate that a wrap has many signatures, you may get a performance improvement from running the wrap as a TeamWrap.
Clients often want a Dashboard Wrap that pulls in a lot of summarized data. Waiting while these sums, averages, and other aggregates are calculated in MyWraps will slow down the loading of the Wrap significantly.
It is more efficient to start with a small dashboard that only shows the essential numbers, and then zoom in on any interesting data using Wraplinks or text links to other wraps that provide more detail.
There may also be ways to use checkboxes or similar to dynamically activate selected areas of a dashboard on demand. Contact Client Services to learn more!
Cells are faster when they know what type of information they will be holding. A cell that can hold either a number or text will be slower to access than a cell that knows it will contain only a number or a cell that knows it will take only text.
You would never do something like this, would you? Inserting a text string in a numeric field will not only reduce performance considerably, it may also introduce errors when a text value is used in calculations. Read more about how to use numeric formats for error messages.
Another common example is zero suppression, where an otherwise numeric cell is set to an empty string or blank if it is zero.
You would never do something like this, would you? Again, inserting a text string in a numeric field will slow down your wrap even if the string is empty, and may introduce errors when empty string values are used in later calculations. Read more about how to use numeric formats for zero suppression.
WraplinkAggregate2 is much faster than MyWraps2.
With MyWraps2, avoid asking for more than three columns of data.
Don’t use HideRowIf or HideColumnIf for unnamed fields.
Secondary Hyperlink cells that could be replaced by a HyperlinkLong function.
Short string MyWraps is almost 6 times as fast as full MyWraps links.
This MyWraps report takes 9.29 seconds to load:
TaskManager?Options.Columns=Task(taskquery).string,Raised(created).date,Initiator(clientimplementer).string,Category(costcentre).string,Priority(priority).string,Deadline(deadline).date,EW Response(responsecomments).string,Days(estimateddays).double,Team(xlwteam).string,EW Quoted(actionedby).sig-date,EW Price(pricequoted).double.C2,HRL Approved(raised).sig-date,Completed(responseactioncomplete).sig-date,Closed(closeout).sig-date,PO(purchaseorderno_).string&Options.Aggregates=Days.sum,EW Quoted.counta,HRL Approved.counta,Completed.counta&Options.AggregatesOnly=False&Options.SortBy=PO.desc&Options.State=Live&Options.Creator=Any&Options.AutoNumberFilter=None&Options.MaxRows=500&Filter.PO=5500
If you only need the days aggregate this link loads in only 2.69 seconds:
TaskManager?Options.Columns=Days(estimateddays).double,PO(purchaseorderno_).string&Options.Aggregates=Days.sum,EW Quoted.counta,HRL Approved.counta,Completed.counta&Options.AggregatesOnly=true&Options.SortBy=PO.desc&Options.State=Live&Options.Creator=Any&Options.AutoNumberFilter=None&Options.MaxRows=500&Filter.PO=5500
Knowing MyWraps Syntax give more compression that results in this link, that takes just 1,62 seconds to load: