GNOME Bugzilla – Bug 570689
non-contiguous arrays
Last modified: 2010-07-13 07:44:03 UTC
I would like to construct a non-contiguous arrays containing variables to use in various functions such as slope and linest. Using functions such as slope({1,2,3,4},{1,2,3,4}) or slope(a1:a4,a5:a8) work but the combination of variables and non-contiguous arrays do not work "slope({a1, a2, a4,a5},{a6, a7,a8, a10}). I haven't found any spreadsheets which allow non-contiguous arrays but I can't be the only person who would find this useful. Thank you
@Morten: I am wondering whether an easy solution would be to introduce a new function c(...) or array(...) that evaluates to an array with the given entries, so that instead of "slope({a1, a2, a4,a5},{a6, a7,a8, a10})" one could write "slope(c(a1, a2, a4,a5),c(a6, a7,a8, a10))".
I have added a new function ARRAY that can be used for this purpose, eg. slope(array(a1, a2, a4,a5),(a6, a7,a8, a10)) ARRAY by itself creates a vertical array from its arguments. The arguments can be any other expressions. This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.
Andreas: I am not sure this is going to do what you want in the general case. For example, it kills the handling of missing data.
*** Bug 553044 has been marked as a duplicate of this bug. ***