| Author |
 Topic  |
|
|
AlexD2
France
19 Posts |
 Posted - 01/13/2014 : 06:13:44 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): 9.1 SR1
Operating System: Windows 7 (32 bit)
Hello,
There are several aspects of the behavior and usage of Range Data that I don't manage to grasp.
As a start, I don't understand why the following does not work:
// With non-contiguous cells selected in the active worksheet:
>>range -v rC3 = %C // declare a CellRange
>>type %(rC3)
[Book4]Sheet1!(A"Long_A"[1:1],A"Long_A"[1]:C"Long_C"[1],A"Long_A"[5]:C"Long_C"[5]) // This is OK
>>type "$(rC3)"
--
>>type $(rC3)
(empty line)
I assume this is a limitation of the type command? Or maybe the $() substitution notation?
If so, how can I display, access and assign the content of this type of range?
Thank you for your help!
AlexD2
|
|
|
AmandaLu
439 Posts |
Posted - 01/14/2014 : 03:56:40 AM
|
Hi AlexD2,
range -v requires that the block must be contiguous. If the selected cells are non-contiguous, they are considered multiple blocks.
Regarding the bug in "type" command mentioned in this post,
http://originlab.com/forum/topic.asp?TOPIC_ID=9629
We have submitted a JIRA to require the fix in the future version.
Thanks,
Amanda
OriginLab Technical Service |
Edited by - AmandaLu on 01/14/2014 05:07:54 AM |
 |
|
|
AlexD2
France
19 Posts |
Posted - 01/14/2014 : 08:47:13 AM
|
Thank you very much for your answer Amanda.
I must have had a variable conflict in my previous Origin session since now the non-contiguous range declaration and stats command run fine.
Thank you also for the clarification about the -v option.
However, now that I repeat the tests, it seems that I the range -v declaration works partially?
At least I can then perform the stats analysis. But indeed, assigning values do not work consistently (when assigning a non-contiguous range, some values are assigned while others are not).
It would maybe be helpful if such operations were not allowed at all and if they were outputting some explanatory error message such as:
"[Operation] cannot be performed with [variable type]"
Thanks again for your answer.
AlexD2 |
|
|
|
AlexD2
France
19 Posts |
Posted - 01/14/2014 : 08:51:15 AM
|
Oups... I posted in the wrong topic.
Thanks for the info about the type command.
Best,
AlexD2 |
|
|
|
greg
USA
1379 Posts |
Posted - 01/14/2014 : 4:30:52 PM
|
Amanda's information is not quite correct. You can have a non-contiguous range, it's just that the variable has limited use. Specifically, it can only be used with an X Function that accepts "Input vector".
See
http://www.originlab.com/forum/topic.asp?TOPIC_ID=18739 |
|
|
|
Conexclack
USA
2 Posts |
Posted - 02/01/2014 : 11:48:43 AM
|
helpful information all
thanks
|
|
|
| |
Topic |
|
|
|
Behavior and usage of Range Data