Last Updated: 19 Aug 2021 07:52 by ADMIN
Created on: 19 Aug 2021 07:52
Category: Spreadsheet
Type: Feature Request
Calculations are not same as Excel file when 'Set precision as displayed' is enabled in Excel

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.

Attached Files: