We're sorry GroupDocs doesn't work properply without JavaScript enabled.

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.

@Atir_Tahir, could you provide any updates for this issue. Thanks.

@PraveenaNunna

This issue is still under investigation and expected to be fixed in API version 21.7. However, we’ll notify you as there’s any further progress.

@awarhade2

Please have a look at this file.zip (13.3 KB). Let us know if this result is appropriate for you.

@Atir_Tahir your shared file showing difference properly but i tried comparision on same set of file but it didn’t work

Groupdocs version:21.7
License type: Temp

GroupDocs.Comparison.License lic = new License();
lic.SetLicense(@“D:\GroupDocs.Comparison.NET.lic”);
using (Comparer comparer = new Comparer(@“D:\ExcelToshare\Export 28_04_2021 18_57.xlsx”))
{
CompareOptions options = new CompareOptions();
options.SensitivityOfComparison = 100;
options.DetalisationLevel = DetalisationLevel.High;
comparer.Add(@“D:\ExcelToshare\Export 28_04_2021 18_57_unmerged.xlsx”);
comparer.Compare(@“D:\ExcelToshare\Export_IssueFixed1.xlsx”, options);
//ChangeInfo[] changes = comparer.GetChanges();
//Console.WriteLine(changes.Length);
//Console.ReadLine();
}

@awarhade2

This fix will be available in next API release. As the release gets on-board, we’ll notify you.

Hi @Atir_Tahir, could you please update if the API version with the above fix is released? If not, could you give any tentative date of when it would be released.

Thank you.

@PraveenaNunna

This issue is expected to be fixed in API version 21.9. We’ll share release ETA with you ASAP.