Thank you for contacting us.
When using some function in a cell the result from this function is returned only to the owner cell. That said when you return ArrayExpression it is returned only in the cell that uses your function and not in the neighbouring cells. However, this result may be used by other functions that accept arguments of type array.
Here are a few examples on using Array expressions. Let's take for instance this expression:
This is an array expression with two rows and three columns. On the first row the values are "1", "2" and "3", while on the second the values are "4", "5" and "6".
This expression may be used by different functions. Let's take for instance the INDEX function which returns elements from an array argument. The following function call for example returns the element from the second row and the first column of the array.
So the result of the above expression is "4".
The following function call returns the second column from the array argument as another ArrayExpression:
If we need to use the result from this function to sum the elements from the second column we may write the following:
The result from the last expression will be 7 as it sums 2 and 5.
I hope this is helpful. If you have any other questions or concerns please do not hesitate to contact us again.
the Telerik team
Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer
and share your thoughts.