Hi.

It is about using ses programatically for doing on the fly calculations.
The process has three parts:

1. input file '/tmp/ses202307'
2. template file '/tmp/workbook.ses'
3. elisp file '/tmp/smeter.el'

The output is the file '/tmp/smeter.mbox'

The process is working with a couple of workarounds.
workaround one: it needs yank.
workaround two: manual recalculation of affected cells

As attachments: You would fine
1. smeter.el (version with workarounds)
2. smeter-version-wished-works.el (the name explains it)


The questions are:
1. Is it a bug on 'ses-recalculate-all' (see smeter-version-wished-works.el)
2. why the yank workaround is needed. Why it causes it to work. (see
smeter.el)
3. which one is the right syntax for (ses-range) programatically.
4. how should a user consult a cell value programatically.

Best Regards
Andrés Ramírez