The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Copy selected columns to other worksheet(s)		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

AKazak

Russia
1258 Posts
Posted - 03/21/2026 :  08:52:33 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
OriginPro 2026b (64-bit) Beta2 10.3.5.62
Windows 10 Pro

Greetings!

I have a number of worksheets sharing the same structure.
In a single worksheet I add few additional columns with formulas and LT scripts before formula.

What is the best way to copy these extra columns to all the other similar worksheets by insert new columns to the same locations as those of the original columns?

Please see a sample project below:
https://my.originlab.com/ftp/forum_and_kbase/Images/2026-03-21.opju

How do I duplicate column B along with its headers formulas from Sheet1 to all the other sheets?

Thank you.

---
Andrey

YimingChen

1697 Posts
Posted - 03/23/2026 :  2:55:45 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
You may try the script below:


for (int i = 2; i <= page.nlayers;i++) {
	page.active = i;
	wks.col = 2;
	wks.insert();
	range rs = 1!;
	wks.col.formula$ = %(rs.col2.formula$);
	wks.col.lname$ = %(rs.col2.lname$);
}


Yiming
Go to Top of Page

AKazak

Russia
1258 Posts
Posted - 03/23/2026 :  2:58:22 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by YimingChen

You may try the script below:


for (int i = 2; i <= page.nlayers;i++) {
	page.active = i;
	wks.col = 2;
	wks.insert();
	range rs = 1!;
	wks.col.formula$ = %(rs.col2.formula$);
	wks.col.lname$ = %(rs.col2.lname$);
}


Yiming


Got it.
Is there a way to do the same via GUI?

---
Andrey
Go to Top of Page

cpyang

USA
1408 Posts
Posted - 03/24/2026 :  09:02:47 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
We are adding this ability in 2026b to add column to other sheets.
We can work on also Insert support.
Or adding is good enough?




CP
Go to Top of Page

AKazak

Russia
1258 Posts
Posted - 03/24/2026 :  10:03:43 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by cpyang

We are adding this ability in 2026b to add column to other sheets.
We can work on also Insert support.
Or adding is good enough?




CP



Dear CP,

Add and Insert would be great!
Besides, please implement selection 1+ source columns to paste to the similar worksheets.

---
Andrey
Go to Top of Page

cpyang

USA
1408 Posts
Posted - 04/16/2026 :  2:18:15 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
hi Andrey

We have just release beta3 with this ability to insert selected columns to similar worksheets.

CP
Go to Top of Page

AKazak

Russia
1258 Posts
Posted - 04/17/2026 :  04:03:03 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by cpyang

hi Andrey

We have just release beta3 with this ability to insert selected columns to similar worksheets.

CP



Dear CP,

Well noted.
I will download b3 and test it.

---
Andrey
Go to Top of Page

snowli

USA
1485 Posts
Posted - 04/27/2026 :  5:09:21 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi Andrey,

Just FYI that we released beta4 with some bug fixes including Insert into Other Sheets issues.

Could you use beta4 instead of beta3?


Thanks, Snow
Go to Top of Page

AKazak

Russia
1258 Posts
Posted - 04/28/2026 :  10:20:46 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
quote:
Originally posted by snowli

Hi Andrey,

Just FYI that we released beta4 with some bug fixes including Insert into Other Sheets issues.

Could you use beta4 instead of beta3?


Thanks, Snow


Dear Snow,
Sure thing!
I will use 2026b Beta4.

---
Andrey
Go to Top of Page

AKazak

Russia
1258 Posts
Posted - 05/27/2026 :  09:49:25 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear Snow,

I have checked with Beta 5 (@V=10.350168) and found that:
1) "Insert to Other Sheets..." works so far so good;
2) on each of the resulting sheets I get the first two columns selected (see below); it would be great if only the added columns would be selected after the the command execution:


In the meantime I will carry on testing "Insert to Other Sheets..." further.

---
Andrey
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000