Formulas using Reference sheet

Posted by: hunny on 8 September 2017, 12:46 pm EST

  • Posted 8 September 2017, 12:46 pm EST

    Hello . i have problem about formulas.. can anybody help me..


    i have 2 spread. One spread(First) consists of the data that i will compute and the other spread(Second) is for my computation. how will i make a formula getting the sum of each columns at my first spread ? i need to set the sum at my second spread. i tried using this but it does not work:


     


    formula_value =Sum( FSPREAD1_sheet!A1:A5)


    FSPREAD2.cells(0,1).formula = formula_value

  • Replied 8 September 2017, 12:46 pm EST

    Hello,


    Our Spread product does not support cross Spread control referencing in formulas. You would need to catch the CellChanged event of one Spread control and programatically evaluate your data to put into the second Spread control.

  • Replied 8 September 2017, 12:46 pm EST

    okie.. thanks for the confirmation..

Need extra support?

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

Learn More

Forum Channels