Values in sheets are not updated `#VALUE!` is shown instead

[tiholic]

let template = new XLSXTemplate(_templateFileBuffer);  //_templateFileBuffer obtained from reading a .xlsx file
template.sheets.forEach((sheet) => template.substitute(sheet.name, context));
let buffer = template.generate({type : 'nodebuffer'});
//then buffer is saved to a file

The output file is expected to have updated values for cells with formulae, instead it shows #VALUE!