Tom Groves

Results 9 comments of Tom Groves

@SheetJSDev i've pushed a new commit that reverts to the native Math.round if the result is `NaN`; doesn't feel very elegant, but it seems to work. Did you have any...

I've submitted a PR with a potential fix - it'd be good to get your feedback @SheetJSDev

@SheetJSDev did you get a chance to look through that PR? It'd be great to hear your views 😄

@SheetJSDev it's all going a bit over my head :-D Looking at those sheets and the `ssf` library i'm not sure there's anything we can do to resolve this :-(...

Looks like this describes the issue well: https://gordonlesti.com/inaccurate-rounding-with-decimal-digits/ That solution is tailored for 2 DPs so I'm going to look at expanding on it tomorrow.

@SheetJSDev can you take a look at https://github.com/SheetJS/ssf/pull/34 please? I believe this may have fixed the issue

Just ran into this; thanks for logging it @jivimberg Simple resolution mentioned above worked.

After a bit of digging this appears to be working as expected in 7.12.2 and breaks with the changes to `getValues` in 7.13.0. Just wanted to say thanks for the...