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
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 wdelrows on worksheet containing text

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
JokerOne Posted - 06/21/2016 : 09:34:27 AM
Origin Ver. 9.1 and Service Release (Select Help-->About Origin):
Operating System: win 7

Hello,

I am not sure, if this is known or supposed to be:
When I am trying to apply (command-line)
wdelrows del:=1
to a worksheet containing only text (strings), then I get a command error. (#Command Error)

Is there any good reason for that?

When I am appling the same command to a worksheet with numbers only, everything works fine.

What is a good way to remove rows containing strings in general?

Thanks

14   L A T E S T    R E P L I E S    (Newest First)
JokerOne Posted - 06/29/2016 : 03:48:59 AM
So,

1.) reinstalled Origin 9.1 (SR1):
2.) Tried wdelrows-issue --> still persisting
3.) Updated to SR3 (worked this time)
4.) Tried wdelrows-issue --> SOLVED! - Yeah!

I guess, anything was corupted in my original installation.

Thanks all.



JokerOne Posted - 06/29/2016 : 03:15:48 AM
Oh dear,

the update somehow failed.
I get an error " System Folder build failed! Please resolve."
upon startup.

I already tried http://www.originlab.com/doc/Quick-Help/System-Folder-Build-Failed
but did not solve the problem.

I will try a complete reinstall, I guess.
Hideo Fujii Posted - 06/28/2016 : 12:30:31 PM
Hi JokerOne,

> I have Origin 9.1 SR1 set to english then.

Could you please upgrade your 9.1 SR1 to Sr3, which is the latest and most bug-fixed, and try it again?

Thank you.

--Hideo Fujii
OriginLab
JokerOne Posted - 06/28/2016 : 11:00:09 AM
Thanks all for your effort.

I have Origin 9.1 SR1 set to english then.

Please see the attached screenshot, the issue also persists in the english version.

Just doublechecking: You are aware of that note in the wdelrows pop-up window, saying
"You must have numerical data for this analysis"?

Also, I have access to Origin 2016, I do not face the issue there, but I require to get a script running in Origin 9.1. using that wdelrows function.

Hideo Fujii Posted - 06/28/2016 : 10:43:46 AM
Hi JokerOne,

Your situation is really perplexing us as we cannot reproduce your problem here. Sorry, but could you
please download the Origin 2016 Evaluation version, and try it both in English mode and German mode?
http://www.originlab.com/demodownload.aspx

Also, could you please try the English mode of your Origin 9.2 to see how it goes?
(To change the language mode, choose "Help> Change Language" menu.)

Thank you for your assistance.

--Hideo Fujii
OriginLab
JokerOne Posted - 06/28/2016 : 09:39:56 AM
Hello,

I tried to reset the user folder, but the wdelrows behavior persists.
Chris D Posted - 06/27/2016 : 4:28:34 PM
Hi Joker,

Let's try this:
1) Make a backup copy of your Origin User Files folder.
2) Follow the steps outlined in this FAQ:
http://www.originlab.com/doc/Quick-Help/System-Folder-Build-Failed

Does that fix the issue?



Thanks,
Chris Drozdowski
Originlab Technical Support
JokerOne Posted - 06/27/2016 : 03:10:35 AM
Hello,

thank you for dealing with this issue.

I tried to add some data in the second colum, but the situation remains the same. See attached screenshot.

Hideo Fujii Posted - 06/23/2016 : 5:44:05 PM
Hi JokerOne,

As far as I have tested, the error is related to the situation when the specified dataset's size is zero;
a bug seems to be involved, and what is said about the numeric data in the error message shouldn't matter.
As in your screenshot, the second column is completely blank, and it seems that by some bug-related reason,
Origin mistakenly didn't recognized the existing first column's data to be operated.

Though still I couldn't reproduce the exact situation you faced, I guess that if you put any data, even
a missing value or a string, to the first cell in the second column, the error may be gone. Could you please try?
Our developer would look at the problem further.

--Hideo Fujii
OriginLab

JokerOne Posted - 06/23/2016 : 11:04:11 AM
Hello Hideo,

your idea results in very helpful information.

The window says:
"You require numerical data to perform this analysis"
(Sie benötigen numerische...)

This sounds quite clear to me? Is it only working with numerical data?
Hideo Fujii Posted - 06/23/2016 : 10:10:28 AM
Hi JokerOne,


hmmm.... strange. I have tried the same example on my Origin 9.1 Sr3, and got no error.
Possible (though I feel unlikely) reasons may be either because of the 9.1's specific service
release, or because yours is a German version.

First could you please try the following command to see if it still fails or not from the interface?
wdelrows -d;

Still a mystery for me.

--Hideo Fujii
OriginLab
JokerOne Posted - 06/23/2016 : 02:25:58 AM
Hello and thank for careing.

I attached a screenshot, that hopefully illustrates my problem properly.
cpyang Posted - 06/22/2016 : 10:05:22 PM
Hi JokerOne,

wDelRows default input is <active> so if you have a column selected, then it will only delete rows from that column, so make sure there is no selection on the worksheet, or change the input.

CP
Hideo Fujii Posted - 06/22/2016 : 3:46:57 PM
Hi JokerOne,

Although I have tried the x-function command from the Script window for a worksheet which contains
2 columns and 6 rows - all 12 cells contain strings, I couldn't reproduce the problem (in Origin 9.1,
2016, and even in 9.0). I received no error message. I suspect something further condition caused
the problem. Could you please show the procedure and sample data to demonstrate the problem?

Thank you.

--Hideo Fujii
OriginLab

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000