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
 Countif function problem		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Duff

Argentina
42 Posts
Posted - 08/19/2017 :  10:05:50 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 2016
Operating System: Win7 64bits

Hi,
When I use Countif in Set Column Values [specifically Countif(Col("A"),"Col("A")>=0"] and Col("A") has a lot of rows with data (>2000 rows), Origin Crash.
Thanks!

cpyang

USA
1406 Posts
Posted - 08/20/2017 :  09:05:31 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I tried Origin 2017 with 10000 rows and I don't see a problem.

CP
Go to Top of Page

Duff

Argentina
42 Posts
Posted - 08/20/2017 :  10:26:39 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi, with Origin 64bits? I tried in 2 differents PC (i7 8 and 16Gb RAM, 2016 and 2017sr2) and Origin doesn't crash, but the process is too slow (1 minute with 3000 rows and much more with 10000 rows).
Go to Top of Page

cpyang

USA
1406 Posts
Posted - 08/20/2017 :  10:58:56 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I can understand using countif in a cell formula, but can you explain what you are trying to do with 10000 rows using countif?

CP
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