HAUSrucker Posted January 6, 2011 Share Posted January 6, 2011 (edited) hi - i used in a worksheet always the expression: =('Space'.'Area') to get the Area of a space. Since VW2011 the numbers in the worksheet are cut off: e.g. in the Space: 89,34 s qm in the worksheet: 89 the i format the cell to decimal with 3 places, than i got 89,000 SpaceArea.jpg SpaceArea.vwx whats that? thanks markus Edited January 6, 2011 by HAUSrucker Quote Link to comment
Vectorworks, Inc Employee Luis M Ruiz Posted January 6, 2011 Vectorworks, Inc Employee Share Posted January 6, 2011 This is the correct expression. =('Space'.'11_Area') Quote Link to comment
HAUSrucker Posted January 6, 2011 Author Share Posted January 6, 2011 aha - do you have overview-pdf? how can i make a total? thank you Quote Link to comment
michaelk Posted January 7, 2011 Share Posted January 7, 2011 Someone else just had this question. 'Space'.'Gross Area' also works. http://techboard.nemetschek.net/ubbthreads.php?ubb=showflat&Main=30397&Number=149158#Post149158 hth mk Quote Link to comment
HAUSrucker Posted January 8, 2011 Author Share Posted January 8, 2011 with Gross Area i get only e.g. 89,00 and not 89,34!!!! THATS A BIG BUG!!! Quote Link to comment
michaelk Posted January 9, 2011 Share Posted January 9, 2011 Interesting... Use 'Space'.'Gross Area'. Value in worksheet is 37 sq m Change the format of the cell to dimension area (this step may not matter) Resize the space object. Recalculate the worksheet. On my machine the worksheet is exactly equal to the space object label. hmmmm mk Quote Link to comment
HAUSrucker Posted January 9, 2011 Author Share Posted January 9, 2011 hm - can i have your file? here is mine: SpaceGrossArea thank you Quote Link to comment
michaelk Posted January 9, 2011 Share Posted January 9, 2011 Here it is... For this file I started with your file and did the following steps: 1. Changed =('Space'.'Area') to =('Space'.'Gross Area') 2. Inserted a 2D locus on one side of the space object (as a place holder) 3. Resized the space object 4. Recalculated the worksheet 5. Resized the space object back to it's original size. 6. Deleted the 2D locus 7. Recalculated the worksheet Space object label is 37.5 Worksheet cell is 37.50 hth mk Quote Link to comment
HAUSrucker Posted January 10, 2011 Author Share Posted January 10, 2011 ok - thank you - but i?ve a big project and when i have to change every space symbol than i?m dead! Quote Link to comment
michaelk Posted January 10, 2011 Share Posted January 10, 2011 Turns out you don't have to resize the space object. You just have to get it to refresh. This also works. 1. Change=('Space'.'Area') to =('Space'.'Gross Area') 2. Select the space area object(s). 3. Shift-right arrow, Shift-left arrow (or Shift-command-arrow) [moves the objects and moves them back and forces a refresh] 4. Recalculate the worksheet. hth mk Quote Link to comment
michaelk Posted January 10, 2011 Share Posted January 10, 2011 Good point. I've never tried that command. In the English version the command is called Reset All Plug-ins. I've always worried that "reset" means that it would change the values to some default value. Quote Link to comment
HAUSrucker Posted January 10, 2011 Author Share Posted January 10, 2011 a refresh and left-right don?t work in my case! - hm Quote Link to comment
HAUSrucker Posted January 12, 2011 Author Share Posted January 12, 2011 i?m waiting for service pack 3 and lost money :-( wanna be a software engineer in my next life! Quote Link to comment
HoskinsArchs Posted January 20, 2011 Share Posted January 20, 2011 @HAUSrucker: decimal marker issue for ('space'.'area') calculation I had exactly the same issue. Then I realized that the regional settings on my computer are set to Germany (if you are using Windows this is in the control panel>regional and language options). The issue seems to be that in UK and USA numbers are stored as in the format 123,456,789.00, whereas Germany and some other countries are using the format 123.456.789,00. This means the decimal marker in UK/USA is .(point) whereas in other countries it is a ,(comma). The regional setting seems to have an effect on the calculations of the Vectorworks worksheets, as if Vectorworks doesn't recognize anything behind a comma. After changing my regional setting to UK every newly created space in Vectorworks came up with a .(point) and best of all the =('Space'.'Area') works and also simple =sum() calculations are working again. I am not sure whether this will solve your problem, but given your user name it sounds as if you are based in a German speaking country and it might well be the same issue. Quote Link to comment
HoskinsArchs Posted January 20, 2011 Share Posted January 20, 2011 Given that the user who asked the question is based in Munich I bet my Vectorworks licence that changing the regional setting to use points as the decimal marker instead of commas will resolve the problem. I have tested it back and forward and with commas (German setting) the values behind the decimal markers are lost when using the =('Space'.'Area') command. Quote Link to comment
HAUSrucker Posted January 25, 2011 Author Share Posted January 25, 2011 i?ve tried it - on mac with german os x - it works - changed to english hm - but in vw 2010 i have no problems!!! and now...? Quote Link to comment
HAUSrucker Posted April 14, 2011 Author Share Posted April 14, 2011 We are waiting for a new service pack! Quote Link to comment
Recommended Posts
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.