The Origin Forum

The Origin Forum

All Forums

Origin Forum

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:

Message:

* HTML is OFF
* Forum Code is ON

Check here to include your profile signature.
Check here to subscribe to this topic.

T O P I C R E V I E W
Annas B. Ali	Posted - 11/22/2017 : 06:09:14 AM Hello, I have some data set that I want to add in. The data set consists of some values e.g (345.65) that I fill in the column against the Time (Seconds). The value remains the same for 10-10,000 seconds and after wards it changes to 0. Again this value remains 0 for next 5000-6000 sec and then it changes. Is there any auto-fill way by which I can enter theses values rather manually. Thanks. aba
1 L A T E S T R E P L I E S (Newest First)
arstern	Posted - 11/22/2017 : 1:56:49 PM Hi, You can use set values. 1. Right Click the F(X) cell and select Open Dialog. In the dialog you can input a value to set and input range of rowsi.e. Row(i): From 10 To 10000. https://www.originlab.com/doc/Origin-Help/Wks-Set-Column-Values 2. You can as well use the Script Window. Select Window -> Script Window. In the Script Window input script below and select enter. csetvalue col:=[Book3]sheet1!A[10:10000] formula:=345.65 https://www.originlab.com/doc/X-Function/ref/csetvalue Aviel OriginLab

The Origin Forum