Category Archives: Excel

Excel JavaScript API Part 5: The large numbers bug

Posted on April 5, 2017 by

There is currently (JavaScript Excel API set 1.4) a rather nasty bug when writing large integer numbers (anything larger than int32) back to a range. The JS can correctly read these large numbers – it just silently gets the wrong … Continue reading →

Posted in Excel, JS-API | Tagged , | Leave a comment

Excel JavaScript API Part 4: The shallow copy problem

Posted on April 5, 2017 by

I was trying to read the values from a Range and then write modified versions of the values to two different ranges. Should be straightforward: Well this does not work: both B4 and B6 have 0.91 added to them: wrong … Continue reading →

Posted in arrays, Excel, JS-API | Tagged , | 1 Comment