Format 0.0# not displaying second decimal digit #677

New Issue

2017-06-08T09:31:25Z

kuhu19 commented

2017-06-08 09:31:25 +00:00

(Migrated from github.com)

When trying to read decimal numbers from excel, numbers are getting rounded off. E.g. 15.06 comes as 15.1 in json.

SheetJSDev commented

2017-06-08 13:15:16 +00:00

(Migrated from github.com)

@kuhu19 The only time the library should be rounding a cell is if the cell format forces a round. For example, if the cell is formatted as Number with 1 decimal place, Excel will draw 15.1 on the worksheet but show 15.06 in the formula bar.

If you want to see the underlying raw value, you can pass the option raw:false

If you have a file where Excel is showing the value 15.06 but the library is showing 15.1, please share the file (you can email dev@sheetjs.com) and we will take a look

@kuhu19 The only time the library should be rounding a cell is if the cell format forces a round. For example, if the cell is formatted as Number with 1 decimal place, Excel will draw `15.1` on the worksheet but show `15.06` in the formula bar. If you want to see the underlying raw value, you can pass the option [`raw:false`](https://github.com/sheetjs/js-xlsx#json) If you have a file where Excel is showing the value `15.06` but the library is showing `15.1`, please share the file (you can email dev@sheetjs.com) and we will take a look

kuhu19 commented

2017-06-08 18:28:41 +00:00

(Migrated from github.com)

To add more info here, rounding is always upto 1 decimal place.

Sign in to join this conversation.