farpoint chart formula for trend line

Posted by: kaveri on 8 September 2017, 3:22 pm EST

  • Posted 8 September 2017, 3:22 pm EST

    in parpoing chart control added dynamically, INDEX(LINSET() NOT EVALUTATE in farpoint grid but in export excel its coming

  • Marked as Answer

    Replied 8 September 2017, 3:22 pm EST

    Hello,

    As per my understanding you are talking about Linest() and Index() functions. If yes, then it is working fine in Spread.

    http://sphelp.grapecity.com/WebHelp/SpreadNet9/FR/webframe.html#FunctionLINEST.html
    http://sphelp.grapecity.com/WebHelp/SpreadNet9/FR/webframe.html#FunctionINDEX.html

    Please have a look at attached XML file created with Spread for winforms wherein Linest and index functions are working fine even together. Try opening this XML in Spread Designer and see both the formulas are working fine. I am not sure how are you relating it to charts.

    Hence, please elaborate more on your issue along with some stripped out sample replicating the issue so that we can investigate this issue further.

    Thanks,
    Reeva
    2016/03/Functions.zip
Need extra support?

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

Learn More

Forum Channels