Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Excel 2003 SP3 running on XP Pro SP2

    One worksheet displays cell contents that displays with what appear to be random white lines, almost like cracks in the font. Copying and pasting special with values only into the same workstation does not clear issue.

    Copying cell contents into a new blank worksheet brings the corruption but copying and pasting special, just values is OK with the pasted material picking up the defaults of the new, blank spreadsheet.

    I have attached a screen shot which hopefully provides details.

    I am curious if Excel has something similar to Word's normal.dot file which may have enabled corruption to enter this file.

    Thanks.

    Jester

    [attachment=84133:PNC_Exce...e_sample.jpg]
    Attached Images Attached Images
    I know enough to know I don't know enough

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    From the picture it looks like you have a white diagonal border in the formatting. Check the Format cells - border (tab)...

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I agree with Steve. See the screenshot for the effect of a white diagonal border.
    Attached Images Attached Images
    • File Type: png x.png (6.7 KB, 0 views)

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cleveland, Ohio, USA
    Posts
    388
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='778531' date='05-Jun-2009 16:44']I agree with Steve. See the screenshot for the effect of a white diagonal border.[/quote]

    Thanks guys!

    Steve and Hans nailed it. We did not think in terms of a straight line as the line looked etched as it went through the letters but once again, the collected wisdom rises to the top.

    Jester
    I know enough to know I don't know enough

Posting Permissions

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