...
Formula column label row (ORG-6669)
User can right Right click workbook title and choose View: Formula to turn F(x ) to turn on/off the formula onlabel row. Then type formula directly using the same syntax as used in Set Column Values dialog. E.g. col(B)-col(A), sin(col(A)), i*2, etc.
User You can also open use Set Column Values dialog as before to set formula. The formula label row will update.User can also uncheck Options: Direct Edit Formula Cell, and then choose Options: Formula Text... to type in some explanation of the formula, in cases like formula
is complicated, etcAn Options menu has been added to Set Values dialog, where you can control whether direct editing of the formula in the label row should be permitted or not. The Formula Text menu item can be used to enter explanatory text for the formula, which will instead be displayed in the fomula label row.
Support subrange notation in Formula (ORG-9044)
E.g. enter 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 some data
- Enter StdDev(col(A)\[i-5:i+5])
...
- as the formula for column B. Then column B will be filled with the running-standard deviation over 11 points, at every row, based on the data in column A.
More built-in Functions added – todo (ORG-8781 ORG-7697 ORG-8945)
Different Multiple moving average functions are have been added under F(X): Statistics: menu.:
E. g. Exponential Moving Average, Modified Moving Average, Triangular Moving Average, Weighted Moving Average
...
Keep Text option (ORG-8555)
In the past versions, if there are text in some data rows of a column, Set column value will change them into missing values.source columns mixed text and numeric entries, setting values to another column using a formula would result in missing values in rows that had text entries. A Keep Text menu item is now available in the Options menu of the Set Values dialog. This will allow for the text values to be carried over to the output column.
