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

[gareth.drake]

Hi,

Can anyone confirm they see the same results?

I have a spreadsheet, created in Excel 2007 RTM. The first page
contains a title in row 1, summary information in rows 2 to 8, then a
'Line with Markers' chart, filling cells B10 to N38 (with a bt of
overhang into columns A and O, in fact).

In Excel 2007 RTM and Excel 2007 SP1, this page printed correctly,
previewed correctly, and would save as PDF and XPS correctly (using
the Office 2007 PDF/XPS add-in). After installing SP2, whilst the page
still previews and prints correctly, output to PDF and XPS is wrong.
Rows 1-8 are fine, but the graph is shown at about 150% of its actual
size, and hence the right edge and bottom edge are chopped off. If I
select only the chart, it outputs fine. It's only if I output the
whole page, including the chart, that the problem occurs.

Can anyone else confirm whether they are seeing this same behaviour?
The first time I tried to install the service pack (full download, not
via Windows Update) it failed gracefully due to lack of disk space
(apparently 900MB isn't enough!). When I tried again after freeing up
some space, it succeeded.

Thanks,
Gary

 

[Ron Rosenfeld]

Hi,

Can anyone confirm they see the same results?

I have a spreadsheet, created in Excel 2007 RTM. The first page
contains a title in row 1, summary information in rows 2 to 8, then a
'Line with Markers' chart, filling cells B10 to N38 (with a bt of
overhang into columns A and O, in fact).

In Excel 2007 RTM and Excel 2007 SP1, this page printed correctly,
previewed correctly, and would save as PDF and XPS correctly (using
the Office 2007 PDF/XPS add-in). After installing SP2, whilst the page
still previews and prints correctly, output to PDF and XPS is wrong.
Rows 1-8 are fine, but the graph is shown at about 150% of its actual
size, and hence the right edge and bottom edge are chopped off. If I
select only the chart, it outputs fine. It's only if I output the
whole page, including the chart, that the problem occurs.

Can anyone else confirm whether they are seeing this same behaviour?
The first time I tried to install the service pack (full download, not
via Windows Update) it failed gracefully due to lack of disk space
(apparently 900MB isn't enough!). When I tried again after freeing up
some space, it succeeded.

Thanks,
Gary

Thanks for posting that. I'm still on SP1. I think I'll hold off until I see
some responses to your question.
--ron

 

[Ron de Bruin]

Hi Gary

Can you send me the file private so I can test it in SP1 and SP2

 

[Tom Anderson]

Hi,

Can anyone confirm they see the same results?

I have a spreadsheet, created in Excel 2007 RTM. The first page
contains a title in row 1, summary information in rows 2 to 8, then a
'Line with Markers' chart, filling cells B10 to N38 (with a bt of
overhang into columns A and O, in fact).

In Excel 2007 RTM and Excel 2007 SP1, this page printed correctly,
previewed correctly, and would save as PDF and XPS correctly (using
the Office 2007 PDF/XPS add-in). After installing SP2, whilst the page
still previews and prints correctly, output to PDF and XPS is wrong.
Rows 1-8 are fine, but the graph is shown at about 150% of its actual
size, and hence the right edge and bottom edge are chopped off. If I
select only the chart, it outputs fine. It's only if I output the
whole page, including the chart, that the problem occurs.

Can anyone else confirm whether they are seeing this same behaviour?
The first time I tried to install the service pack (full download, not
via Windows Update) it failed gracefully due to lack of disk space
(apparently 900MB isn't enough!). When I tried again after freeing up
some space, it succeeded.

Thanks,
Gary

 

[Tom Anderson]

I am getting the same issue. I have someone who is creating graphs. I can
..pdf just the graph but not the document that contains it. All other
information comes out fine but there is a blank space where the graph should
be.

I have found this link:
http://news.office-watch.com/t/n.aspx?articleid=864&zoneid=12 which point to
this KB article:
http://support.microsoft.com/default.aspx/kb/969413/

I tried applying the patch here:
http://thehotfixshare.net/board/index.php?showtopic=12800 to no avail.

I have tried uninstalling SP2 and repairing Office, this does not work.

Any help appreciated.

Thanks,

Tom

 

[kathy.blandino]

Hi,

Can anyone confirm they see the same results?

I have a spreadsheet, created in Excel 2007 RTM. The first page
contains a title in row 1, summary information in rows 2 to 8, then a
'Line with Markers' chart, filling cells B10 to N38 (with a bt of
overhang into columns A and O, in fact).

In Excel 2007 RTM and Excel 2007 SP1, this page printed correctly,
previewed correctly, and would save as PDF and XPS correctly (using
the Office 2007 PDF/XPS add-in). After installing SP2, whilst the page
still previews and prints correctly, output to PDF and XPS is wrong.
Rows 1-8 are fine, but the graph is shown at about 150% of its actual
size, and hence the right edge and bottom edge are chopped off. If I
select only the chart, it outputs fine. It's only if I output the
whole page, including the chart, that the problem occurs.

Can anyone else confirm whether they are seeing this same behaviour?
The first time I tried to install the service pack (full download, not
via Windows Update) it failed gracefully due to lack of disk space
(apparently 900MB isn't enough!). When I tried again after freeing up
some space, it succeeded.

Thanks,
Gary

Yes - we have just confirmed the Save As PDF problem with embedded
charts on a worksheet. We were using the Add-in provided by Microsoft
for the Save-as PDF functionality prior to the Office 2007 SP2 update
and it was working fine. The new Save-as PDF functionality included
in Excel 2007 SP2 is the problem.

 

[Steve W]

I have exactly the same results... after installing SP2 my spread sheets on
excel do not translate to PDF correctly, the imbedded images and graphs are
changed so that they distort the image. Print preview in excel shows no
change - only appears in the PDF image.

Steve Wallace "(e-mail address removed)"

 

[Jo]

I have the same issues. Any updates to fix this? I was troubleshooting with
Microsoft Support - but no solution as of yet. Thanks.

 

[Peter]

I am using Excel 2007 SP2 in the Danish version. I am facing the same
problem with pdf. From time to time it help to preview a regular
print. But this is not allways enough.

Let's hope that there will be a solution soon.

Regards

Peter

 

[Jo]

I just spoke with Microsoft yesterday and showed them this thread. They are
aware of the problem and are working on it.. probably in a month the Fix will
be dowloadable via Windows Live Update.

 

[spu]

I just spoke with Microsoft yesterday and showed them this thread. They are
aware of the problem and are working on it.. probably in a month the Fix will
be dowloadable via Windows Live Update.

Any news concerning this Bug? Any temporaly workarounds?

 

[spu]

Any news/workarounds concerning this BUG. I have the same problem using the
German version of Excel2007 SP2.

 

[Ron de Bruin]

Hi Spu

There is no more information on this moment.
We all hope that there will be a fix soon

--

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

 

[spu]

This doesn't work for me. I don't have adobe pdf installed anyway. I'm using
the Excel PDF because it is the only one that displays the new Excel 2007
charts correctly. Changing Printer to PDFCreator, Microsoft Office Document
Image Writer etc. always prints the same results.

It seems that since SP2 the integrated PDF-Writer has problems to scale the
Chart correctly. Some worksheets in my Workbook are scaled to 75%. The
PDF-Function scales the Document correctly to the page but not the
Shapes/Charts.

 

[Herbert]

hello Peter

just want to ask if any solution is available?

got the same problem. solved it by reinstalling office without SP2 and
without KB969682.
by now that works but i am not happy with it.

Regards

Herbert

 

[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