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
 Apply filter to multiple columns		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Fiogter

Germany
5 Posts
Posted - 05/24/2018 :  07:41:29 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hi there,

I´d like to apply the same filter to about 100 columns.
How do i do that? (besides of clicking every single column and applying it)

Best regards

snowli

USA
1386 Posts
Posted - 05/24/2018 :  11:27:47 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hello, suppose you have filter set in column 1 already and what to apply to all other columns from 2nd column on, you can run the following script.

for (ii=2; ii<=wks.ncols;ii++)
{
wks.col$(ii).filter=1; //turn on filter
wks.col$(ii).filter$=wks.col1.filter$; //copy col1's filter condition
}
wks.runfilter(); //execute all filters

Thanks, Snow
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