Hi Oliver,
> When a worksheet contains a dash in its name, like:
> XLS0901-2-5
> the labtalk command:
> %E!cell(2,1)=;
> returns an error message.
It seems the interpreter tried to evaluate the sheet name as a formula which contains the subtraction;
I'm not sure if it is a bug or not, but anyway using the traditional string register is tricky for substitution.
As a better manner. it may be better to use the string variable like:///////////////////////////////
> %E=;
[Book1]XLS0901-2-5
> bs$=%E;
> bs$!cell(2,1)=;
bs$!cell(2,1)=888
///////////////////////////////
Or, my preferred style is to use the range variable, which is versatile once it is declared, like:
///////////////////////////////
> range rr=%E!col(1);
> rr(2)=;
> rr[2]=;
rr[2]=888
///////////////////////////////
I hope this helps.
--Hideo Fujii
OriginLab
Worksheet names including a dash (-)
Posted - 07/22/2016 : 07:53:29 AM
