Sheet1!A Not Working When Used As Index when setting column value


Version: 2020 SR1

Type: Bug Fixes

Category: Data Handling

Subcategory: Set Column Values / Cell Formula

Jira: ORG-21044


New bug in Origin 2020 SR0

E.g. Run Script

newbook sheet:=2; //create a new book with 2 sheets

%H_A={3,2,1}; //Set column A value on Sheet1

%H_A@2={4,5,6}; //Set column A value on Sheet2

csetvalue col:=col(B) formula:="Sheet2!A[Sheet1!A]"; //Set column B value using A on sheet2 as index