| Author |
 Topic  |
|
|
Dunkelbunt
1 Posts |
 Posted - 12/12/2013 : 6:52:23 PM
|
Hi all,
I have measured some y-values at a constant sampling rate (constant time interval between two measured y-values).
Now I want to fill a complete column with these default x-values of constant increment. To do so I did the following:
1. Select worksheet columns.
2. Select Column: Set Sampling Interval. This menu command opens the dialog box of the colint X-Function.
3. Set the Initial X Value and the X Increment for the active worksheet.
4. To display the default X values in the worksheet: Select Column: Show X Column.
This fills in the values only until row number 32 although there are about 500000 more rows to fill, they are left empty. I selected the whole column.
How do I get the whole column containing about 500000 rows being filled with default x values?
I usw OriginPro 8, Windows 7 |
|
|
lkb0221
China
497 Posts |
Posted - 12/13/2013 : 11:42:03 AM
|
Hi, Ahnun
Sorry that I cannot reproduce the problem in my PC.
So first, here is what I did, in case you mis-operated somewhere:
1). Assume your data is in col(B), which has 500000 rows. You can delete col(A) for it's useless.
2). Highlight col(B) and select "Column: Set Sampling Interval".
3). Set the Initial X Value and the X Increment for your data. Click "OK"
4). Keep col(B) highlighted, select "Column: Show X Column..."
Just in case if something goes wrong, there is an alternative way to generate patterned data for your X-value.
1). Add a new column on the left of your data column col(B) and set it to be X. Or use the col(A) if you haven't deleted it yet.
2). Highlight it, right click it and select "Set Column Values..."
3). In "Set Values" dialog, type "a + (i - 1) * b" into the editbox. (a = Initial X Value ; b = X Step Increment Value)
For example, "1+(i-1)*10" will generate "1, 11, 21, 31, ...".
4). click "OK".
add). If still cannot fill all the rows, Set Row(i) From = 1 and To = 500000 before click OK.
Zheng
OriginLab |
Edited by - lkb0221 on 12/13/2013 11:45:35 AM |
 |
|
| |
Topic |
|
|
|
Creating and displaying default X values