R1C1 Reference Style issue

Posted by: tonytrey on 7 March 2018, 2:13 pm EST

  • 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.

  • Posted 8 March 2018, 1:59 am EST

    Hello,

    With latest version of SpreadJS ‘activeSheet’ object sheet doesn’t hav referenceStyle option. only spread has referenceStyle option.

    so we shuould set like this:

    spread.options.referenceStyle = GC.Spread.Sheets.ReferenceStyle.r1c1;

    Please refer to the attached sample.

    Thanks,

    Deepak SharmaFormula_ReferenceStyle_JS.html.zip

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels