VLOOKUP by datetime is inconsistent

[cal004b2]

Hello,

We're trying to switch from Excel interop to Spire.XLS and we're running into a problem with VLOOKUP when the lookup value is a datetime. See attached for my sample project. It is a .NET Framework 4.8 project and it contains an input workbook. The project is a simple form with two buttons. The first button updates a range of cells in the input workbook with datetime values using Spire.XLS and saves it as a new workbook. The second button does the same thing with interop instead of Spire.XLS. The resulting interop-generated workbook has all of the VLOOKUP formulas successfully finding a match in the range that was updated. The resulting Spire-generated workbook only has every third VLOOKUP successfully finding a match.

How can we adjust our code to make Spire.XLS save the datetime values in the same way that interop does? Thank you in advance for any help you can provide.

[Amin.Gan]

Hello,

Thanks for your inquiry. I reproduced the problem using the project you provided. This issue has been logged in our bug tracking system under the number SPIREXLS-5545. Our Dev team will investigate it further, once there is any update, we will let you know.

Sincerely,
Amin
E-iceblue support team

[Amin.Gan]

Hello，

Thank you for your patience.
Glad to inform that we just released Spire.Xls.14.11.3 hotfix which fixes the bug of SPIREXLS-5545, welcome to download it from the following link and test it.
Our website link: https://www.e-iceblue.com/Download/down ... t-now.html
NuGet link: https://www.nuget.org/packages/Spire.XLS/14.11.3

Sincerely,
Amin
E-iceblue support team

[cal004b2]

Thank you very much Amin!

[Amin.Gan]

Hello,

Thanks for your reply. Looking forward to your test results. If you have any other questions, please feel free to write to me.

Sincerely,
Amin
E-iceblue support team