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
 All Forums
 Origin Forum
 Origin Forum
 Enable/disable masking cell by condition

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
dominik.mierzwa Posted - 10/19/2020 : 1:19:20 PM
Hi,
I'm using the mask cell by condtion tool set in a "Worksheet script" window. I wonder, is it possible to enable/disable the applied masks for all worksheets in the procject? Sometimes, I need to see raw data (with the masked one).
Kind regards,
Dominik

Kind regards,
Dominik
11   L A T E S T    R E P L I E S    (Newest First)
YimingChen Posted - 05/13/2022 : 11:08:49 AM
Hi,

Just let you know that the bug has been fixed in our recently released Origin 2022b. Please upgrade your Origin to test. Thank you.

Yiming
YimingChen Posted - 10/23/2020 : 09:56:30 AM
We will look into these two issues and see if we need fix. For now:
1. The issue is the operation in Book2 is not triggered when mask is disabled. You will need to click on the green lock, change parameter... to recalculate.
2. We will improve this as well. One workaround is to put your data info into column comments instead of user parameters column header.

Yiming
dominik.mierzwa Posted - 10/23/2020 : 02:41:17 AM
Ok, I sent the message with a file.

Kind regards,
Dominik

Kind regards,
Dominik
Echo_Chu Posted - 10/22/2020 : 10:57:16 PM
Hi, Dominik

I can not reproduce your problems. Would you mind sending us your project file so that we can further identify the problem?

You could follow the instructions below to send your file.
http://www.originlab.com/index.aspx?go=Support&pid=752

Echo
OriginLab Technical Support
dominik.mierzwa Posted - 10/22/2020 : 2:41:48 PM
Hi James,

Ad. 1: In is not a case. I have raw data at which I applied mask. Next, I calculated the mean and standard deviation (stats in the column) and this descriptive statistic is used for the graph. When I disable the mask, Origin recalculates the mean and other stat parameters, but did not "refresh" the graph.

Ad. 2:

Kind regards,
Dominik
YimingChen Posted - 10/22/2020 : 2:08:05 PM
1. Maybe you need to press the button to hide masked data on graph.


2. Can you attach a screenshot to show the issue?

James

quote:
Originally posted by dominik.mierzwa

Ad. 1: Yes, it works, but the changes are not visible on the graphs. I still have the same data values.

Ad. 2: I found the problem that if I use Categories sorting, User defined parameter is removed. Why?

Kind regards,
Dominik

dominik.mierzwa Posted - 10/22/2020 : 1:24:41 PM
Ad. 1: Yes, it works, but the changes are not visible on the graphs. I still have the same data values.

Ad. 2: I found the problem that if I use Categories sorting, User defined parameter is removed. Why?

Kind regards,
Dominik
YimingChen Posted - 10/22/2020 : 10:47:21 AM
Hi Dominik,

1. Isn't the toolbar button already did so?

2. You will have to create User Parameters column header row, and put your own parameters there.



James
dominik.mierzwa Posted - 10/22/2020 : 08:59:19 AM
I have another question, is it possible to disable mask in all workbooks/worksheets at once?

And the second question. Is it possible to fix the "Long name" of the columns obtained from the "statistics in the column"? Every time I recalculate it, the long name changes to "Mean", "Standard deviation" etc. I would like to get the parameter name here.



Kind regards,
Dominik
dominik.mierzwa Posted - 10/20/2020 : 10:31:43 AM
Hi James,

I thought that this function works only with graphs. Thank you.



Kind regards,
Dominik
YimingChen Posted - 10/19/2020 : 1:58:44 PM
Hi Dominik,

You can find the enable/disable mask button in the lower toolbar.


James

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