Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2012
    Posts
    1

    Question Excel Compare Issues

    I need to compare a lot of excel files. The program finds every difference so far, whats nice. Now i would like to set some filters or something like that to ignore some of the differences.

    #1 When somebody deleted an empty line in an excel file, the tool shows it as difference even though the files are identical when i watch them in excel.

    #2 Is it possible to compare excel 2003 files with excel 2010 files? The files are identical when i watch them in excel, but due to the different versions the tool finds many differences.

    Thanks in advance for your help.

  2. #2
    Join Date
    Oct 2007
    Location
    Madison, WI
    Posts
    11,788

    Default

    Thanks for the feedback. Let's see if I can answer these for you:

    1) We can ignore and hide Columns, but any additional or deleted rows will always be treated as a difference. If there is a new row or missing row, you can hide it from view using the Display Filters, but there is not a way to mark the files in their entirety as equal.

    2) Yes, you can compare 2003 to 2010. As long as their conversion to plain text is equal, the files should still show up as equal. What differences are you seeing? Would you be able to post or email us a pair of example files and a screenshot of the comparison? If you email us at support@scootersoftware.com, please include a link to this forum post for our reference.
    Aaron P Scooter Software

Tags for this Thread

Posting Permissions

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