| Author |
 Topic  |
|
|
Couta
Ireland
3 Posts |
 Posted - 06/10/2011 : 09:12:01 AM
|
Origin Ver. and Service Release (Select Help-->About Origin):
Operating System:
Hello everyone,
I am using Origin 8 and I'd like to know how can I set values when I create a direct matrix from a worksheet :
row from x to y
col from x to y
Indeed I would like to take every rows and columns apart from the first and last ones.
Thank you. |
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 06/10/2011 : 12:39:42 PM
|
Hi Couta,
Sorry, but it is not clear for me what exactly you want to perform. Ingeneral, if you want to convert a worksheet to a matrix directly, you can choose "Worksheet: Convert Matrix: Direct" menu, then choose the format of the data. See detail at the section in Origin help:
Matrix Conversion and Gridding> Direct Worksheet to Matrix Conversion
If you have already a matrix, and want to set the values in cells by a formula, you can use Set Values toll by choosing "Matrix: Set Values" menu.
Maybe you can clarify further what you want to do.
--Hideo Fujii
OriginLab |
 |
|
|
Couta
Ireland
3 Posts |
Posted - 06/13/2011 : 05:30:34 AM
|
quote:
Originally posted by Hideo Fujii
Hi Couta,
Sorry, but it is not clear for me what exactly you want to perform. Ingeneral, if you want to convert a worksheet to a matrix directly, you can choose "Worksheet: Convert Matrix: Direct" menu, then choose the format of the data. See detail at the section in Origin help:
Matrix Conversion and Gridding> Direct Worksheet to Matrix Conversion
If you have already a matrix, and want to set the values in cells by a formula, you can use Set Values toll by choosing "Matrix: Set Values" menu.
Maybe you can clarify further what you want to do.
--Hideo Fujii
OriginLab
Hi,
First of all thanks for answering.
The problem is :
"In general, if you want to convert a worksheet to a matrix directly, you can choose "Worksheet: Convert Matrix: Direct" menu, then choose the format of the data. See detail at the section in Origin help:
Matrix Conversion and Gridding> Direct Worksheet to Matrix Conversion
If you have already a matrix, and want to set the values in cells by a formula, you can use Set Values toll by choosing "Matrix: Set Values" menu."
Everything is fine here, but once the set values window is opened,
there is an option to change the first row and column s number till a finish number.
But I want to change it.
The default start number is 1, I want to start from the second column.
Regards, |
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 06/13/2011 : 10:53:52 AM
|
Hi Couta,
By some reason, when the "Recalculate" mode is "Auto", the range settings are disabled. I will talked to the developers why it works like in this way, and it might be a bug. Meanwhile, you can change the "Recalculate" option in the dialog to "None". As far as I tried on my machine, this work-around worked.
--Hideo Fujii
OriginLab |
|
|
|
Couta
Ireland
3 Posts |
Posted - 06/13/2011 : 11:12:18 AM
|
quote:
Originally posted by Hideo Fujii
Hi Couta,
By some reason, when the "Recalculate" mode is "Auto", the range settings are disabled. I will talked to the developers why it works like in this way, and it might be a bug. Meanwhile, you can change the "Recalculate" option in the dialog to "None". As far as I tried on my machine, this work-around worked.
--Hideo Fujii
OriginLab
Hi,
Thanks again but I tried and the result is still the same : disabled.
Let me know if you find any other solution.
Regards, |
|
|
|
Hideo Fujii
USA
1582 Posts |
Posted - 06/13/2011 : 11:18:39 AM
|
Hi Couta,
Please let me know the version number and the Service Release(SR)
number of your Origin("Help: About Origin" menu).
As far as I tried my versions 8.0I(SR6) and 8.5.1, they worked.
If your Origin is even older, I suspect this part has been fixed
in the later version/SR.
--Hideo Fujii
OriginLab |
Edited by - Hideo Fujii on 06/13/2011 5:00:03 PM |
|
|
| |
Topic |
|
|
|
Set values in matrix - Origin 8