Last Updated:
11 Mar 2024 13:20
by ADMIN
SpreadProcessing: The result of a formula is not updated when the formula depends on a reference to another reference which is imported after it
This happens only on import, that is, if the values are created through UI or through the model, it does not happen. A sheet has a formula A which depends on a cell B and this cell also has a reference to another cell C and the formula A is so placed in the sheet so that it will be imported before cell B. When cell C is updated, the value in A will not be recalculated.