Problem with ExportAsFixedFormat in Excel 2007

[Robert Simpson]

I have a fairly large worksheet in which I've set the page setup such that
it will fit 1 pages wide and 1 pages tall. The greyed out zoom level for
this sheet is 25%

When I select ExportAsFixedFormat, the resulting PDF is 44in x 34in in size,
scaled up exactly 4 times the size of the 11in x 8.5in landscape mode it was
originally intended for.

So it rather looks to me like the zoom level isn't being accounted for when
I call ExportAsFixedFormat from my application.

So my question is ... When I set the PageSetup object to fit 1 page high by
1 page tall, and the Zoom property is now "False" -- how can I determine
what the zoom level will be when its printed? Obviously Excel does it,
because it shows you the greyed out value -- but I don't see any obvious way
of fetching it or computing it myself.

Robert

 

[Wei Lu [MSFT]]

Hello Robert,

The ExportAsFixedFormat method did not provide such argument to print to
PDF.

I will consulting internal team for any workaround. Thank you!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[NickHK]

Isn't that exactly what it is for ?

According to:
http://msdn2.microsoft.com/en-us/library/bb238907.aspx

The ExportAsFixedFormat method is used to publish a workbook to either the
PDF or XPS format.
Version Information
Version Added: Excel 2007

NickHK

 

[Robert Simpson]

Thanks a bunch!

 

[Wei Lu [MSFT]]

Hello Robert,

I would like to get the screenshot of your issue. The page setting should
effect the size for the ExportAsFixedFormat. Please send me the screenshot
to understand this issue more clearly.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Wei Lu [MSFT]]

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Robert Simpson]

Sorry I didn't get back to you sooner. I'll send you everything you need!

 

[Robert Simpson]

I've sent you e-mail, here it is without the attachment in case anyone else
ends up searching for this issue:

Attached is a ZIP file containing a sample spreadsheet, and the output from
"Save As PDF", compared to the output of printing the same doc to the Adobe
printer driver.

At 25% zoom, when exported as PDF through SaveAs/FixedFormat, the resulting
PDF file's page size is 34 x 44 (4 times the normal size)
At 10% zoom, the page size is 85 x 110 (10 times the normal size)

When printed to the Adobe PDF printer driver in any zoom level, the page
size is 8.5 x 11 -- as it should be.

Aside from the "wrongness" of the paper size:

- These monster-page PDF's cannot be converted to an image. A 10% zoomed
Excel page at 300dpi is a whopping 25,500 x 33,000 pixels and consumes 3.3gb
of RAM as a full color BitmapSource!

- I can't tell what zoom level a worksheet will be printed at when printing
an Excel programmatically. With the "Fit to x pages" mode is set, the Zoom
factor is not available to me programmatically ... so there's no way for me
to internally adjust my code to compensate for the ballooned images.

- Even if I could tell what the zoom level was for each worksheet, there's
no way for me to know after the docs are printed just where one worksheet
ended and the next worksheet began in a multi-worksheet PDF file -- so hence
no way to dynamically adjust per-page range the scaling factor when
generating an image for a page.


BTW: I have another problem with ExportAsFixedFormat in Word 2007 if you're
interested. I have 2 docx files that generate "The export failed due to an
unexpected error" when I try to save the docs as PDF or XPS. They print to
the Adobe PDF driver just fine, however.

Oh -- and I work in the Electronic Discovery industry ... we TIFF/PDF
thousands of Office documents from hundreds of different sources weekly, so
we regularly encounter the full broad spectrum of just about every
conceivable arrangement of Office document imaginable.

Robert

 

[Robert Simpson]

If you'd be so kind as to drop me your e-mail address, I'll send the samples
over to you. The addr's I tried all bounced

robert at blackcastlesoft dot com

 

[m.bagattini]

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Hello Wei Lu,
I'm having a similar problem, related to ExportAsFixedFormat: I have
an Excel file, where I set a print area. Exporting to PDF from within
Excel correctly prints out the selected area. Saving the file and
programmatically ExportAsFixedFormat to a PDF seems to ignore my print
area, even if I put the false flag on IgnorePrintAreas parameter. Is
this known? Maybe I have also to set print area programmatically?

Thanks in advance.

Matteo

 

[Wei Lu [MSFT]]

Hello Matteo,

Robert just email me that he resolved this issue by reinstall the system.

It seems this issue related with some machine configuration.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[m.bagattini]

The tipical MSFT workaround..

Thanks, anyway!

mt