Results 1 to 6 of 6
  1. #1
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adobe PDF Printer (2003)

    Hi All,

    We have a custom build excel application (which I cannot share) and we have noticed that when we set the default printer to Adobe PDF then various things slow down alot. It seems that excel wants to recalculate things but we aren't certain.

    Any suggestions (and I know that I haven't given you much to go on)?
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Adobe PDF Printer (2003)

    If you turn calculations to manual in tools - options, are things still slow?

    Steve

  3. #3
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adobe PDF Printer (2003)

    Firstly, turning calc to manual doesn't seem to make any time difference.

    secontly, more info: we continued reviewing the steps our code was performing and found the bottle neck to be in the part that checks that the columns widths are ok (ie no ####s). I borrowed some code from <post#=490,558>post 490,558</post: >. It seems to be a combination of column widths and the adobe printer.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Adobe PDF Printer (2003)

    What part of the code is slow?

    Does turning screenupdating off help any?

    Steve

  5. #5
    5 Star Lounger Ruff_Hi's Avatar
    Join Date
    Feb 2001
    Location
    New York, New York, USA
    Posts
    768
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adobe PDF Printer (2003)

    We haven't tracked it down to any particular line of code at present. Also, screen updating is off.

    We are thinking that it is the column.autofit, followed by the column.width resets that is taking all the time. We have about 30 sheets with about 10-12 (on average) columns per sheet. All this work for the rare column that might need to be widened - <img src=/S/hmmn.gif border=0 alt=hmmn width=15 height=15>. We are currently looking at flagging columns that might need column width checking and only processing those columns.

    And for some strange reason - it is much slower with the adobe pdf printer rather than a 'real' printer.

    I'll do some more research tonight or tomorrow and give some feedback on individual line performance.
    (Location Australia, then UK, but now USA. Heart, outlook, attitude, etc always Australian)
    Quote: "All Happiness is the release of internal pressure"

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adobe PDF Printer (2003)

    Methods like AutoFit tend to call the print driver to render the image (I don't know for sure that AutoFit calls the print driver, but my guess would be yes). If the print driver is slow (and the PDF driver is very slow), then the application is going to be slow.
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •