| T O P I C R E V I E W |
| freddie_mclair |
Posted - 01/23/2016 : 11:23:27 AM
Hi,
I would like to have a column with different sequential data, from 0.001 to 1, with increments of 0.001, and then from 1 to 10000 with increments of 1. How can I do this?
I know how to work out the "datarange" function, but I don't know if it is possible to concatenate two different data ranges functions sequentially.
Here's what I would like to have:
A(Y)
--------
0.001
0.002
0.003
...
1
2
3
...
10000
--------
Thanks in advance!
Freddie
Origin Ver.: OriginPro 2016
Operating System: Windows 7 Professional |
| 4 L A T E S T R E P L I E S (Newest First) |
| freddie_mclair |
Posted - 01/26/2016 : 12:54:47 PM
Hi Sean,
Wow, thanks a lot, this worked out perfectly! 
Regards!
Freddie |
| SeanMao |
Posted - 01/25/2016 : 7:35:57 PM
Hi,
I should have mentioned this earlier. You can run script to set maximum row number wks.nrows = 10999; before running the formula in Before Formula Scripts section as shown below:
Regards!
Sean
quote:
Originally posted by freddie_mclair
Hi Sean!
Thanks a lot! This worked, but in order to get the full column (up to 10000) I had to set "Row(i): From 1 To 10999" in the "Set Values" menu.
Is there any other way to make it automatically? Because the first time I tried it, it only filled the values until Row 32 (which was the default number of rows when I opened the Workbook).
Thanks again
Regards!
Freddie
|
| freddie_mclair |
Posted - 01/25/2016 : 1:44:47 PM
Hi Sean!
Thanks a lot! This worked, but in order to get the full column (up to 10000) I had to set "Row(i): From 1 To 10999" in the "Set Values" menu.
Is there any other way to make it automatically? Because the first time I tried it, it only filled the values until Row 32 (which was the default number of rows when I opened the Workbook).
Thanks again
Regards!
Freddie |
| SeanMao |
Posted - 01/24/2016 : 9:11:21 PM
Hi,
You can use Set Column Value dialog to enter the formula i<=1000?i*0.001:(i-999) as shown in the figure below:
Regards!
Sean
OriginLab Tech. |
