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
 Linked cell in column 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
Cr4sZz Posted - 08/05/2019 : 03:35:09 AM
Origin Ver. and Service Release (Select Help-->About Origin): 2019b
Operating System: W10

Hi,

is it possible to link a cell in a column formula so that the formula gets updated whenever that linked cell is updated? From what I read in the Wiki, only user-defined rows support cell formulas. I tried that but I couldn't calculate column values from that new user-defined row. (I'd link the entries (4.6.9 and 4.3.6 "User-Defined Parameters") if there wasn't this incredibly bad spam protection.) So, I want a column formula like 
F(x)=Col(A)*cell://[Workbook]Sheet1!E[26]
which doesn't work in 2019b. If not possible as I guess, could you add this feature?

Sincerely
Cr4sZz
6   L A T E S T    R E P L I E S    (Newest First)
Cr4sZz Posted - 08/13/2019 : 02:41:08 AM
Hi James,

awesome, that works! Thank you very much.

Greetz
YimingChen Posted - 08/09/2019 : 09:09:54 AM
Hi,

Please use the following LT expression instead.
value([Param]Sheet1!A1)*A


Thanks
James
Cr4sZz Posted - 08/07/2019 : 08:40:59 AM
Hi James,

unfortunately, it doesn't. Origin says that it can't perform math on a text column. It does so even when I create a new workbook and change the column's setting from "Text & Numeric" to only "Numeric". Short notation is disabled. Any idea?

Thanks for the help!
Greetings
YimingChen Posted - 08/05/2019 : 09:08:18 AM
Hi,

This should work. see below:



James
Cr4sZz Posted - 08/05/2019 : 06:52:40 AM
Spreadsheet Cell Notation was disabled as the values are calculated by a script which renames column's short names. Also, the cell is in another workbook called Param. Thus, I tried [Param]Sheet1![E26] instead of cell://[Param]Sheet1!E[26] which doesn't work either. Same for enabled Spreadsheet Cell Notation and [Param]Sheet1!E26 in accordance with 4.6.8.1 "Spreadsheet Cell Notation".

I tried several combinations. The error is "Operand is missing", e.g. for cell://[Param]Sheet1!col(E)[26].
Castiel Posted - 08/05/2019 : 04:30:41 AM
quote:
Originally posted by Cr4sZz

Origin Ver. and Service Release (Select Help-->About Origin): 2019b
Operating System: W10

Hi,

is it possible to link a cell in a column formula so that the formula gets updated whenever that linked cell is updated? From what I read in the Wiki, only user-defined rows support cell formulas. I tried that but I couldn't calculate column values from that new user-defined row. (I'd link the entries (4.6.9 and 4.3.6 "User-Defined Parameters") if there wasn't this incredibly bad spam protection.) So, I want a column formula like 
F(x)=Col(A)*cell://[Workbook]Sheet1!E[26]
which doesn't work in 2019b. If not possible as I guess, could you add this feature?

Sincerely
Cr4sZz


Just F(x) = A * E26 or F(x) = A * [Workbook]Sheet1!E26 when the Spreadsheet Cell Notation is on (default setting).


                                          &&&&&&&&&
                                        &&&
                                       &&
                                      &  _____ ___________
                                     II__|[] | |   I I   |
                                    |        |_|_  I I  _|
                                   < OO----OOO   OO---OO
**********************************************************

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