Set Column Value Improvements (ORG-9021)
Formula column label row (ORG-6669)
User can right click workbook title and choose View: Formula to turn the formula on.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 can also open Set Column Values 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, etc.
Support subrange notation in Formula (ORG-9044)
E.g. enter StdDev(col(A)\[i-5:i+5]) in Formula to do running statistics
More built-in Functions added – todo (ORG-8781 ORG-7697 ORG-8945)
Different moving average functions are 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, if there are text in some data rows of a column, Set column value will change them into missing values.