Indirect calulations stop being performed

Aspose.Cells Product Family
1

Hi there

Please have a look at the attached excel sheet and code. The table is pretty simple. There is cell B4 for input, cell C4 is calculated as C3 - B4 and D4 simply copies C4. This is a simple version of a more complex scenario we have. Now I start putting values into B4 according to the following sequence and get the values as stated. After each put I perform a CalculateFormula() on the workbook.

Iteration | B4 | C4 | D4 |
----------------------------
Initial | 5 | 3 | 3 |
1 | 6 | 2 | 2 |
2 | 7 | 1 | 1 |
3 | 8 | 0 | 1 |
4 | 9 | -1 | 1 |

As you can see, C4 keeps being calculated correctly, however the indirectly dependent cell D4 stops being calculated after iteration 2.

Cheers

Lukas

2

Hi,

Thanks for providing us the template project.

After an initial test, we found the issue as you have mentioned. We will figure it out soon.

Your issue has been added to our issue tracking system with an issue id: CELLSNET-13840. We will inform you when it is sorted out.

Thank you.

3

Hi,

Please try the attached version. We have fixed your mentioned issue.

Thank you.

4

Hi,

Thanks for the quick turnaround, problem solved.

Cheers

Lukas

5

The issues you have found earlier (filed as 13840) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.