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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Range Problem !		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

polal2is

France
Posts
Posted - 05/26/2008 :  11:27:13 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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 ?

larry_lan

China
Posts
Posted - 05/27/2008 :  04:07:36 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

polal2is

France
Posts
Posted - 05/27/2008 :  04:43:45 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
[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
Go to Top of Page

greg

USA
1380 Posts
Posted - 06/10/2008 :  3:46:54 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000