• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Problem with printing a spreadsheet

estillbham

New Member
I created a set of forms to use in creating bills for my clients. I use self-created Google Docs forms to keep up with my time, expenses, and receipts. When it is time to bill the client, I sort the time entries by client, copy and paste them to another form (created by me) in Excel 2010. I repeat for expenses and receipts -- putting them on separate forms in the Excel notebook.

Time entries are often several (wrapped) lines long. When I paste the data into the form, it looks correct. When I print it, the printed version often wraps in a different place than the on-screen form and I end up with the last line not showing on my printed bill.

Is there a place I should start my debugging to figure out what the problem is? I have attached a generic version of my billing forms.
 

Attachments

  • Bill form plain1.xlsx
    48.8 KB · Views: 2
Hi, estillbahm!
Consider uploading a sample file. It'd be easier to understand for people who might be able to help you.
Include a manually written output of the requested solution. Thanks.
Regards!
 
Here is a second sample file--this one with data in the Description column. Download it, view it on the screen, then print it.

In case it makes any difference, I use an HP OfficeJet Pro 8720.
 

Attachments

  • Bill form plain2.xlsx
    50.8 KB · Views: 6
Must have something to do with your printer. Printed fine here: HP OfficeJet 5610V All-In-One.

If your drivers haven't been updated in awhile and/or you are using a new OS, try upgrading the drivers first (my approach). This is presuming you've already checked the printer settings to insure you've captured the print area correctly, page dimensions are accurate, etc. etc.
 
Hi, estillbham!
The four worksheets got properly printed at three random printers.
Just the last three (Receipts, Time, Expense) don't get the last column printed, that of "Sthing Notes", but they're explicitly excluded from the print area ranges.
Is it correct?
Regards!
 
Back
Top