1. Feedback
  2. ASP.NET Core
  3. 15297

Welcome to the ASP.NET Core feedback portal. We’re happy you’re here! If you have feedback on how to improve the ASP.NET Core, 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

XlsIO cell with DATE formula has incorrect DisplayText

We use XlsIO to load Excel files clients upload to our web application. We have come across an issue where the Excel was created with a column that contains dates set as formulas like "=DATE(2019,12,1)". We are able to read the client's file correctly, however, I'm trying to create the same thing manually so we can add a unit test to be sure we don't break support for this. I can't figure out how to get it to work since whenever I set the Formula using XlsIO, the incorrect DisplayText is shown so my unit test fails. Here is a simple example:

using var excel = new ExcelEngine();
var workbook = excel.Excel.Workbooks.Create();
var worksheet = workbook.Worksheets.First();
worksheet[1, 1].Formula = "=DATE(2019,12,1)";
worksheet[1, 1].DisplayText.ShouldBe("12/1/2019");
//ERROR DisplayText is "12/31/1899" instead