1. Feedback
  2. WPF
  3. 27297

Welcome to the WPF feedback portal. We’re happy you’re here! If you have feedback on how to improve the WPF, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

1
Vote

ADDRESS formula is not evaluated correctly

When an ADDRESS formula contains the optional argument for a sheet name, the result is not the expected value.

Excel evaluates ADDRESS(3,4,,,"Sheet2") as Sheet2!$D$3. XlsIO returns #NAME?!$D$3.

Reproduced with this code and added example in a .NET Framework 4.5 Console App:


List results = new List();

using (ExcelEngine excelEngine = new ExcelEngine())

{

IApplication application = excelEngine.Excel;

application.DefaultVersion = ExcelVersion.Xlsx;


IWorkbook workbook = application.Workbooks.Open("Sample.xlsx");


IWorksheet worksheet = workbook.Worksheets.First();


worksheet.EnableSheetCalculations();

worksheet.Calculate();


foreach (var row in worksheet.Rows)

{

results.Add(new string[]

{

row.Cells[0].CalculatedValue,

row.Cells[1].CalculatedValue

});

}

}

foreach (var result in results)

{

if(!string.IsNullOrWhiteSpace(result[0]))

Console.WriteLine($"Expected: {result[1]} \t Result: {result[0]}");

}

Console.ReadLine();