1. Feedback
  2. ASP.NET Core
  3. 53917

Welcome to the ASP.NET Core feedback portal. We’re happy you’re here! If you have feedback on how to improve the ASP.NET Core, we’d love to hear it!

  • Check out the features or bugs others have reported and vote on your favorites. Feedback will be prioritized based on popularity.
  • If you have feedback that’s not listed yet, submit your own.

Thanks for joining our community and helping improve Syncfusion products!

2
Votes

Provide a public method to update the formula's dependent cell collections

While saving and loading the spreadsheet data as JSON, the dependent collection value of the formula is not maintained. Therefore, we need to implement a public method to update the formula's dependent cells.

I have attached a sample to illustrate this requirement. You can understand this requirement by following the steps below.

  • In the sample, the value of cell C20 on the first sheet (Generation Data) is 100.

  • Additionally, on the same sheet, the formula for cell C1500 is "=SUM(C1:C20)", which references cell C20.

  • Furthermore, on another sheet, the formula for cell D15 is "=Generation Data!C1500", which references cell C1500 of the first sheet(Generation Data).

  • Now, while navigating to these cells by switching sheets and scrolling, the formulas calculated on those cells and their results are updated in the value property of the cell models as they are being rendered. Subsequently, if you modify the value in cell Generation Data!C20, the formula values in cells Generation Data!C1500 and GR!D15 are also properly updated.

  • By clicking the "Save As JSON" button in the sample, you can save the spreadsheet data as JSON. And you can load this saved JSON into a spreadsheet by clicking the button "Load JSON" in this sample.

  • Now, if you check the cells Generation Data!C20, Generation Data!C1500, and GR!D15, you'll see that the values in these cells are properly maintained.

  • The problem now arises when you change the value in the cell Generation Data!C20: the formula values in cells Generation Data!C1500 and GR!D15 do not update accordingly. This issue stems from the fact that while saving and loading the spreadsheet data as JSON, the collection of dependent cells for formulas is not being maintained.

  • We now need to provide a public method to update the dependent cells of formulas after saving and loading the spreadsheet data, as mentioned above. This will help prevent the problem of formula result values not being updated, as mentioned above.