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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Linked cell in column formula		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Cr4sZz

14 Posts
Posted - 08/05/2019 :  03:35:09 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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
Edited by - Cr4sZz on 08/05/2019 03:41:42 AM

Castiel

343 Posts
Posted - 08/05/2019 :  04:30:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
**********************************************************
Go to Top of Page

Cr4sZz

14 Posts
Posted - 08/05/2019 :  06:52:40 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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].
Edited by - Cr4sZz on 08/05/2019 07:24:49 AM
Go to Top of Page

YimingChen

1691 Posts
Posted - 08/05/2019 :  09:08:18 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

This should work. see below:



James
Edited by - YimingChen on 08/05/2019 09:22:39 AM
Go to Top of Page

Cr4sZz

14 Posts
Posted - 08/07/2019 :  08:40:59 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

YimingChen

1691 Posts
Posted - 08/09/2019 :  09:09:54 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

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


Thanks
James
Go to Top of Page

Cr4sZz

14 Posts
Posted - 08/13/2019 :  02:41:08 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi James,

awesome, that works! Thank you very much.

Greetz
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000