The Origin Forum
File Exchange
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
 Move matrix objects between matrix sheets
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
584 Posts

Posted - 07/28/2021 :  06:03:40 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

YimingChen

820 Posts

Posted - 07/28/2021 :  09:04:28 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
584 Posts

Posted - 07/28/2021 :  1:33:30 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

YimingChen

820 Posts

Posted - 07/29/2021 :  11:53:07 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Should be the same as SCV in worksheet:


James
Go to Top of Page

AKazak

Russia
584 Posts

Posted - 07/29/2021 :  11:47:29 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

YimingChen

820 Posts

Posted - 07/30/2021 :  08:56:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I see. Can you just make a new matrix object in another matrix sheet, and put in the same formula?

James
Go to Top of Page

AKazak

Russia
584 Posts

Posted - 07/30/2021 :  5:03:07 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
584 Posts

Posted - 08/09/2021 :  12:21:56 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

minimax

China
186 Posts

Posted - 08/09/2021 :  04:12:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
584 Posts

Posted - 08/09/2021 :  06:43:39 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

snowli

USA
891 Posts

Posted - 08/09/2021 :  11:57:29 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
584 Posts

Posted - 08/09/2021 :  3:27:08 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Got it!
Thanks.

---
Andrey
Go to Top of Page

AKazak

Russia
584 Posts

Posted - 09/07/2021 :  08:34:12 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

snowli

USA
891 Posts

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

snowli

USA
891 Posts

Posted - 09/07/2021 :  09:17:10 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

AKazak

Russia
584 Posts

Posted - 09/07/2021 :  09:20:41 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

snowli

USA
891 Posts

Posted - 09/07/2021 :  09:29:30 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

Thanks. i added it as P2 in same jira.

Thanks, Snow
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