| Author |
 Topic  |
|
|
JokerOne
Germany
58 Posts |
 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
|
|
|
Hideo Fujii
USA
1582 Posts |
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 |
 |
|
|
cpyang
USA
1406 Posts |
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
|
|
|
|
JokerOne
Germany
58 Posts |
Posted - 06/23/2016 : 02:25:58 AM
|
Hello and thank for careing.
I attached a screenshot, that hopefully illustrates my problem properly.
 |
|
|
|
Hideo Fujii
USA
1582 Posts |
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
|
Edited by - Hideo Fujii on 06/23/2016 10:11:40 AM |
|
|
|
JokerOne
Germany
58 Posts |
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
USA
1582 Posts |
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
Germany
58 Posts |
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.
 |
|
|
|
Chris D
428 Posts |
|
|
JokerOne
Germany
58 Posts |
Posted - 06/28/2016 : 09:39:56 AM
|
Hello,
I tried to reset the user folder, but the wdelrows behavior persists. |
|
|
|
Hideo Fujii
USA
1582 Posts |
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 |
Edited by - Hideo Fujii on 06/28/2016 10:46:02 AM |
|
|
|
JokerOne
Germany
58 Posts |
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
USA
1582 Posts |
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
Germany
58 Posts |
|
|
JokerOne
Germany
58 Posts |
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.
|
|
|
| |
Topic |
|
wdelrows on worksheet containing text