| Author |
 Topic  |
|
|
AKazak
Russia
1228 Posts |
 Posted - 07/05/2022 : 07:19:41 AM
|
OriginPro 2022b (64-bit) SR1 9.9.5.171
Windows 7 Pro SP1 x64
Greetings!
https://www.originlab.com/doc/LabTalk/ref/FindMasks-func helps locating indices of the masked cells. However this does not help getting a range object containing the masked cells to do manipulations, including selecting, deleting or changing values.
What is the proper way of getting a grange object of masked cells in the active worksheet?
Thank you.
---
Andrey |
|
|
AKazak
Russia
1228 Posts |
Posted - 07/06/2022 : 03:12:27 AM
|
Any ideas?
I discovered that any math operation on the masked cell via LT turns the masked cells to "--". Is this by design or a software bug?
---
Andrey |
 |
|
|
minimax
362 Posts |
Posted - 07/06/2022 : 05:48:20 AM
|
| yes, basically "mask" in Origin means excluded, and the value is treated as missing value on calculation. |
|
|
|
AKazak
Russia
1228 Posts |
Posted - 07/06/2022 : 11:42:21 AM
|
quote:
Originally posted by minimax
yes, basically "mask" in Origin means excluded, and the value is treated as missing value on calculation.
Got it!
How do I use LT to get a range object containing the masked cells to do manipulations, including selecting, deleting or changing values?
---
Andrey |
|
|
|
AKazak
Russia
1228 Posts |
|
|
minimax
362 Posts |
Posted - 07/11/2022 : 02:14:35 AM
|
| I think there is no simple LT scripts, you may try OC codes. |
|
|
|
AKazak
Russia
1228 Posts |
Posted - 07/11/2022 : 06:44:53 AM
|
quote:
Originally posted by minimax
I think there is no simple LT scripts, you may try OC codes.
IMHO it is worth adding the facility to LT.
I will look into OC functions, but not sure if I find something useful to referenced the masked cells.
---
Andrey |
|
|
| |
Topic |
|
FindMasks: select, delete or alter masked cells