Data Compare Does not compare rows properly

[Hitesh]

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

[Aaron]

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]

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.