Automatic recalculation when a source cell is changed.

ID: 1379

See: Project: Creating a Spreadsheet Formula Evaluator 
				
					using uCalcSoftware;

var uc = new uCalc();
// Define cells A1 and B1, where B1 depends on A1
uc.Define("Overwrite ~~ Function: A1() = 10");
uc.Define("Overwrite ~~ Function: B1() = A1() * 5");

Console.WriteLine($"Initial B1 value: {uc.Eval("B1()")}"); // Expected: 50

// Now, change the value of A1. B1 will update automatically.
uc.Define("Overwrite ~~ Function: A1() = 20");

Console.WriteLine($"Updated B1 value: {uc.Eval("B1()")}"); // Expected: 100
				
			
Initial B1 value: 50
Updated B1 value: 100
Explore 600+ other examples
				
					#include <iostream>
#include "uCalc.h"

using namespace std;
using namespace uCalcSoftware;

int main() {
   uCalc uc;
   // Define cells A1 and B1, where B1 depends on A1
   uc.Define("Overwrite ~~ Function: A1() = 10");
   uc.Define("Overwrite ~~ Function: B1() = A1() * 5");

   cout << "Initial B1 value: " << uc.Eval("B1()") << endl; // Expected: 50

   // Now, change the value of A1. B1 will update automatically.
   uc.Define("Overwrite ~~ Function: A1() = 20");

   cout << "Updated B1 value: " << uc.Eval("B1()") << endl; // Expected: 100
}
				
			
Initial B1 value: 50
Updated B1 value: 100
Explore 600+ other examples
				
					Imports System
Imports uCalcSoftware
Public Module Program
   Public Sub Main()
      Dim uc As New uCalc()
      '// Define cells A1 and B1, where B1 depends on A1
      uc.Define("Overwrite ~~ Function: A1() = 10")
      uc.Define("Overwrite ~~ Function: B1() = A1() * 5")
      
      Console.WriteLine($"Initial B1 value: {uc.Eval("B1()")}") '// Expected: 50
      
      '// Now, change the value of A1. B1 will update automatically.
      uc.Define("Overwrite ~~ Function: A1() = 20")
      
      Console.WriteLine($"Updated B1 value: {uc.Eval("B1()")}") '// Expected: 100
   End Sub
End Module
				
			
Initial B1 value: 50
Updated B1 value: 100
Explore 600+ other examples