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
 Query masked values on the worksheet
 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
1228 Posts

Posted - 07/02/2021 :  11:28:35 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!

I have X, Y and Z columns and a 3D graph.
Now I want to limit the 3D graph in X and Y.
For this I use Worksheet Query and Mask tools. However I discovered that Worksheet Query doesn't look at the masked values.

Is there a way to overcome this?

---
Andrey

snowli

USA
1446 Posts

Posted - 07/02/2021 :  1:30:52 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello,

At the bottom of Origin workspace, there is a mask toolbar.
U can click the click Disable Masking button (last button) and then use the Worksheet Query to include masked data in query.

Later, u can click the toolbar button again to enable mask.

Will this work for you?

Thanks, Snow
Go to Top of Page

AKazak

Russia
1228 Posts

Posted - 07/03/2021 :  03:10:40 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

Hello,

At the bottom of Origin workspace, there is a mask toolbar.
U can click the click Disable Masking button (last button) and then use the Worksheet Query to include masked data in query.

Later, u can click the toolbar button again to enable mask.

Will this work for you?

Thanks, Snow



Dear Snow,

Thank you for the suggestion.

Anyway, what is the proper way in Origin to limit 3D graphs in X and Y dimensions?

---
Andrey
Go to Top of Page

snowli

USA
1446 Posts

Posted - 07/03/2021 :  5:27:07 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Open Plot Details.
Choose Layer1 on the left.
Go to Miscellaneous tab
Enable clipping and choose By Value to limit X and Y range.

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