Microsoft has recently announced that they will be adding dynamic array formulas into Excel. This functionality is already available for a number of users on the Office 365 platform, but widespread release should be coming soon. Dynamic array formulas are the solution to the decades long problem of array formulas. With SpreadsheetWEB 6.9, we’ve introduced support for dynamic array formulas and utilizing spilled ranges in web applications. We are excited to see this feature come into Excel, as it will remove a huge burden from building complicated data models.

Currently, you have to combine several formulas and use “helper” fields to generate tables or lists that are dynamically generated. One example of this concept is dependent dropdown inputs. For example, assume that you have a wide range of products, categorized by manufacturer, product size, and cost. In order to create multiple dropdown inputs and narrow down the results with each selection, you would need to use nested X formulas across several columns. With dynamic array formulas, you’re going to be able to do this with one formula. Along with the addition of these formulas, a new “spill” concept was also introduced. Array formulas (the new ones and the existing formulas) can now spill their results into neighboring cells, removing the need to guess how much space the outcome will require.

Data transparency, and accessibility to user data has recently been a very popular subject. Increasing worldwide awareness on this issue has helped countries develop measures behind allowing individuals have more control over how much of their data is kept by companies. For this, we have introduced the ability of downloading all your personal data that is kept on the SpreadsheetWEB platform with the click of a single button. This feature is accessible from the My Account page, and gives an Excel export containing all data our system has about the individual.

dynamic array

In addition to various bug fixes and other small improvements, we’ve also made substantial improvements in our backend that resulted in considerable improvement in application load and calculation times with 6.9 version. Some of these changes should also positively affect our users who are using our public cloud from remote locations.

In this update, we focused on giving our users a more transparent platform, where they can use the latest Excel features, and we hope that you’ll like these new features as much as we do! For a full list of changes, fixes, and new features, please see our user guide.

Also, designer applications now support combo charts. Check them out below!

You can sign up for a 14-day free account and transform your Excel models into full-blown web applications in no time.