All Forums  Origin Forum for Programming  LabTalk Forum  %() Substitution gives inconsistent Range Strings

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by AlexD2[/i] [br]Origin Ver. and Service Release: 9.1.0 Sr1 Operating System: Windows7 32 bit I don't understand the behavior of the %() substitution: With Book2 and Sheet1 active: >>range rDa1 = %([Book2]Sheet1,1); type %(rDa1) [Book2]Sheet1!Book2_A // OK With Sheet3 active: >>range rDa1 = %([Book2]Sheet1,1); type %(rDa1) [Book2]Sheet3!Book2_A // ??? Shouldn't the result be independent of which Book/Sheet is active? Similarly: With Sheet3 active: >>range rDa1 = %([Book2]Sheet3,1); type %(rDa1) [Book2]Sheet3!Book2_A@2 // OK (I only have two sheets: Sheet1 and Sheet3) With Sheet1 active: >>range rDa1 = %([Book2]Sheet3,1); type %(rDa1) [Book2]Sheet1!Book2_A@2 // Not good What is also surprising is that the dataset name is correct in every case: I obtain Book2_A or Book2_A@2 as it should be; however the SheetName (Sheet1 or Sheet3) is inconsistent and depends on which worksheet is active. Is this a normal behavior? Thanks for your help! AlexD2 [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.