| Author |
 Topic  |
|
|
martin12
Switzerland
Posts |
 Posted - 08/30/2004 : 09:34:16 AM
|
Origin Version (Select Help-->About Origin): 7.03
Operating System: Windows XP
I have a project with lots of similar data sheets with identical column headers. I want to apply the same new calculations in new columns to all of these data sheets. Now my question is: Is there a way to copy columns from one worksheet to another including the formulas used to calculate the columns and the column headers?
Thanks, Martin
|
|
|
easwar
USA
1965 Posts |
Posted - 08/30/2004 : 11:57:11 AM
|
Hi Martin,
If you get the free SR4 patch (and the up to date help files for SR4) for your Origin 7.0 version, you will have programmatic access to getting, setting and excuting column formula from Origin C with methods such as GetFormula, SetFormula and ExecuteFormula. Also Origin C has access to getting and setting other column properties.
However, a better approach for you could be to create a custom worksheet template. You would then set up all column properties including formulae, and then save that worksheet setting as a template. Then you could create instances of that worksheet template and bring in different data such as from external files using import. If you need help with creating and using templates, please post.
Easwar
OriginLab
|
 |
|
|
martin12
Switzerland
Posts |
Posted - 08/31/2004 : 02:00:11 AM
|
Hello Easwar
Thanks for your help. I know about templates, but my problem is that I already have all the worksheets, and I have quite some graphs already linked to these worksheets. So I don't want to make a new ws for every dataset and copy all the data, because then I either have to change all the links in the graphs or I end up with a double-size file.
Is it possible to apply a template to an already existing worksheet?
Cheers, Martin
|
|
|
|
easwar
USA
1965 Posts |
Posted - 08/31/2004 : 09:59:32 AM
|
Hi Martin,
Templates are used to create new instances of objects (such as graphs and wks), and cannot be applied to already existing object.
So in your case, you will need to programmatically copy and apply settings either using LabTalk or Origin C.
If you need help with that, either post in the OC/LT forums, or send your OPJ with details to tech@originlab.com - if you send e-mail, then please refer to this forum post.
Easwar
OriginLab
|
|
|
| |
Topic |
|
|
|
copy columns with formulas