Computing.Net > Forums > Office Software > faulty prinout of excel spreadsheet

faulty prinout of excel spreadsheet

Reply to Message Icon

Original Message
Name: Sebastian42
Date: July 26, 2007 at 03:06:32 Pacific
Subject: faulty prinout of excel spreadsheet
OS: WinXP
CPU/Ram: PIII/256Mb
Model/Manufacturer: generic
Comment:

One sheet of an excel workbook that prints quite well from Excel97 through an Epson Stylus Color II printer, has the cell contents misaligned to the grid, when printed from Excel2K through a HP Laserjet.
Another spreadsheet in that workbook prints equally well from both systems.
In another attempt from a freshly started spreadsheet, NO grids printed at all !
What can I tweak to fix this ?

Basty


Report Offensive Message For Removal


Response Number 1
Name: DerbyDad03
Date: July 26, 2007 at 05:50:05 Pacific
Subject: faulty prinout of excel spreadsheet
Reply: (edit)

First, let's make sure we are talking about gridlines and not borders. Those are 2 very different things. I'll assume we are talking about gridlines and take a shot at this.

re: In another attempt from a freshly started spreadsheet, NO grids printed at all!

You don't say which combination presented this problem. (97/Epson or 2K/HP) In any case, I believe the option to print gridlines in Print Set-up...Sheet is un-selected by default, so it must be selected in each "freshly started spreadsheet". Did you select that option?

As far as the original not printing gridlines with 2K/HP, and again assuming we are talking about gridlines not borders, try this in 2K/HP first:

1 - Unselect the print gridlines option in Page Setup...Sheet.
2 - Print the sheet
3 - Turn the option back on.
4 - Print the sheet

If that doesn't help try this:
1 - Turn the option off in 97/Epson
2 - Save the file
3 - Open the file in 2K/HP
4 - Turn the option on
5 - Print

What I'm trying to do in both cases is to attempt to clear any remnants of the Epson print driver from the file that may be hanging around when you open it under 2K. I don't know if any of this will help, but it's worth a shot.


Report Offensive Follow Up For Removal

Response Number 2
Name: Sebastian42
Date: July 26, 2007 at 21:49:44 Pacific
Subject: faulty prinout of excel spreadsheet
Reply: (edit)

Sorry for the spelling mistake... careless !

I've done a lot of experimenting since, so can now cast the problem in a different light.

The SS which printed corectly was Landscape
format. If for the sake of experimenting, I print it as Portrait, THAT SS also becomes misaligned.

The problem occurs in XL2K/HPLaser combination.

XL97/Epson is fine for both Landscape and Portrait.

The SS about which I complained is (and has to be) Portrait.

Basty


Report Offensive Follow Up For Removal

Response Number 3
Name: DerbyDad03
Date: July 27, 2007 at 08:05:12 Pacific
Subject: faulty prinout of excel spreadsheet
Reply: (edit)

It's hard to tell from this distance what's happening. I'd ask you to send me the spreadsheet, but I'm going off-line (into the woods) for the next 3 days.

One last thing to try - look at both the horizontal and vertical algnment of the cells. Format..Cells...Alignment. Perhaps you can fix it that way.


Report Offensive Follow Up For Removal

Response Number 4
Name: Sebastian42
Date: July 29, 2007 at 05:48:54 Pacific
Subject: faulty prinout of excel spreadsheet
Reply: (edit)

"One last thing to try - look at both the horizontal and vertical algnment of the cells. Format..Cells...Alignment. Perhaps you can fix it that way." Nothing useful presented itself. Thanks anyway.


Basty


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: faulty prinout of excel spreadsheet

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software




How often do you use Computing.Net?

Every Day
Once a Week
Once a Month
This Is My First Time!


View Results

Poll Finishes In 3 Days.
Discuss in The Lounge