Dear all, I am looking for a way to apply an fft filter on all columns of sheet1 and report the results in columns of sheet2. I am trying to do that using the before formula script. fft_filters 1!col(1) oy:= (2!col(1));
I have tried this code but it did not work : fft_filters 1! oy:= (2!col(1));
I just found this script, which is working well: range r1=[book1]sheet1!; for(ii=1; ii<=r1.nCols; ii++) { range ss = [book1]sheet1!col($(ii)); range dd = [book1]sheet2!col($(ii)); fft_filters (ss) oy:= (dd); }
script for fft_filters on all columns in a sheet
Posted - 08/26/2017 : 07:17:04 AM
