| Author |
 Topic  |
|
|
AKazak
Russia
1205 Posts |
 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 |
|
|
YimingChen
1609 Posts |
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 |
 |
|
|
AKazak
Russia
1205 Posts |
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
1609 Posts |
Posted - 07/29/2021 : 11:53:07 AM
|
Should be the same as SCV in worksheet:
James |
|
|
|
AKazak
Russia
1205 Posts |
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
1609 Posts |
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
Russia
1205 Posts |
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 |
|
|
|
AKazak
Russia
1205 Posts |
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 |
|
|
|
minimax
348 Posts |
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
Russia
1205 Posts |
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 |
|
|
|
snowli
USA
1386 Posts |
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
Russia
1205 Posts |
Posted - 08/09/2021 : 3:27:08 PM
|
Got it!
Thanks.
---
Andrey |
|
|
|
AKazak
Russia
1205 Posts |
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 |
|
|
|
snowli
USA
1386 Posts |
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 |
|
|
|
snowli
USA
1386 Posts |
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 |
|
|
|
AKazak
Russia
1205 Posts |
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
USA
1386 Posts |
Posted - 09/07/2021 : 09:29:30 AM
|
Hi Andrey,
Thanks. i added it as P2 in same jira.
Thanks, Snow |
|
|
| |
Topic |
|
Move matrix objects between matrix sheets