Question about using programs in spreadsheet

[nickapos]

(07-27-2023 08:13 PM)froehlic Wrote:  If I understand that correct: You want to call a program inside a cell?

You can do that like this:

Code:


EXPORT FF_min(a, b)
BEGIN
  return IFTE(a<b, a, b);
END;

Now you can put your values for a and b in spreadsheet cells, lets say A1 and A2.
Define A3 as:
=FF_min(A1, A2)

The value in A3 is always the minimum of A1 and A2. This as a simple example. Your program can be whatever, for this special case you have to return a single object that can be stored in a cell.
You also can manipulate other cells in your program:

Code:


  Cell(1,11):=1;           // set cell K1 to 1
  Cell(1,10,7):= Col1;  // background color of J10 to color code Col1

Hope that's useful for you.

This is great exactly what I was looking for, thank you very much