-
Bug
-
Resolution: Fixed
-
Major
-
5.12.2
-
None
-
Security Level: Jimmy
-
None
Steps to Reproduce
1. import keikai-663.xlsx
2. check B2
Current Result
keikai: 91.57
Excel: 91.58
Expected Result
both have the same value
Another Steps to reproduce
- import [^keikai-663-2.xlsx]
- compare numbers between Excel and keikai
Current result
they are different
Expected Result
they are equivalent
Debug Information
- don't round during TwoOperandNumericOperation e.g. add, substrate, multiply, divide. Only round it when passing a double into an Excel function. This result matches Excel's one.
Workaround
I have verified the workaround with KEIKAI-609, KEIKAI-342
- relates to
-
KEIKAI-609 Keikai formats a number differently from Excel
- Closed