outY

Auto

range inY = Col(perm);
dataset outY;//range outY = Col(permReg); //range outY = [??]!tmpOutY;
range T = Col(TSmooth);
const nWindow = %(wcol(_ThisColNum)[P1]$); //query parameter row of column permReg
const zeroFix = 1;

// use of x-function smooth
// http://www.originlab.de/doc/X-Function/ref/smooth
smooth -r 0
	iy:=(,inY )
	oy:=(,outY)
	method:=le
	polyorder:=3
	prop:=0
	npts:=nWindow
	boundary:=none;

outY *= T_REF/T;

if (zeroFix > 0)
{
	const minY = min(outY);
	outY -= minY;
}

• (1) I want to use the parameter row to select the window size of the smoothing function, which is working. But auto-recalculate doesn't work, when I change the parameter value. Either, I have to change a value in col(TSmooth) or otherwise have to run the command run -auf 0 0 to trigger all calculations on the sheet. Can I do something to change this behaviour?


• (2) On a side note: I tried setting the output as range outY = Col(permReg);, which would sometimes lock the permReg column despite the -r 0 attribute (of course, I had set the column value set to empty). Why is that?


• (3) Another side note: range outY = [??]!tmpOutY; would sometimes add rows at the bottom and I would like to know why and how it differs from my final solution of dataset outY;, which produces the desired behaviour.

col(B)=
  col(A)+pp
Before Formula Scripts:
  pp=value(col(A)[P]$);