openmolecules.org Forum - RDF feed
https://openmolecules.org/forum/index.php
Creating text in a column via macro
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=350&th=124#msg_350
I'm trying to create a macro that will tidy up data and create some new columns. One of the columns will change every time and would need input from the user. I tried the following in the process
1) define variable - gave it a name and left value blank
2) Add calculated value - in the formula I put the variable name in step 1
When I run the macro, I get asked the value of the variable, which I complete, but it then doesn't populate all the rows of the calculated column with the variable in step 2. Is this the correct approach, if so what am i doing wrong? Or should I be doing it another way?
Thanks,
Angus]]>amorrison2018-05-12T03:40:11-00:00Re: Creating text in a column via macro
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=351&th=124#msg_351
I admit that currently the handling of explicit variables is neither consistent not complete.
It is very new and was done as a (possibly to quick) solution for an internal problem.
You can refer to you variable in task 2 (formula for calculated values), if you put a '$' sign ahead of the name.
When solving the equation for every row, the expression calculator treats your variable input as a column name.
If such a column exists, the row's value of that column (and not your input value) is used when solving the equation.
I am not sure, whether this is already part of 4.7.2, it certainly is in 4.7.3, which is the current Windows download.
Thomas]]>thomas2018-05-12T22:12:10-00:00Re: Creating text in a column via macro
https://openmolecules.org/forum/index.phpindex.php?t=rview&goto=352&th=124#msg_352
Thanks again,