| T O P I C R E V I E W |
| pfornage |
Posted - 02/07/2018 : 03:59:08 AM
Origin Ver. and Service Release (Select Help-->About Origin): Origin 2018 64 bits
Operating System: windows 7
Hi,
Is there a shortcut or a command to execute the forumla entered in F(x)= column header in one or multiple books?
I created a book template with fomulas on some columns.
I then import raw .txt file in this template, but I have to manually click into each F(x)= case for origin to execute the formula on the columns values.
Is there a way to avoid that ?
Thanks.
Patrick |
| 5 L A T E S T R E P L I E S (Newest First) |
| pfornage |
Posted - 02/12/2018 : 03:52:01 AM
Tried it this morning, it works.
Thanks a lot snow! |
| snowli |
Posted - 02/09/2018 : 3:39:25 PM
It looks all your column's calculation is on the column itself.
There are several methods to do this:
1. Choose Format: Worsheet...
On Script tab, enter
run -wu %H; //execute all column formula in active sheet of current workbook
Check "After Import" checkbox.
Then save the workbook as template and import data into it.
The script will be executed every time when data is imported.
2. Or in Import dialog, there is a Script After Each import node.
You can enter the above script so after import the script will be executed.
You can save such import dialog setting as a Dialog theme and in the future, load such import theme in the dialog.
Thanks, Snow
|
| pfornage |
Posted - 02/08/2018 : 04:11:24 AM
I actually created a template.
And now the book after importing data into the template.
I want the values of column A to be 0.5 ; 1 ; 1.5 ; etc...
To do it, I have to manually click into the f(x)= cell, and press enter.
I would like the template to execute it automatically when importing data.
Thanks for your help!
Patrick |
| cpyang |
Posted - 02/08/2018 : 12:00:23 AM
Why not enter the needed formula into Fx and save the template?
CP
|
| arstern |
Posted - 02/07/2018 : 10:25:49 AM
Hi Patrick,
You can select the F(X) box and then select Ctrl+Q which is somewhat quicker than right-clicking the F(X) box and selecting Open Dialog.
Here is a link to Origin's Hotkeys:
https://www.originlab.com/doc/Origin-Help/HotKey-in-Origin
-Aviel
OriginLab |
