Formula won't calculate before "Enable Editing"

Question

There's one cell which has a formula and after generating the document, the value won't be calculated unless I click on "Enable Editing".

score 1 · Accepted Answer · answered Jul 01 '18 at 19:30

1

You need to call worksheet.Calculate() before you save the document.

answered Jul 01 '18 at 19:30

Good to hear ... Been caught out by that myself!! https://stackoverflow.com/questions/49675963/why-wont-this-formula-calculate-unless-i-double-click-a-cell – 3-14159265358979323846264 Jul 01 '18 at 19:34

1 Answers1