formula for =Image() not working properly

[nielsrobin]

When using the image formula on a cell. e.g.:
=IMAGE("https://placekitten.com/200/300")
=@image("https://placekitten.com/200/300","Kitten",0)

The image is not displayed in the cell after writing the excel to a file.

Instead the error "#NAME?" is displayed in the cell. However if you select the cell you see the full formula and if you hit enter to refresh the cell the image appears.

To reproduce:

var wb = new xl.Workbook()
var ws = wb.addWorksheet('Sheet 1')
ws.cell(1, 1).formula('=IMAGE("https://placekitten.com/200/300")')
wb.write('./file.xlsx', function(err, stats) {})

My expectation would be that the image is displayed in the cell without having to refresh the cell.

OS: Windows
Node: v16.13.2
excel4node Version: 1.8.2
Application: Microsoft Excel

[David-Owen-Walker]

I am having a similar issue with LAMBDA. As far as I can tell, this has to do with functions that were only recently added to excel. Did you find a solution?