Background Processing

2 posts, 0 answers
  1. steve
    steve avatar
    3 posts
    Member since:
    Jun 2012

    Posted 11 Feb Link to this post

    Before I start down the path of using RadSpreadsheet I want to verify that it will do what I want.  
    I would like to use the spreadsheet to do some custom background calculations in a SaaS environment.  The end user would create their own spreadsheets with links to data in their database (maybe using Custom Functions).  The spreadsheet would be calculated in the backend every few minutes, pulling in updated data and solving the spreadsheet.  The output cells (again using Custom Functions) would update the customer's data tables.
    Is that a viable use-case for RadSpreadsheet?  I realize the input and output connections to the external data is not part of RadSpreadsheet but it seems like Custom Functions might get me there.
    Is there any information on the order of solving calculations in formulas cells?   
  2. Boby
    Admin
    Boby avatar
    697 posts

    Posted 14 Feb Link to this post

    Hi Steve,

    The scenario seems feasible. The cells that contain formulas are automatically updated when the referenced cell values are updated. You can read more in the Cell References help article. For custom functions, the Custom Functions documentation article or  CustomFunctions SDK example may help.

    Regards,
    Boby
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top