incorrect output with '#,##0.00' format #2953

New Issue

jinjin9527 · 2023-05-22T23:57:38Z

jinjin9527 commented

2023-05-22 23:57:38 +00:00

SSF.format( "#,##0.00", 3.105 ) gives a result of '3.10' - it should be '3.11'.
It seems there is a bug in dec function.
Current version:
・get decimal part:
3.105 -> 0.104999998
・power the decimal part
Math.pow(0.1049998, 2) -> 10.49998
・round off powered decimal part
Math.floor(10.49998) -> 10

Shloud The logic be as below.
Math.pow(3.105,2) -> 310.5 -> Math.floor(310.5) -> 311 -> 311/100 -> 3.11

SSF.format( "#,##0.00", 3.105 ) gives a result of '3.10' - it should be '3.11'. It seems there is a bug in dec function. **Current version:** ・get decimal part: 3.105 -> 0.104999998 ・power the decimal part Math.pow(0.1049998, 2) -> 10.49998 ・round off powered decimal part Math.floor(10.49998) -> 10 **Shloud The logic be as below.** Math.pow(3.105,2) -> 310.5 -> Math.floor(310.5) -> 311 -> 311/100 -> 3.11

sheetjs commented

2023-05-24 07:01:40 +00:00

Thanks for reporting! There are a number of these cases that we need to investigate further.

Sign in to join this conversation.