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 |