Posted 20 August 2021, 1:16 pm EST
Hello
We’re trying to achieve the following with Spread.NET V14 in ASP.NET MVC:
We have a screen where a user has full control on the spread component, and thus has the ability to create multiple sheets and refer from one sheet to another.
There is second screen where the user can edit each sheet individually (where we only load the sheet content of that specific sheet).
There is a third screen which loads all sheets into a single spread instance.
Here we face an issue:
Say the user creates two sheets: Sheet1 and Sheet2, and refers from Sheet1 with the following formula: =Sheet2!A1
This works fine in the first and second screen.
On the third screen, we load Sheet1 and Sheet2 sequentially, but this leads to initially showing #REF! in the cell which refers to cell A1 of Sheet2.
The cell value in the back-end also shows #REF! in the formula, text and value property.
Reversing the sheet loading order doesn’t solve the issue.
Neither do the methods Recalculate and RecalculateAll.
However, calling the javascript Update-method seems to re-evaluate the formula and eventually shows the right value, but this workaround isn’t always possible for us.
Is there any way to let the formula evaluate correctly using the .NET Spread API?
Thanks in advance!
Kind regards
Joni