Jump to content
  • 8
David Poiron

Worksheets wish list

Question

10 answers to this question

Recommended Posts

  • 0

I like these.

It would also be a great little feature if it was possible to hide selected columns sim to how the database row can be hidden. This way hidden columns could be used for sorting or summarising as well as controlling input data of other columns on the worksheet.

  • Like 2

Share this post


Link to post
  • 0

I REALLY wish:

1. The general appearance, workflow and editing structure was more like Excel/Numbers. i.e. entering formulas, merging and aligning with a single click, font and size options readily available, etc

2. A worksheet is available outside of Vectorworks to be edited via Excel/Numbers. Not all of our staff is competent in VW, and offloading some of the tedious data entry would be great. There would have to be a "Merge Worksheets" command when the VW file is re-opened after the worksheet data is edited. 

 

Just my $0.02!

Edited by livespace josha

Share this post


Link to post
  • 0

I would love to be able to link a cell in a worksheet to a text box on a design layer, so if a change occurs to the text box OR in the worksheet, it happens in both places.  In essence, a single edit to a worksheet, could ripple through many text boxes.

Share this post


Link to post
  • 0

This is possible using callouts. See below link. I use it for callouts notes throughout my files as well as keynotes.

 

Share this post


Link to post
  • 0

Hi @Boh 

I downloaded the VWX file you posted (thank you) and I tried working with/editing your worksheet and it didn't work well for my purposes.

 

To clarify:

I've created symbols with records that I populate manually to accommodate different jobs/uses.  I then create a worksheet which compiles all the record data in a client facing format.  Then there are other text boxes on a different layer which use some of this same info and could benefit from a direct link to a cell. 

 

 

 

 

Share this post


Link to post
  • 0

Ok, I see now. Have you tried data tags? In vw2020 the tags themselves can be listed in worksheets.

Share this post


Link to post
  • 0

"Insert Column" inserts a column to the left of the referenced column. I would like to see "Add Column" to add a column to the right of the last column.

 

At the moment, adding a column after the A - J range would add a new J and rename J to K. Then I will have to copy all the K formulas back to J and clear K.

  • Like 1

Share this post


Link to post
  • 0

Following up on the use of data tags - it works but not without faults.  While the tag pulls the info needed, it is also tied physically to the symbol.  When the symbol moves position, so does the data tag.  For my purpose, I need the geometry to exist independently, so either symbol or tag can change position without effecting the other.

 

I would still like to see a text box with the ability to link directly to a worksheet cell.

Share this post


Link to post
  • 0

There are some settings for positioning of data tags in relation to the object they are attached to but maybe still doesn’t work for you. 
 

Not ideal but another option is to have a single cell worksheet as your text box?

 

I realise this is just a work around...

Edited by Boh

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.

Guest
Answer this question...

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


 

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