News for hackers. Stuff that matters.

A comment on Excel formulas in JavaScript . Parent comment

Re:Excel formulas in JavaScript by clxl on Thursday April 24, 2014 @10:42AM (#7640547)
Excel only supports numbers that fit in an IEEE754 double, just like JavaScript.

There is some fancy logic to format numbers, however (including some mess for date codes). http://oss.sheetjs.com/ssf/ is a pretty decent implementation in JavaScript.

[ Parent | on HN ]
Re:Excel formulas in JavaScript by brudgers on Thursday April 24, 2014 @12:06PM (#7641126)
All versions of Excel have native support for integers.

http://msdn.microsoft.com/en-us/library/office/bb687869%28v=...

[ Parent | on HN ]
Re:Excel formulas in JavaScript by clxl on Thursday April 24, 2014 @12:15PM (#7641194)
Excel supports 32 bit integers, which fit comfortably in IEEE754 doubles (there are 64 bit integers which cannot be exactly represented)
[ Parent | on HN ]