Jump to content
Sign in to follow this  

Space - Rounding a formula

Recommended Posts


I'm trying to get to grips with the space tool and would like to use it to display both sqm area and the sq ft area. The only way I can think to do this is to use a formula in the additional data section.

I have successfully managed to get it to calculate the area using the formula:

=(#Net Area#*10.7639)

but I was hoping to round the figure up to the nearest whole foot. I have tried using the vectorworks function =round(#Net Area#*10.7639) but have been unsuccessful.

Is anyone able to help me with the correct formula? Or is there a better way to accomplish my needs?

Many thanks!

Share this post

Link to post

And then how to do I get the result of that formula to display in a worksheet? When I bring it in it just displays the formula!

Finding this so frustrating!!!

Thanks in advance...

Share this post

Link to post

Just to clarify, face.

You are trying to get both imperial and metric areas showing on the spaces' labels, i.e. on your floor plan, and in a worksheet, right?

Share this post

Link to post

Face, I can get what you want in a worksheet. Just use the formula:


to get the metric equivalent of the area.

On the other hand, I can't get even your formula (=(#Net Area#*10.7639)) in the Additional Data area to give me anything more than the same text back. How did you do that? Are you getting this Additional Data on your Space Label at all?

If the 'round' function is anything like Excel, it has to be given the desire degree of rounding desired as in round(cell_location,-2). The -2 indicates that you want the number to round up to hundreds, if I remember correctly.

Share this post

Link to post

Thanks for your help Mitch & Michael

You are correct Mitch: "You are trying to get both imperial and metric areas showing on the spaces' labels, i.e. on your floor plan, and in a worksheet, right?"

However I work in the UK so I work in metres for area but my client is from pre-metric days so prefers to work in feet.

This is a screenshot of what I did to get the space label to show both measurements: https://dl.dropboxusercontent.com/u/17200339/spaces.jpg You can see the space labels in the background.

Mitch, I thought the same about the round function too but the VW's help doesn't mention anything about specifying the degree the number needs to round to:

"round(number)- Rounds the specified number to the nearest whole number - =round(D11)

(returns the value in cell D11 rounded to the nearest whole number)"

Michael, thanks for the pointer for the other thread. My metre dimensions are working fine to whole metres as I've set that in the document preferences. The problem I think is that my feet are done using a formula so VW doesn't recognise them as a dimension unit and therefore doesn't round them off.

I'd also like to roll this out across the whole office so don't really want to rely on a script which needs to be recalculated each time.

Share this post

Link to post


Do you have to add your formula for changing units to each instance of the spaces or are you editing the space label symbol? If the latter, how do you do that?

Share this post

Link to post

The formula is in each instance of the spaces as additional data and then I call up this additional data as an extra bit to the space label symbol.

Share this post

Link to post


I know this thread has been inactive for a while, but I have a question about this space tool. First of all I do not see a "space tool" under my space planning toolset. I have a Raum Tool CW which whenever I try to use pops up this message;

"error occurred while opening plug-in. Make sure that there is a "Plug-ins" folder in the same folder as the application."

The Raum Tool shows up as a .vwr document rather than as a .vso like other vectorworks plug-in objects in the VectorWorks file directory. Not sure if that is related but it's a piece of information.

Other than that, how can I turn a rectangle or a polyline into a space object I guess? I'm using this particular file in 2D.

Thank you very much.

Edited by sle7en7

Share this post

Link to post

With a polygonal object selected, you should be able to use Modify > Convert > Create Objects from Shapes. Some other workspaces have it listed under AEC > Create objects from shapes (or Landmark> or Spotlight>)

You should be able to add the Space tool back to the workspace via the workspace editor, unless you have a localized copy that does not include it:


(I do not know if any localized versions omit the Space tool by default.)

Share this post

Link to post

Thank you very much Jim, I was able to bring the Space tool alive. Hoorayy. I was going to ask another question but I think I figured it out with an earlier post, hence my delayed appreciation. But thanks a lot again, for the prompt response.

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