Jump to content
Martijn Wingelaar

Less or equal in marrionette

Recommended Posts

Hello Users.

Can someone help me with a small problem.

I'm trying to make a a connection between 1 and 2.

Where if the outcome is smaller or equal to let's say is 0,5.

It will show a a zero in my WS1 worksheet column E.

Can't get it to work.

Should be quit straight forward i think.

Any ideas?

 

Greetings Martijn

 

Schermafbeelding 2020-07-04 om 19.01.30.png

WORKSHEET 4_ v2020.vwx

Share this post


Link to post
Posted (edited)

don't change the epsilon value in the "Less Node" (its only the computational accuracy)

in your file i added a simple example, how to use the "less node"

greatings M. Graf  WORKSHEET 4_ v2020_MG.vwx

Edited by m.graf

Share this post


Link to post

Hello Martijn Wingelaar,

 

don't know why - but the (old?) "get subrow cell value" node creates "string" output, then equal or less equal can't work 🙂

i added the normal "get Cell Value" and it works... 

 

You can test your Scripts with the debug Mode... the red "bug" button

1583484069_Bildschirmfoto2020-07-10um18_53_15.thumb.png.083101c4129baab3fd231eb886d548d7.png

 

600448606_Bildschirmfoto2020-07-10um18_44_26.thumb.png.805f111a7c3f0a40742769b737cf474f.png 

 

Marionette Worksheet File-MG.vwx

 

Share this post


Link to post

@m.graf All data in VW records (and therefore most of the data in worksheets) is actually stored as strings. If a worksheet cell is formatted as a number then the conversion happens behind the scenes and you can do math.

 

The description for GetSubrowValue says that it returns the "Display Value" of the cell. Based on what I know, that tells me that is it intended to return a string since that is the way it is displaying the data. And it will probably return a string that includes any cell formatting that has been applied.

 

I would expect Marionette to have a String 2 Number node, but I could not find it.

Share this post


Link to post
Posted (edited)

@Pat Stanford,

the get cell value node from VW 2020 returns value not string, but Martijn Wingelaars old Node (from VW2015 or Forum?) returns string. I only added the new node in his script and it works. 

greatings M.Graf   

 

Bildschirmfoto 2020-07-11 um 09.51.06.png897000357_Bildschirmfoto2020-07-11um09_50_22.thumb.png.69098c41d5ce36f6c89849c2c9aafc6d.png

Edited by m.graf

Share this post


Link to post

the real problem:

 

the cell value in the old "get cell value node" is a string with "comma" like  "1,23"

the "float node" only converts strings with Dezimalpoints like "1.23" to numbers

But the script stops at the first node with the error message,  so it is difficult for the user to find the error. 

 

greatings M.Graf

string_to_value.vwx

 

 

438711262_Bildschirmfoto2020-07-11um12_43_09.thumb.png.01cda9d7d78ff2ecbdef27f7e4679278.png   

Share this post


Link to post

Hello Guys.

Sorry for the late responce.

But I was on a small holiday.  🤘😀🤘

But i'm gonna look into the files and options.

I hope i get it working.

Fingers crosed.

 

Greetings M Wingelaar

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×
×
  • Create New...