The Origin Forum
File Exchange
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Move matrix objects between matrix sheets

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
AKazak Posted - 07/28/2021 : 06:03:40 AM
OriginPro 2021b (64-bit) SR2 9.8.5.212
Windows 10 21H1 x64

Greetings!

What is the proper way of copying/moving matrix objects between matrix sheets?
I understand the XY dimensions should be consisted.

Thank you.

---
Andrey
16   L A T E S T    R E P L I E S    (Newest First)
snowli Posted - 09/07/2021 : 09:29:30 AM
Hi Andrey,

Thanks. i added it as P2 in same jira.

Thanks, Snow
AKazak Posted - 09/07/2021 : 09:20:41 AM
quote:
Originally posted by snowli

Hi Andrey,

Do you mind sending your opju. I saw some error message dumped in messages log once but i didn't pay attention to it and now can't see the issue.
The only issue i saw is it doesn't update thumbnail view and didn't show the copied object in target window. I added this as P1 in ORG-23958

Could you clarify how it messed up the target window?

Thanks, Snow



I notice that this happens if the source MO has different dimensions than the target MS.
Please make impossible copy if source and target dimensions do not match.

---
Andrey
snowli Posted - 09/07/2021 : 09:17:10 AM
Hi Andrey,

Do you mind sending your opju. I saw some error message dumped in messages log once but i didn't pay attention to it and now can't see the issue.
The only issue i saw is it doesn't update thumbnail view and didn't show the copied object in target window. I added this as P1 in ORG-23958

Could you clarify how it messed up the target window?

Thanks, Snow
snowli Posted - 09/07/2021 : 08:53:14 AM
Yes, Andrey,

What is your setting in Output Matrix?
Suppose Target matrix is MSheet1 of MBook2], if i set
[MBook2]MSheet1!<new>
It will copy to new object in MSheet1 of MBook2.
But the new object doesn't show in thumbnail. I will report that.



Snow
AKazak Posted - 09/07/2021 : 08:34:12 AM
Copy a MO to another MS with several MOs destroys data in the target MO:

OriginPro 2022 (64-bit) Beta2 9.9.0.105
Windows 10 21H1 x64

Please check.
Can you reproduce the issue?

---
Andrey
AKazak Posted - 08/09/2021 : 3:27:08 PM
Got it!
Thanks.

---
Andrey
snowli Posted - 08/09/2021 : 11:57:29 AM
With the copied object, click the green lock and set it to None.

Then if u open Set Values dialog, u can edit the formula.

Also as Max said, when u were doing copy matrix, u can set it to None.



Thanks, Snow
AKazak Posted - 08/09/2021 : 06:43:39 AM
quote:
Originally posted by minimax

The lock belongs to the "Copy to" tool, you can click the lock icon and select menu "Recalculate Mode: None" to remove the lock.



Can you show this method on a screenshot, please?

---
Andrey
minimax Posted - 08/09/2021 : 04:12:02 AM
The lock belongs to the "Copy to" tool, you can click the lock icon and select menu "Recalculate Mode: None" to remove the lock.
Or you can select the Recalculate combo option as None on "Copy to" dialog at the beginning.

It(set as None) also means that it will lose the connection (auto-update) with the original matrix.

See more about "Recalculate" on following page:
https://www.originlab.com/doc/Origin-Help/AnalyDialog-Recalculate
AKazak Posted - 08/09/2021 : 12:21:56 AM
quote:
Originally posted by minimax

Hi Andrey,

Aside from the m2w XF, we also improved the matrix object copy functionality in Beta2, based on your post:
https://my.originlab.com/forum/topic.asp?TOPIC_ID=46988

We added "Copy to" context menu on the Image Thumbnail, you may take a try if having time.



It works fine in 2022 Beta 2.
However, if I tick to copy formula in Copy to dialog, the formula seems to locked/blocked in the destination MO:


How do I unlock the Set Values dialog?

---
Andrey
AKazak Posted - 07/30/2021 : 5:03:07 PM
quote:
Originally posted by YimingChen

I see. Can you just make a new matrix object in another matrix sheet, and put in the same formula?

James



Dear James,

That is what I currently do.
However, it would be great to have GUI and LT command for this.

---
Andrey
YimingChen Posted - 07/30/2021 : 08:56:02 AM
I see. Can you just make a new matrix object in another matrix sheet, and put in the same formula?

James
AKazak Posted - 07/29/2021 : 11:47:29 PM
quote:
Originally posted by YimingChen

Should be the same as SCV in worksheet:


James



Dear James,

This copies the values, but not set formulas.
Let me put it this way: How do I duplicate MO (values + formulae) to a different worksheet?

It seems that GUI cannot help.
Is there an LT snippet for this?

---
Andrey
YimingChen Posted - 07/29/2021 : 11:53:07 AM
Should be the same as SCV in worksheet:


James
AKazak Posted - 07/28/2021 : 1:33:30 PM
quote:
Originally posted by YimingChen

You can handle Matrix Objects the same way as you handle the columns in worksheet. e.g. copy/paste the values from one object to anther object, then delete the original matrix object.

James



Dear James,

This is OK for the MOs with statiс values.
Is there an easy way to copy/move MOs with Set Formulas?

---
Andrey
YimingChen Posted - 07/28/2021 : 09:04:28 AM
You can handle Matrix Objects the same way as you handle the columns in worksheet. e.g. copy/paste the values from one object to anther object, then delete the original matrix object.

James

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