Free Support Forum - groupdocs.com

Excel files comparison not highlighting few cells which are having difference in .NET

Groupdocs version:21.4.0
License Type: Temporary and valid during test
While comparing below two request , some weird result with lot of blocks is showing up .
string source = @“D:\NewSetofExcel\Export 28_04_2021 19_05.xlsx”;
string target = @“D:\NewSetofExcel\Export 28_04_2021 18_57.xlsx”;

NewSetofExcel.zip (48.3 KB)

1 Like

@awarhade2

This issue is logged in our internal issue tracking system with ID COMPARISONNET-2695. You’ll be notified in case of any progress update.

@awarhade2,

Result could be improved by using properties

SensitivityOfComparison = 100; DetalisationLevel = DetalisationLevel.High;
But result could be not ideal because of lot of merged cells in document

Here is a result of using this property
screen-1.png (15.5 KB)

and here is code sample

GroupDocs.Comparison.License lic = new License();
lic.SetLicense(@"D:/GroupDocs.Comparison.lic");
using (Comparer comparer = new Comparer(@"D:/Export 28_04_2021 19_05.xlsx"))
{
      CompareOptions options = new CompareOptions();
      options.SensitivityOfComparison = 100;
      options.DetalisationLevel = DetalisationLevel.High;
      comparer.Add(@"D:/Export 28_04_2021 18_57.xlsx");
      comparer.Compare(@"D:/output.xlsx", options);
  }

Hi team,

Attaching set of excel ,there are few merged cell and in another file there is no merged ,still it was not able to locate difference. Can you please provide solution on itExcelToshare.zip (33.7 KB)

@awarhade2

We’ve logged this issue in our internal issue tracking system with ID COMPARISONNET-2717. It’ll be now further investigated and you’ll be notified about the progress update.

@Atir_Tahir any updates here

@awarhade2

We’re still investigating this issue.