When an Excel file with 'Set precision as displayed' option enabled is imported in the Spreadsheet the calculations are not the same as in the Excel file.
1. Open the Spreadsheet demo
2. Import the excel file from the zip. in the Excel file the following option is enabled - File->Options->Advanced->When Calculating this workbook-> Set precision as displayed
The value in Excel in C1 column is 399.96, while the value displayed in the Spreadsheet is 400.00
I would like to have support in Spreadsheet for Excel files with 'Set precision as displayed' option enabled.