Jump to content

Report/Worksheet Image Function - Consistent Size?

Recommended Posts

When using the image function on a report/worksheet database is there a way to keep the images at a standard scale or ratio?  I.E. I am showing a list of truss with truss symbols in there, but let's say I have a 12"x12" corner piece on a row and the next row a 12"x12"x 120" piece that 120" piece looks visually significantly smaller compared to the other piece.  I ideally just want to lock the sizes to be consistent and I have not seen a great way to do this yet.  However, my guess is someone here may have.  


Any help is appreciated




Share this post

Link to post



If I understand your question…. You want the images of the truss symbols to be scaled correctly relative to each other?


Double click the worksheet or right click it in the Resource Manger to open it.


Right click on a cell that has an image.  Choose Format Cells…


Select the Image Tab on the far right.


I think by default it's set to autosize.  I find custom scale to be more useful.  Then I set the scale to be the same as the viewport . 


The other thing that's useful when making it readable is to set he margin.  It defaults to 2 points.


This should make a 12x12 corner block 1/10 the width of a 12x12x120 stick.



  • Like 1

Share this post

Link to post

Yep, that was just what I was looking for.  I don't generally do images in worksheets so wasn't super familiar with where to find that.  I guess we just have to ask the worksheet master!

Share this post

Link to post

Actually, one thing I have been wondering with images is that it seems as if the "row height" does not seem to autofit when there is an image in there.  Any thoughts on that?  

Share this post

Link to post

I think there's a little row height bug.  Usually if you switch it from auto fit to a constant size and then back again it wakes up and auto fits.

Share this post

Link to post

Hm, can anybody explain how the 'scale to' options exactly work when formatting worksheet image cells?


For me, only autoscale works, otherwise I end up with something like a single vertical line for all objects that are symbols (the top 4 rows). Groups (the bottom 3 examples) seem to be rendered correctly.

Looks like a bug to me, in that x-scale isn't computed correctly for symbols, only y-scale. I use VW2019 SP2 (MACOS)  int/en.

And I should mention that all objects are 2D-drawings in plan view.


scaled workheet images-auto.jpg

scaled workheet images-200.jpg

Edited by Olaf Pfeifer

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


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.