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.
- Attachments
-
SpireXLSTester.zip- (59.31 KiB) Downloaded 27 times
-
cal004b2 - Posts: 1
- Joined: Thu Oct 24, 2024 6:42 pm
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
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 - Posts: 283
- Joined: Mon Jul 15, 2024 5:40 am
Page 1 of 1