The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Range Problem !

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

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
polal2is Posted - 05/26/2008 : 11:27:13 AM
Origin Version (8 Pro SR2):
Operating System: Vista SP1

I have a problem with ranges, indeed why is this command not working :

range cc = [C01]Données!col(1)[2:end];

the whole column is stored in cc (row 1 to end) instead of row 2 to end.
Same problem even with :

range cc = [C01]Données!col(1)[2];

Is it a SR2 problem ?


3   L A T E S T    R E P L I E S    (Newest First)
greg Posted - 06/10/2008 : 3:46:54 PM
Please note:
http://www.originlab.com/forum/topic.asp?TOPIC_ID=6854

You will not get SR2 when it becomes available if you do not follow instructions.


polal2is Posted - 05/27/2008 : 04:43:45 AM
[url=http://www.casimages.com/img.php?i=0805271040003442317.jpg][/url]

Tanks a lot for your answer nevertheless I need to copy datas of a column while deleting the first value (so row 2 to end) to move the origin each time, how can I perform this as the two columns are located in different books.

Thanks
larry_lan Posted - 05/27/2008 : 04:07:36 AM
Hi Hugo:

In Origin 8, the range variable can refer to an entire workbook, worksheet and the whole column only. That is, once you define a range like:

range rr = [book1]sheet1!col(1);

You can access worksheet cells by rr[3], just like Array in C language. We would like to support more general range definition, maybe in 8.1 or later version.

P.S: What's your Origin build number? We haven't released SR2 yet. Maybe you can restore to SR1 follows This Instruction?

Thanks
Larry
OriginLab Technical Services

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000