| Author |
 Topic  |
|
|
Andreas_D
Germany
11 Posts |
 Posted - 05/31/2010 : 12:19:16 PM
|
Origin Ver. and Service Release (Select Help-->About Origin): 8.0988
Operating System:WinXP Pro SP3
Hi everyone,
how do I set the recalculation mode of a dataset to auto?
The task I am trying to do is the following:
I start from a spectroscopic dataset consisting of one x and one y column.
I then add a new worksheet based on a template and import some reference ascii data.
Following that I add another worksheet based on a different template, copy the original data into it and do some calculations with the original data and the reference data from Sheet2. All columns in the third worksheet that relate by "set column values" to columns of the 2nd worksheet do not keep the recalculation mode to auto when I save the template, so after adding the new worksheet I need to set the relevant columns to auto recalculate by script, but I didn't find an appropriate instruction.
Any help is - as always - much appreciated.
Cheers,
Andreas
|
|
|
Penn
China
644 Posts |
Posted - 05/31/2010 : 10:43:21 PM
|
Hi Andreas,
Though I am not sure what operations you have done on your data, I have tried the following simple mathematical operation by setting column A of Sheet3 with values from Sheet1 and Sheet2. The recalculate mode is still there when I save this workbook as template and re-open it again.
Could you please provide more details about your issue? If you wish, you can send us your project file via this page and we can take a look further on your problem. Please refer to this post in your email.
Penn |
 |
|
|
Andreas_D
Germany
11 Posts |
Posted - 06/01/2010 : 04:27:24 AM
|
Hi Penn,
I think the problem with my procedure is, that I have a different template for each worksheet I add. I would like to calculate colour space coordinates for a given spectrum and ideally organize the data such, that for each spectroscopic dataset the CIE reference data and the calculations are done in a different worksheet in the same workbook.
I'd like to keep all related data in the same workbook for keeping things tidy, as each origin project can hold many spectra.
So far I am using the newsheet command to add the new worksheet. I created a different template with only the layout and calulations of the new worksheet, but when I try to insert script to refer to columns of a different worksheet that is not yet present, the auto recalculate mode is not set.
I managed to resolve the issue now, however. I simply saved the template with all worksheets present and afterwards deleted the unwanted sheets and saved again. Now the recalculation mode is kept to auto.
Strange...
Thanks anyway for your reply.
Andreas
|
|
|
| |
Topic |
|
|
|
set recalculation mode to auto