Formula field do not refresh

[rsParticipant]

Hello

I have this excel [xlsx] file with formulas in them with a requirement is to use the excel as a rating engine – to be accessed from a html page. I ve tried setting the input fields, as shown in the snippet below [based on the screen case]

if (firstCell) {
var newFirstCell = new XElement(S.c,
firstCell.attribute(“r”),
new XElement(S.v, “1000”));
firstCell.replaceWith(newFirstCell);
}

However this does not seem to refresh the formulas on the worksheet. Been reading around and it seems this does not look possible, based on the comments I ve read so far.

Just wanted to check, if an automatic sheet refresh a possibility? If so how? If not any options available?

thx
rs

[Author]

Posts