This project has moved. For the latest updates, please go here.

Referring a formula in another worksheet

Mar 28, 2014 at 2:45 PM
Edited Mar 28, 2014 at 2:47 PM
In C#, I am using

cell.SetFormulaA1("SUM('sheet1'!C8:'sheet1'!J8) + SUM('sheet2'!C9:'sheet2'!J9)");

to set a formula that uses other worksheets.

But then when I do this:

string content;
if (!cell.TryGetValue(out content)
{
...
}

it throws an exception.

What am I doing wrong?