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
 Keep masking of data after re-import
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

dominik.mierzwa

Poland
118 Posts

Posted - 02/27/2024 :  07:02:48 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 2024 PRO
Operating System: Windows 11
Hi,
I have multiple xls files connected to project. I got data from files using wAppend function. Then I usually mask bad points. Unfortunately, after re-importing the data, the masks are removed. Is there any method to keep masking bad points?
Kind regards,


Kind regards,
Dominik

YimingChen

1594 Posts

Posted - 02/27/2024 :  08:41:40 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Because the output of wAppend is worksheet and it's cleared before being filled with data.

Maybe we can add sheet script (menu Worksheet:Worksheet Script..) to mask cells after the update.
https://www.originlab.com/doc/en/LabTalk/ref/Datasets#Masking_Cells

Thank you
James
Go to Top of Page

dominik.mierzwa

Poland
118 Posts

Posted - 02/27/2024 :  08:45:26 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply


Ok, but is there any way to first save the list of masked cells, and after re-import, load the pattern and mask the same cell again?

Kind regards,
Dominik
Go to Top of Page

YimingChen

1594 Posts

Posted - 02/27/2024 :  11:43:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Did you mask cells based on certain conditions? Would you mind sharing your project file as well?

Go to Top of Page

dominik.mierzwa

Poland
118 Posts

Posted - 02/28/2024 :  03:07:21 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I am masking data manually on the graph.
Please find the exemplary files attached.
https://my.originlab.com/ftp/forum_and_kbase/Images/ex%20files%20-%20masking.zip

Kind regards,
Dominik
Go to Top of Page

YimingChen

1594 Posts

Posted - 02/28/2024 :  2:14:36 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Currently there is no way to save the pattern of the mask. We will improve it (jira: ORG-28720). As a workaround, you can mark the masked cells by fill color, and use the X-function wcolor2mask to mask those cells when data gets updated. Please check the video below and see if it works.



James
Go to Top of Page

dominik.mierzwa

Poland
118 Posts

Posted - 03/13/2024 :  09:36:13 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi James,
After several tests I can say that it works. Sometimes it loses mask but usually retains on re-imported data.
Thank You!

Kind regards,
Dominik
Go to Top of Page

AmandaLu

439 Posts

Posted - 05/29/2024 :  06:14:57 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by dominik.mierzwa



Ok, but is there any way to first save the list of masked cells, and after re-import, load the pattern and mask the same cell again?

Kind regards,
Dominik



Hi,

Origin 2024b is now available!

In this version, we implemented the “copy paste mask status” feature you requested in this post (ORG-28720). Please refer to the short video here:
https://www.originlab.com/videos/details.aspx?id=577

You can highlight all columns and select Edit: Copy: Copy Mask Status before re-import, and then use Edit: Paste after reimport and recalculate your data .

Please download Origin 2024b from the link below, install and have a try.
http://www.originlab.com/demodownload.aspx

We are looking for your feedback! Any suggestion will be appreciated!

Thanks,
Amanda
OriginLab Technical Service
Go to Top of Page

dominik.mierzwa

Poland
118 Posts

Posted - 05/29/2024 :  1:43:57 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by AmandaLu


Hi,

Origin 2024b is now available!

In this version, we implemented the “copy paste mask status” feature you requested in this post (ORG-28720). Please refer to the short video here:
https://www.originlab.com/videos/details.aspx?id=577

You can highlight all columns and select Edit: Copy: Copy Mask Status before re-import, and then use Edit: Paste after reimport and recalculate your data .

Please download Origin 2024b from the link below, install and have a try.
http://www.originlab.com/demodownload.aspx

We are looking for your feedback! Any suggestion will be appreciated!

Thanks,
Amanda
OriginLab Technical Service




Hi,
good to know. Thank you. I will test the feature and report the progress.
Kind regards,
Dominik

Edited by - dominik.mierzwa on 05/29/2024 1:46:54 PM
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