Announcement

Collapse
No announcement yet.

Data Compare Does not compare rows properly

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Data Compare Does not compare rows properly

    Hi,
    I am trying to compare 2 Excel worksheets in 2 different Excel Files.
    And i haev come across a unique situation where due to some reason Beyond Compare is unable to identify that 2 rows in the 2 files are same and it highlights them as RED, even inspite of teh fact that the 2 rows are matching. I have specified the 2 rows below. They are exactly similar. I have also tried to do an Excel Conditional Formating to confirm if there was any spaces or something between teh 2 rows of teh 2 files but that is not the case.

    2991669 AEGS.L 965756 GB0009657569 AEGIS GROUP PLC 13127 3/15/2010 3/30/2010 GBP -3.31314 143750 0.84125 0.54125 30 INT 112276 RFS GESTION AC RFS ACTIVE STRATEGIE

    2991669 AEGS.L 965756 GB0009657569 AEGIS GROUP PLC 13127 3/15/2010 3/30/2010 GBP -3.31314 143750 0.84125 0.54125 30 INT 112276 RFS GESTION AC RFS ACTIVE STRATEGIE


    Does any one have any clue as to how could i make BC identify teh 2 rows as same and not flag them as RED?

    Appreciate your immediate response as i am stuck sicne a while!!!

    Thanks in advance

    Hitesh

  • #2
    Hello,

    I replied to your email regarding this issue. One of your lines actually contained the data -3.1.3.14000000002, which when set as a numeric column was treated as that value, but displayed as a rounded version. We're investigating this currently with your example files (thanks for emailing them!).
    Aaron P Scooter Software

    Comment


    • #3
      Hello,

      The email message I sent seems to be bouncing with an invalid user error. Do you have an alternate email we could send to? Please email [email protected] and include a link back to this forum post.
      Aaron P Scooter Software

      Comment

      Working...
      X