You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
BUG: Creating a PDF or XPS of a chart in Excel 2007 with SP2installed
R
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.
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.
A
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.
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.
G
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
working for MS
No Microsoft people around here to advise you.
Gord Dibben MS Excel MVP
E
Excel Master 5000
I can confirm that this is still a problem. MS, get on this dudes.
R
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
more of you should do the same...
http://mymfe.microsoft.com/Office 2007/Feedback.aspx?formID=81
R
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
No solution but a update of my PDF code page
Maybe you want to test it for me
http://www.rondebruin.nl/pdf.htm
W
Whoop
Has this problem been solved? In case, where do I find the solution?
Regards,
Arild
Regards,
Arild
W
Whoop
Hello everyone, are there any news on this topic? In case, where do I find a
solution?
solution?
W
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?
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?
R
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
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
G
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
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
B
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,
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,
B
Bob I
Also try a PS version of your printer driver as opposed to the usual PCL
version.
version.
- Joined
- Nov 18, 2009
- Messages
- 1
- Reaction score
- 0
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.
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.
R
Rob S.
Any update to this yet? It still seems to be a problem.
F
Freek
Hi,
Any news on this problem? I experience the same problem and still can't find
any solution...
Thanks, Freek
Any news on this problem? I experience the same problem and still can't find
any solution...
Thanks, Freek
R
Ron de Bruin
Hi Freek
I not see a update for this problem or read useful information about it.
I not see a update for this problem or read useful information about it.
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
The microsoft hotfix KB973402 solved the problem -although it specifically mentions images rather than charts in the article.
http://support.microsoft.com/kb/973402