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

[PaulVrugt]

is there any news about a fix for this bug? We're facing similar issues when converting excel files to PDF, and need to offer a solution to our customers

 

[Roland]

I'm having a problem which is very similar. When I insert an image (I've
tried both EMF and TIFF) it does not scale properly when exporting to PDF or
XPS.

Again, this problem only appears if the spread sheet is set to scale to
something other than 100%.

If someone knows about a fix for this problem (other than going back to SP1)
please post.

 

[Alice]

Hi, I'm also wanting to have a timeframe on this. I work for a large
organisation and uninstalling Service Packs is not a viable option for
solving this. I need to be able to produce PDFs of charts for reports to the
CEO and this has been delayed by more than 3 months now due to this bug.

Please advise when this problem will be fixed.

 

[Gord Dibben]

This is a Peer to Peer news group manned(personned?) by volunteers not
working for MS

No Microsoft people around here to advise you.


Gord Dibben MS Excel MVP

 

[Excel Master 5000]

I can confirm that this is still a problem. MS, get on this dudes.

 

[Roland]

I've posted a message at this address, I don't know if that will help but may
more of you should do the same...

http://mymfe.microsoft.com/Office 2007/Feedback.aspx?formID=81

 

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

 

[pootle_flump]

Hi

I can confirm I am experiencing this problem too. There a few subtle differences for me though.

My chart and images save just fine to PDF if I save only a single sheet. I experience the problems only if I save multiple sheets. I have tested the code in SP1 and it works fine. Setting my printer to PDFCreator or a PS printer makes no difference to my PDF.

I think it is very disappointing that Microsoft have introduced a bug in to SP2, have been aware of this bug for months (someone claiming to represent Microsoft has posted in this thread) and have not yet released a fix. I've lost nearly two development days due to this bug. I hope that there is something in the pipeline due for release soon. A "Print to PDF" option in Excel that does not print objects and images correctly is pretty well next to useless.

 

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

 

[lewis_m]

I experienced a similar problem after upgrading office 2007 to SP2. When I saved as pdf my excel charts were the wrong size and were positioned on the page incorrectly.

The microsoft hotfix KB973402 solved the problem -although it specifically mentions images rather than charts in the article.

http://support.microsoft.com/kb/973402