How to get net height of a space object directly in a spreadsheet cell ?

[GatRed]

I manage  to get net height of a space object in a database line, but don’t manage to get it directly in a spreadsheet cell, despite following the vectorworks help.

Do I do something wrong ?

 

Vectorworks Space Net height.vwx

[Tobias Kern]

Hey @GatRed

 

this worked for me:

=OBJEKTDATA(PON='Space'; 'Universal Value'; ''; '11_Net Height')

 

Greetings

Tobi

[GatRed]

Hi @Tobias Kern !
thanks for your quick reply.
Indeed, if I remove the parenthesis around PON='Space' it works (but I don’t understand why we can’t have parenthesis which were here …)

But in a file where there is more than 1 space objects (which is common) I don’t manage to deal with the first argument of the OBJECTDADA command so it is more specific to only one space object.

For example here, calling the space object named "room1".

Any idea ?

(I attached a updated Vectorworks file)

Vectorworks Space Net height.vwx

[Tobias Kern]

Hey @GatRed

 

=OBJECTDATA(PON='Space' OR ('Space'.'11_Name'<>'room1'); 'Universal Value'; ''; '11_NET HEIGHT')

work, … but I don't know why.

 

For me it seems like BUG, I would expect that:

=OBJECTDATA(PON='Space' AND ('Space'.'11_Name'='room1'); 'Universal Value'; ''; '11_NET HEIGHT')

 

I fill a BUG-Report fort that.

 

Greeting

Tobi

Edited April 15 by Tobias Kern

[GatRed]

Hi @Tobias Kern,

thank you for having taken the time to make those tests.

Indeed, after a few tests on my side, I found the same results as you, which are inconsistent.

Thank you also for the bug report, I know it takes time to do it.

 

Have a nice day !

Gaëtan

 

[Tobias Kern]

Hey @GatRed,

 

I was very happy to help

The BUG-report is made.

 

Hope we can get a fix soon.

 

Happy Easter and have a nice day too.

Tobi