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
 Set Column Values - can't type own formula

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
Lily3013 Posted - 05/04/2023 : 06:10:24 AM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2023b
Operating System: Win11

Hey everyone!
I'm struggeling with the newest origin version. In our old version, we simply had to click on "set column values" and could type in our own formula - in our case we need it to recalculate sensor data from voltage to resistance with a few costum manipulations - and I cannot do that in the new version. It does not allow me to type anything in the boxes and I cannot just take a formula of the catalogue because it isn't what I need. The box also does not allow me to copy or insert anything. I saw that I can select user created formulas, but additionally, I do not know how to create a new costum formula. Does anyone have a solution for that? Help would be greatly appreciated.
Thank you!
2   L A T E S T    R E P L I E S    (Newest First)
cpyang Posted - 05/04/2023 : 07:43:02 AM
Maybe you were trying to use formula on an imported column, instead of adding a new column. There is no change in the new version in this area. If you want to change the values in an imported file, you need to either remove the data connector, or click the connector icon and choose "Unlock Imported Data". The best way is to add a new column so the imported data is unchanged and your calculated data column is on the right of the imported data.

Also, why use "Set Column Values", when there is Fx row where you can directly type in the formula?

CP
Lily3013 Posted - 05/04/2023 : 06:15:13 AM
Also - I just tried - I can't select any of the other formulas to fill the dialogue field

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