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
 fill column

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
tergo Posted - 02/24/2009 : 04:05:28 AM
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:

hi,

I want to fill a column with numbers startig: 0 10 20...with 10 units between them, what do I have to do?

thankss
2   L A T E S T    R E P L I E S    (Newest First)
tergo Posted - 02/27/2009 : 06:09:41 AM

many thanks Emily for your help

I achieved it with the second way and I tryed the third way but I canīt do it, when I clicked in the lower right of the selection rectangle and hold ALT, so the cross (+) no appears

I would like to know why, maybe because do I have OriginPro 7 ??

Best regards

Teresa
emily_yu Posted - 02/25/2009 : 01:05:50 AM
Hi, Teresa

For example, you want to fill column A with numbers: 0, 10, Ą­100, then you can do it in the ways below:

1. Enter "col(A)=data(0,100,10)" in the command window.

Or

2. Highlight the col(A) and right click the mouse and select "Set Column Values" to bring up a dialog box, enter "data(0,100,10)" in the column formula. You can get more information from this webpage:

http://www.originlab.com/www/helponline/Origin8/en/category/using_formulae_to_set_or_transform_worksheet_column_values.htm

Or

3. Write 0 in the 1 row of col(A), and 10 in the 2 row of it, select them and hold ALT key when drag this selection down to the 10 row. Please refer to this webpage for more details:

http://www.originlab.com/www/helponline/Origin8/en/mergedProjects/QuickHelp/QuickHelp/How_do_I_auto_fill_cells_with_data.html


Best regards,
Emily
OriginLab Technical Services

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