What is the best way to print a worksheet?

[Bruce Kieffer]

I've tried creating a viewport of the worksheet and I set the sheet layer DPI to 600, but the header and body cells don't line up, and the print out is not sharp. What do you do?

[Pat Stanford]

Can you post or DM me the file to take a look at. I can't make that happen on my test file.

[Bruce Kieffer]

Pat, I sent the file to you in a message.

[_James]

Export it to excel/googlesheets sadly - much easier to control formatting and scale it to fit on the paper size of choice. If you have a lot of entries, such that the work sheet would go to two pages, Vectorworks doesn't easily handle splitting it across multiple pages. Excel and others do this without effort.

[Bruce Kieffer]

@_JamesI agree that formatting and printing is easier in Apple Numbers (I don't use Excel), but the work to update the Numbers file if there is a change in the Vectorworks worksheet is a problem. I was given a suggestion that I will try this morning and I will report back if it works.

[Bruce Kieffer]

The suggestion was to put the worksheet on another layer. Great, but I need it on my main design layer too. That option breaks down because the worksheet criteria needs to be Visibility Visible on the Concept Design design layer, and invisible on my Cut List design layer. Maybe there's another setting that makes the worksheet populate correctly on both design layers?

 

Edited August 4, 2021 by Bruce Kieffer

[Bruce Kieffer]

So it does work if a copy of the worksheet is placed on another design layer along with it being on my Design Concept layer. There's no need to change any of the Criteria, just don't recalculate the worksheet on the "Worksheet" design layer, only recalculate on the (my) Design Concept layer.

 

All of this said, you would think that a viewport is the right way to do this, and maybe it is, but it's too buggy when it comes to printing it.

[Hugues]

@Bruce Kieffer
Have you tried printing the worksheet from its palette?

 

[Bruce Kieffer]

I just tried that and it basically prints this. There's no way to control the formatting.