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

## Recommended Posts

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

whats that?

thanks markus

Edited by HAUSrucker
• Vectorworks, Inc Employee

This is the correct expression.

=('Space'.'11_Area')

aha - do you have overview-pdf?

how can i make a total?

thank you

Someone else just had this question. 'Space'.'Gross Area' also works.

hth

mk

with Gross Area i get only e.g. 89,00 and not 89,34!!!!

THATS A BIG BUG!!!

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

hm - can i have your file?

here is mine:

thank you

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

ok - thank you - but i?ve a big project and when i have to change every space symbol than i?m dead!

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

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.

a refresh and left-right don?t work in my case! - hm

i?m waiting for service pack 3 and lost money :-(

wanna be a software engineer in my next life!

• 2 weeks later...

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

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.

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

• 2 months later...

We are waiting for a new service pack!

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

×   Pasted as rich text.   Restore formatting

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

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

×
×

• KBASE
• #### MARIONETTE

×
• Create New...