Can a printer driver or video card effect the way excel displays and
prints out spreadsheets?

I have tested the same spreadsheet on different computers with
different printers. The spreadsheet prints out differently on some of
the computers.

Thank you for any help

Yep.

Take page breaks for instance. With different printers (and different physical
margins), the pagebreaks may not be in the same location.



mianiro wrote:

Can a printer driver or video card effect the way excel displays and
prints out spreadsheets?

I have tested the same spreadsheet on different computers with
different printers. The spreadsheet prints out differently on some of
the computers.

Thank you for any help

--

Dave Peterson

Thank you

Can you suggest anyway to get around this? Does each spreadsheet have
to be configured for each setting/driver? I want this spreadsheet to
come out the same for all clients. Would a PDF be a better way to go?


Dave Peterson wrote:
Yep.

Take page breaks for instance. With different printers (and different physical
margins), the pagebreaks may not be in the same location.



mianiro wrote:

Can a printer driver or video card effect the way excel displays and
prints out spreadsheets?

I have tested the same spreadsheet on different computers with
different printers. The spreadsheet prints out differently on some of
the computers.

Thank you for any help

--

Dave Peterson

As printer have some area around the edge that they are unable to print
(although modern printers have smaller, or possibly negligible, non-print
margins), Excel can only print on the remaining printable area. Depending on
the worksheet settings, changing printers may alter the number of resulting
pages and possibly the range of papersizes available.

I would imagine a PDF printer is not constrained by this, although you
obviously can't get a hard copy from it.

Maybe you can play with the Worksheet.PageSetUp.FitToPageTall etc settings.

The video driver may effect the outcome also, although if you have the
correct, updated driver, this should not be a problem.

NickHK

"mianiro" wrote in message
oups.com...
Can a printer driver or video card effect the way excel displays and
prints out spreadsheets?

I have tested the same spreadsheet on different computers with
different printers. The spreadsheet prints out differently on some of
the computers.

Thank you for any help

When I have shared workbooks with others that needed to be printed--and since I
never knew what kinds of printers would be used, I always made my margins more
than I needed.

I always tried to be conservative with pagebreaks. I'd put manual page breaks
in before my printer would need them.

I'd widen columns just a bit. This was useful with dates, too--some formats are
picked up from the user's regional settings and they could be different for me.

As a recipient of documents that needed to be adjusted (not all senders are as
conscientious as you!), I'd much rather spend a little time formatting for my
printer that get a PDF file. But that will depend on how comfortable the
recipients are with excel.

PDF files are pretty, but I just can't do as much with them.

(And then I learned to accept that somethings are beyond my control!)

mianiro wrote:

Thank you

Can you suggest anyway to get around this? Does each spreadsheet have
to be configured for each setting/driver? I want this spreadsheet to
come out the same for all clients. Would a PDF be a better way to go?

Dave Peterson wrote:
Yep.

Take page breaks for instance. With different printers (and different physical
margins), the pagebreaks may not be in the same location.



mianiro wrote:

Can a printer driver or video card effect the way excel displays and
prints out spreadsheets?

I have tested the same spreadsheet on different computers with
different printers. The spreadsheet prints out differently on some of
the computers.

Thank you for any help

--

Dave Peterson

--

Dave Peterson

Thanks for all of your suggestions.
Right now I am looking at going the PDF route if possible. The
information I am printing out does not need to be changed nor use any
of the excel functionalities. Therefore, going with a PDF is
plausible. I have looked at some of the opensource pdf generators....
itextsharp etc... However none of these seem to give total control over
placement of text. I need to place text in specific areas/coordinates.



Does anyone have experience with a pdf generator that allows this?


NickHK wrote:
As printer have some area around the edge that they are unable to print
(although modern printers have smaller, or possibly negligible, non-print
margins), Excel can only print on the remaining printable area. Depending on
the worksheet settings, changing printers may alter the number of resulting
pages and possibly the range of papersizes available.

I would imagine a PDF printer is not constrained by this, although you
obviously can't get a hard copy from it.

Maybe you can play with the Worksheet.PageSetUp.FitToPageTall etc settings.

The video driver may effect the outcome also, although if you have the
correct, updated driver, this should not be a problem.

NickHK

"mianiro" wrote in message
oups.com...
Can a printer driver or video card effect the way excel displays and
prints out spreadsheets?

I have tested the same spreadsheet on different computers with
different printers. The spreadsheet prints out differently on some of
the computers.

Thank you for any help

I use PrimoPDF, but I've never seen anything that supported what you want.



mianiro wrote:

Thanks for all of your suggestions.
Right now I am looking at going the PDF route if possible. The
information I am printing out does not need to be changed nor use any
of the excel functionalities. Therefore, going with a PDF is
plausible. I have looked at some of the opensource pdf generators....
itextsharp etc... However none of these seem to give total control over
placement of text. I need to place text in specific areas/coordinates.

Does anyone have experience with a pdf generator that allows this?

NickHK wrote:
As printer have some area around the edge that they are unable to print
(although modern printers have smaller, or possibly negligible, non-print
margins), Excel can only print on the remaining printable area. Depending on
the worksheet settings, changing printers may alter the number of resulting
pages and possibly the range of papersizes available.

I would imagine a PDF printer is not constrained by this, although you
obviously can't get a hard copy from it.

Maybe you can play with the Worksheet.PageSetUp.FitToPageTall etc settings.

The video driver may effect the outcome also, although if you have the
correct, updated driver, this should not be a problem.

NickHK

"mianiro" wrote in message
oups.com...
Can a printer driver or video card effect the way excel displays and
prints out spreadsheets?

I have tested the same spreadsheet on different computers with
different printers. The spreadsheet prints out differently on some of
the computers.

Thank you for any help


--

Dave Peterson