Posted 7 March 2018, 2:13 pm EST
Why do these two statements not give me the same result?
activeSheet.setFormula(14,6,“SUM(E7:E8)”);
activeSheet.setFormula(14,7,“SUM(R7C5:R8C5)”);
The first line gives me a proper sum, but the second line, which should sum the same numbers and place it in the next cell, gives me a #NAME? error.
I even tried this to no avail: activeSheet.options.referenceStyle = GC.Spread.Sheets.ReferenceStyle.r1c1;
What am I missing? Thanks.