BUG: Creating a PDF or XPS of a chart in Excel 2007 with SP2installed

[Ron de Bruin]

Hi all

No solution but a update of my PDF code page

Maybe you want to test it for me
http://www.rondebruin.nl/pdf.htm

 

[Whoop]

Has this problem been solved? In case, where do I find the solution?

Regards,
Arild

 

[Whoop]

Hello everyone, are there any news on this topic? In case, where do I find a
solution?

 

[Whoop]

Hi, im using your code, and it works perfectly for what I'll use it for.
Potentially saves me a lot of mouse clicks each day. But I really NEED the
charts to show in the .pdfs, otherwise I cannot use it. I read that microsoft
are working on it, and someone mensioned a month to get an update, but thats
more than a month ago. Does anyone have an update?

 

[Ron de Bruin]

Hi Whoop

I have no info on this moment and I will reply in this thread if I have

FYI
I have no problem in the Beta of 2010


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

 

[Gary]

WORKAROUND THAT WORKS:

Install a PS printer driver. No need to have a physical printer available.
Set the PS printer as the default.
Produce your PDF (which will render correctly).
Change the default printer back to your actual printer.

I'm fortunate in that my 1320n printer has a PS version available. When I
switched from the PCL5e version to the PS version, the PDF rendering problem
went away.

This was the 'temporary workaround' suggested by Microsoft about 3 months
ago. Still waiting for their promised communications with a permanent fix...

Hope that helps.
Gary

 

[Bertrand]

To expand on the workaround mentionned by CannedCorn, here is what I found:

In an attempt to find a workaround, I installed PDFCreator. This creates an
additional printer called "PDFCreator". Printing to it Excel sheets
containing embedded graphics produces good pdfs, as anyone would expect.

The good side effet is that as long as "PDFCreator" remains the selected
printer, the built-in command "Save as pdf" also produces good results. When
I revert to the standard printer and select "Save as pdf" again, the scaling
problem re-appears.

For those who like me need to embed the "save as pdf" command in a vba
script, which is easier than using the pdfcreator api, the process is:
- save the selected printer
- select printer "PDFCreator"
- save as pdf
- restore initial printer

regards,

 

[Bob I]

Also try a PS version of your printer driver as opposed to the usual PCL
version.

 

[Rob S.]

Any update to this yet? It still seems to be a problem.

 

[Freek]

Hi,

Any news on this problem? I experience the same problem and still can't find
any solution...

Thanks, Freek

 

[Ron de Bruin]

Hi Freek

I not see a update for this problem or read useful information about it.