Posted 8 September 2017, 3:22 pm ESTin parpoing chart control added dynamically, INDEX(LINSET() NOT EVALUTATE in farpoint grid but in export excel its coming
farpoint chart formula for trend line
Posted by: kaveri on 8 September 2017, 3:22 pm EST
Marked as Answer
Replied 8 September 2017, 3:22 pm ESTHello,
As per my understanding you are talking about Linest() and Index() functions. If yes, then it is working fine in Spread.
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.