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)"

 

[ekulj]

Any update on this? I dont use charts but I have a spreadsheet with jpegs in them. SP1 one pdf'd them properly. By properly, I mean it looks just like the pdf output from Adobe and OSX pdf writers. Office 2007 SP2 messes up the pdf completely. The picture images are shifted down and to the right significantly. Its not handling text boxes properly, moving them and not pdf'ing them the same as is shown in Print Preview. Print Preview actually looks right. Save As PDF is very wrong.

 

[Jo]

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

 

[4far66]

Microsoft Aware

I have contacted Microsoft Tech Help today who had to use a separate program to uninstall SP2 as the version on Windows is not sufficient. As expected this resolved the problem.

The Technical Help team are now raising this as an issue with the US Development team to ensure that a new patch is created to resolve it.

 

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

 

[4far66]

Bug fix on it's way

I had the same confirmation from Microsoft helpdesk. Now a registered bug that they are working on a fix for.

 

[mliungman]

Try this...

Hi there!

We've also had some weird problems with Vista, Office 2007 and the "save as pdf" in Excel. One issue is that when the zoom level in a work sheet is not 100 %, the embedded images (in our case our logo) are moved down to the right in the resulting pdf. After a server maintenance the problem appeared regardless of zoom level. And we don't even have SP2...

In an attempt to figure out if the problem originated from our Excel files (some are old 2000 templates) or from the Excel application itself, I used a freeware pdf writer (PrimoPDF or Bullzip) and managed to create good looking pdf:s. Hence there shouldn't be anything wrong with the files. After the successful creation with the freeware writer, the Excel "save as pdf" began working again.

Maybe some of you can try this solution until a fix is available.

Cheers / Martin

(Another issue we've had is described here)

 

[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

 

[TylerBrock]

yeah this is definitely still a problem, I can confirm that this is a but with sp2 in excel and enlarges the charts... no fix yet

 

[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