Exceljs: formula: round

Created on 24 May 2016  路  3Comments  路  Source: exceljs/exceljs

I found out that if I make cell {formula: "SUM(A1+A2)"} it works perfect, but with round function it gives ERR:508 on cell {formula: "ROUND(SUM(A1+A2); 2)"}.
It drove me nuts.

resolved
Source
picture dcrystalj

Most helpful comment

seems to work with comma separator
{formula: 'ROUND(SUM(B2+1.11111),2)'}

picture williamverdolini on 14 Sep 2017
🎉3

All 3 comments

Same here.. Not only ROUND. The problem is that every nested formula returns ERR:508. Any suggestions?

kadzik picture kadzik on 31 Jan 2017

Same here, any news on this?

xgvargas picture xgvargas on 20 Apr 2017

seems to work with comma separator
{formula: 'ROUND(SUM(B2+1.11111),2)'}

williamverdolini picture williamverdolini on 14 Sep 2017
🎉3
Was this page helpful?
0 / 5 - 0 ratings

Related issues

abmj1979 picture abmj1979  路  3Comments
lukelaws picture lukelaws  路  3Comments
thearabbit picture thearabbit  路  3Comments
miniil picture miniil  路  4Comments
dm-ibtissam picture dm-ibtissam  路  4Comments