Jump to content
Sign in to follow this  

=('Space'.'Area') don?t work

Recommended Posts

hi - i used in a worksheet always the expression:


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



whats that?

thanks markus

Edited by HAUSrucker

Share this post

Link to post


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.



Share this post

Link to post

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



Share this post

Link to post

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.



Share this post

Link to post

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.

Share this post

Link to post


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.

Share this post

Link to post

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.

Share this post

Link to post

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...?

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.

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.

Sign in to follow this  


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...