(ORG-9044)
Subrange notation such as [i-5:i+5] can be used to perform calculations over a range of cells.
For example:
- Fill column A with row numbers.
- Open Set Column Values dialog of col(B).
- Choose Formula: Load Sample: Moving Standard Deviations and click OK.
Then column B will be filled with the running-standard deviation over 11 points, at every row, based on the data in column A.