search

dotnetcore / NPOI

A .NET library for reading and writing Microsoft Office binary and OOXML file formats.
Apache License 2.0
1.93k stars 413 forks source link

@2.5.1 misbehavior of Comparision.Operator at DVConstraint.CreateDateConstraint for LibreOffice Calc v7.0.0.3(x64) #180

Open llorch19 opened 4 years ago

llorch19 commented 4 years ago

While using NPOI@2.5.1 for HSSFWorkbook gen, found DVConstraint.CreateDateConstraint for datetime cols behaves like below,

0 - Between 1 - NotBetween 2 - Equal 3 - NotEqual 4 - LargerThan 5 - LesserThan 6 - LargerThenOrEqual 7 - LesserThanOrEqual

Best Regards & Thanks

tonyqus commented 4 years ago

I'm afread you post the issue in the wrong repo. This is not official NPOI repo.

llorch19 commented 4 years ago

I'm afread you post the issue in the wrong repo. This is not official NPOI repo.

Thanks replying. The issue appears in a .Net Core project when following README.md.