I have sent you the test files. It is a problem with Date() function in Aspose. For example Date(2001, 10, 1) should be 10/1/2001, but Aspose gives us 1/1/2001.
Thanks for the quick response. While this build fixed the date() problem, it appears to be a bad build, since the vlookup is completed messed up. The problem is with both jdk 1.4 and 1.5 versions. I attached the test files.
Sheet2.C4 should be 100000. Aspose.Cell gives us 200000.
The previouse build 4.0.3.0 does not have this problem.
That fixed it. Thanks for the attention. Will all these fixes go to an official release soon? Can we get notified? We are evaluating a few packages including Aspose.Cell and will make a recommandation soon.