loop (ii,1,ArrSamples.GetSize()) //ArrSamples is a string array holding all workbook names
{
	//Define columns with range variables
	range rAl = "Al";
	range rSi= "Si";
	range rCa = "Ca";	
	string strSi$ = [%(ArrSamples.GetAt(ii)$)]%(ArrSamples.GetAt(ii)$)!($(rAl.index),$(rSi.index),$(rCa.index));

	//The string sNameG_SiTemp$ is the graph name, defined somewhere else.
	//The code generates a new ternary graph if the name doesn't exist; if it does, it creates a new scatter plot in the same layer
	if (Exist(%(sNameG_SiTemp$),3) == 0) outTern$ = <new template:=ternary>;
	else outTern$ = 1!;
	win -a %(ArrSamples.GetAt(ii)$); //Activate book with item index (ii)
	plotxyz iz:=%(strSi$) plot:=245 ogl:=[%(sNameG_SiTemp$)]%(outTern$);
}

quote:

---

RAL.INDEX: error setting property value!
RSI.INDEX: error setting property value!
RCA.INDEX: error setting property value!
Failed to resolve range string, VarName = iz, VarValue = [A550C360d1p5z]A550C360d1p5z!(--,--,--)

---

quote:

---

Originally posted by Clairekun

Origin Ver. and Service Release (Select Help-->About Origin): 2018b
Operating System: Win10

Hello,

I have several workbooks with mutiple columns each. I need to plot the columns Si, Al and Ca, but they don't always have the same column index. So I wrote the following code:

loop (ii,1,ArrSamples.GetSize()) //ArrSamples is a string array holding all workbook names
{
	//Define columns with range variables
	range rAl = "Al";
	range rSi= "Si";
	range rCa = "Ca";	
	string strSi$ = [%(ArrSamples.GetAt(ii)$)]%(ArrSamples.GetAt(ii)$)!($(rAl.index),$(rSi.index),$(rCa.index));

	//The string sNameG_SiTemp$ is the graph name, defined somewhere else.
	//The code generates a new ternary graph if the name doesn't exist; if it does, it creates a new scatter plot in the same layer
	if (Exist(%(sNameG_SiTemp$),3) == 0) outTern$ = <new template:=ternary>;
	else outTern$ = 1!;
	win -a %(ArrSamples.GetAt(ii)$); //Activate book with item index (ii)
	plotxyz iz:=%(strSi$) plot:=245 ogl:=[%(sNameG_SiTemp$)]%(outTern$);
}

After creating the first graph, the following error appears:

quote:

---

RAL.INDEX: error setting property value!
RSI.INDEX: error setting property value!
RCA.INDEX: error setting property value!
Failed to resolve range string, VarName = iz, VarValue = [A550C360d1p5z]A550C360d1p5z!(--,--,--)

---

If I test strSi$ (excluding the plotting part of the code), the column indexes show just fine for all workbooks. It is only when I try to plot it that it magically can't find them anymore.

If I set fixed index numbers, i.e. (2,3,4) instead of the range-based indexes, it works perfectly; however, the column indexes aren't always the same.

I feel like the solution is obvious but I can't find why the code isn't working.

Thank you.

---

------------------------------------------
       Be The Change
             You Want To See
                   In The World
------------------------------------------