I get a worong result with CaculateFormulaValue() method with some values.
- Code: Select all
var workbook = new Workbook();
var formule = "50000.10 < 50000";
var result = (bool)workbook.CaculateFormulaValue(formule); // result = false : OK
formule = "49999.10 < 50000";
result = (bool)workbook.CaculateFormulaValue(formule); // result = true : OK
formule = "1404129.7076516 < 50000";
result = (bool)workbook.CaculateFormulaValue(formule); // result = true : Fail
Do you reproduce the issue ?
Thanks