Jump to content
_James

Split worksheet across multiple pages

Recommended Posts

We have a worksheet set up on an A4 page to act as an issue sheet. Our list of sheets tends to be longer than one A4 page allows however (Worksheet shown next to 2 vertically stacked A4 pages on sheet layer).

 

1195514058_ScreenShot2019-06-26at10_18_58.thumb.png.19020719456b6b83309eca6909ea45ee.png

 

If you print this, it sort of works, but leads to some cutting off: 

896422253_ScreenShot2019-06-26at10_19_18.thumb.png.f35c2028a11bff1f3d5fb0e1044cf60b.png

 

I have previously converted it to a bitmap, pasted it twice and cropped to how i'd like it to be on both pages, but this is a bit time consuming, has to be redone if a sheet gets added or omitted, and leads to a big file size. Any suggestions?

Share this post


Link to post

Hello @_James,

 

As I see you are creating Title Block Project Issue History worksheet. You could create this worksheet report from Title Block Manager using the option "Create multiple pages". This will create multiple worksheets depending on the values inputed for Rows Count and Start at Row. Make sure that these values correspond to the worksheet resources used, as otherwise you might get some odd results.

 

Best Regards,

Nikolay Zhelyazkov

Share this post


Link to post

Hi @Nikolay Zhelyazkov,

 

I'm aware of this, but it's quite difficult/unintuitive to use! Things that make me think this:

 

👎 Either you need to delve into VW's preferences files and amend the worksheet template to display your own company info or go into each page and change it. 

👎I have no idea how many rows I want to be displayed, it's good that it gives you an option to start at row x and specify the amount of rows per worksheet, but who knows this before they create the sheet/see it? Changing this dynamically once the worksheets have been created would be much easier, or like any spreadsheet programme it would be handy to just select a print area and spread large sheets over multiple pages.

👎Creating it from TBM seems to preclude you having an issue sheet as an office-wide resource and just dropping it into a sheet when needed. Keeping it as a resource lets the more VW literate people edit functionality and get it all working nicely to then allow less literate colleagues just drop it in without needing to get too bogged down in technicalities.


Time for a wishlist item? It's potentially so powerful but there's a lot of friction to get it to work as wanted. As ever, thanks for your quick replies!

 

Share this post


Link to post

May not be an option for you but you but perhaps just scale the worksheet to fit to your page 

Share this post


Link to post

Hello @_James,

 

First of all, thanks for your feedback. 🙂

 

13 hours ago, _James said:

 

👎 Either you need to delve into VW's preferences files and amend the worksheet template to display your own company info or go into each page and change it. 

- You could do this from VW UI by importing the worksheets from the default content to your active file, but it will take effect only in that file that way.

 

13 hours ago, _James said:

👎I have no idea how many rows I want to be displayed, it's good that it gives you an option to start at row x and specify the amount of rows per worksheet, but who knows this before they create the sheet/see it? Changing this dynamically once the worksheets have been created would be much easier, or like any spreadsheet programme it would be handy to just select a print area and spread large sheets over multiple pages.

- You could Initially use the default values and after that modify the values and worksheets and recreate them from the Manager. It still requires more than 1 simple step though.

 

13 hours ago, _James said:

👎Creating it from TBM seems to preclude you having an issue sheet as an office-wide resource and just dropping it into a sheet when needed. Keeping it as a resource lets the more VW literate people edit functionality and get it all working nicely to then allow less literate colleagues just drop it in without needing to get too bogged down in technicalities.

- As these worksheets are not using database rows, we cannot make them as simple resource, as they require dynamic filling. That is why we need them to be created from a menu command. However, you could still use them as normal resource, at least the ones with database row, as the others will not be filled that way.

 

13 hours ago, _James said:

Time for a wishlist item?

- You could fill in a wishlist item and we will see if we could make it happen. 🙂

 

Best Regards,

Nikolay Zhelyazkov

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


 

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