Jump to content

Formatting Worksheet Database Cells


_James

Recommended Posts

This might be one for @Nikolay Zhelyazkov but perhaps others have come across this also.

 

We have a DIY Issue Sheet for our projects that is based on the default VW worksheet.

 

What we would like to do is 'highlight' the sheets included in the current issue which at the beginning of the project is obviously all of the drawings, but after that the issues are more sporadic with some drawings issued here and some issued there.

 

This creates a formatting problem as it seems that database cells all have exactly the same formatting and cant each have their own 'highlighted' status. When I try to format one row to have a yellow background, they all have yellow backgrounds which defeats the aim of being able to quickly identify which drawings are being issued at the given point.

 

Has anyone come up with a workaround/knows how to do this properly?

 

Thanks!

Screenshot 2019-09-25 at 16.25.15.png

 

 

174807006_Screenshot2019-09-25at16_29_43.thumb.png.da002e45d8cc33041c1a13b033c08fd4.png

Edited by _James
Link to comment

What about in stead of highlighting you add a custom field to the sheet data record? Something like “current Issue”

 

This could be listed on n it’s own column in your worksheet and toggled to true or false directly from the worksheet too. 

 

Maybe even @Pat Stanford knows how to make the “true” cells highlight?

 

But even if not you would still have an identifier of current issue drawings.

 

Link to comment

If this worksheet is placed in your document somewhere, another workaround could be to add the yellow highlight as a rectangle (with reduced opacity) in front of your worksheet, or put it behind the worksheet and make sure the worksheet has no fill.

 

Of course this would be completely manual and have no connection to the data... but at the very least would allow you to 'highlight' individual cells.

 

676668198_ScreenShot2019-09-25at12_47_48PM.thumb.png.b16bd2399b45fdca858d43d4f2eb156b.png

  • Like 1
Link to comment

Hi all,

 

thanks for the suggestions. I think the best workaround is to make a simple yellow rectangle as @Andy Broomell suggested. With the worksheet cells set to unfilled this can be sent to the back so that the text sits on top and is clear.

 

The copy and paste is a good solution, but it's a slightly longer workaround. Bearing in mind that once the worksheet is set up and recalculated etc. I then copy and paste as a bitmap, and then duplicate and crop these to give the illusion of a worksheet that is more than one page of A4. So i'm trying to keep workaround's as short as possible! I know VW can spread worksheets across 'pages' - but the way in which it does it is quite cumbersome and doesn't seem to be able to be done retrospectively to suit an issue sheet that changes in length over the course of a project

Link to comment
  • Vectorworks, Inc Employee

@_James Other solution might be to just create the Multiple Pages report from the Title Block Manager, which is identical to the database one but is not using database rows and could spread into multiple worksheets. The only problem there is that you will have to update the worksheets from the TBManager only.

Link to comment

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

×
×
  • Create New...