Re: Update the value of specific column using the values of other columns on-the-fly.

[Emanuel Berg]

Hongyi Zhao wrote:

>> But then in Lispp (Lisp and only Lisp), i.e., 100% code,
>> because reading column values back and forth in a buffer -
>> that is soo fragile...
>
> The orgmode itself is also written in elisp

Yes, as is the SES (Simple Emacs Spreadsheet).

> so why do you have the above point of view?

Take a look at this file, it is about about Olympic hockey. [1]
Sure, you can do the most basic of all arithmetic (which is
counting) but move a single entry in that file even one column
to the right or left and it breaks...

So to have something that even remotely works like
a spreadsheet, either do it in Lisp, suitable for a quick
one-shot

(let*((value-1 (do-computations))
      ...)
  (present-result) )

or, even better, and in particular if you intend to do this
again and/or extend/resuse/modify it, use
a spreadsheet solution.

The type of software you are asking for is a spreadsheet.

[1] https://dataswamp.org/~incal/hockey/og.el

-- 
underground experts united
http://user.it.uu.se/~embe8573
https://dataswamp.org/~incal