Improve array formulas to support matrix with different number of columns

Progress® Telerik® UI for ASP.NET MVC Feedback Portal

Create an account Log In

Back to Feed

Request a Feature Report a Bug

Unplanned

Last Updated: 23 Dec 2019 09:36 by ADMIN

Andrea

Created on: 20 Dec 2019 17:54

Category: Spreadsheet

Type: Feature Request

Improve array formulas to support matrix with different number of columns

Hi,

I have identified a discrepancy in behavior of Telerik Spreadsheet vs Excel in treatment of array formulae (multiplication of arrays)

The spreadsheet attached contains two examples on how the difference on how Excel and Kendo spreadsheets handle array formulas is impacting the tool I'm developing.

The first example is a simple multiplication between a one-column range and a two-column range. Since both have the same number of Rows, Excel multiples both columns of Array 2 by the Array 1 and sum them
Kendo instead expects both ranges to have the same dimensions, so the same array formula throws an error when opened on Kendo

The second example is a the sum of a multiplication between two same-sized matrixes, but conditioned to a flag array. If the flag for that row is true, then the multiplication of the elements of that row should be added to the final result. On Excel, it works as expected.
On the other hand, Kendo seems to consider the “Flag” matrix as a 2-column matrix with the second column left blank, so the result is the multiplication of the first column of array 1 by the first column of array two, conditioned by the flag array:

You can check the results uploading the attached spreadsheet to the Demo available online: https://demos.telerik.com/kendo-ui/spreadsheet/index

Please let me know your feedback and when/if we can expect an alignment of Spreadsheet behavior to Excel's

Kind regards
Andrea

Attached Files:

array-multiplications.zip

1 comment

ADMIN

Veselin Tsvetanov

Posted on: 23 Dec 2019 09:36

Hi Andrea,

Just to clarify, what is currently missing the Kendo Spreadsheet is support for Array formula manipulations that involve calculations between a matrix with a single column and another with two columns. Array formulas in Spreadsheet will always expect the first and the second matrix to have the same number of columns.

The requested improvement in the Spreadsheet functionality would be a valuable addition to the widget. Therefore, I have converted the current thread to a feature request in our Feedback portal. Here is the public item, where you could cast your vote:

https://feedback.telerik.com/aspnet-mvc/1447062-improve-array-formulas-to-support-matrix-with-different-number-of-columns

Concerning whether and when the discussed would be included in our implementation queue, that would depend on the interest among the community for the above. That is why I would suggest you to keep tracking the discussion on or Feedback portal.

As a small token of gratitude for bringing the above to our attention, I have updated your Telerik points.

Regards,
Veselin Tsvetanov
Progress Telerik

Get quickly onboarded and successful with your Telerik UI for ASP.NET MVC with the dedicated Virtual Classroom technical training, available to all active customers.