Formula field do not refresh

Home › Forums › Open-Xml-Sdk-JavaScript › Formula field do not refresh

This topic contains 0 replies, has 1 voice, and was last updated by  rs 8 years, 2 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • October 17, 2016 at 9:40 am #3895

    rs
    Participant

    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
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.