Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Missing gridlines

    I have had this problem with two cash flow spreadsheets, each 14 columns wide. When I print them, with gridlines checked, the left hand 20% or so of the sheet prints without gridlines, they just stop in the middle of a column. Can anyone help?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Missing gridlines

    Are the gridlines visible on screen ?. If you apply a background colour, even white - or whatever the default is, then the gridlines do not appear.

    You could always resort to borders around the cells.

    Andrew C

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing gridlines

    Do you literally mean 'in the middle of a column'? - i.e. a cell is partially 'gridded'?
    Do you have any graphics on the sheet?
    Are any of the cells merged?
    Does data in a cell 'over-run' the width of the cell (which will prevent the vertical gridline being printed)?

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing gridlines

    I had a similar problem several years ago, and it turned out to be a problem in the display driver (Matrox). Yes, I did say the display driver. A new version fixed the problem. You might check to see if there are any upgrades for your display or print drivers.
    Legare Coleman

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing gridlines

    Andrew:
    The lines are visible on screen, and in print preview.
    I tried borders round the cells, it didn't solve the problem.
    Lief:
    Yes, cells 1-11 are gridded normally. Cell 12 which is about 25mm wide has lighter gridlines for 10mm from the left side, then blank. The heavier lins around subtotals make it as far as cell 14 then do the same thing. The vertical gridlines are normal.
    There are no graphics on the sheet.
    The top cell is merged, full width of the spreadsheet.
    No the cells are not overfilled with data.
    Legare I will try it out on another computer and printer.

    Thanks everyone for your replies.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing gridlines

    Tried it on another printer (Xerox 470ST) and it printed fine. So it looks like a printer problem, which surprises me as the problem occurred with an HP LaserJet 5Si which normally is trouble free, and the spreadsheet is not very big.

  7. #7
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Missing gridlines

    I've mentioned this trick before, but think it worth repeating.
    We have a mix of LJ4, 5 and 6 printers here. With their 'normal' drivers installed, each gives a different result - e.g. an spreadsheet will fit on one page on the LJ4, but spill over 2 or 3 rows on the LJ5.
    Experimentation showed the LJ4 to be the most accurate - i.e. a 4cm square rectangle is truly printed out 4cm square.
    To get round this anomaly, the LJ5 and 6's are re-installed as LJ4's and work perfectly.
    Might be worth a try.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •