Re: [BUG] org-table-eval-formula mishandles semicolons in formulas [9.7-pre (release_9.6.14-1019-g5092ec @ /home/nick/src/emacs/org/org-mode/lisp/)]

[Ihor Radchenko <yantar92@posteo.net>]

Ihor Radchenko <yantar92@posteo.net> writes:

>>>     #+TBLFM: $3='(concat "COMMENT ON public.layout_forms." $1 " IS " (rc-sq $2) ";")
> ...
> Fixed, on main.
> https://git.savannah.gnu.org/cgit/emacs/org-mode.git/commit/?id=5af062511

Alas. We cannot restrict what to put after ";" in formulas, because it
can be interpreted as format spec for `format':

|  a |  b | percent of a in b |
|----+----+-------------------|
| 10 | 20 | #ERROR            |
| 20 | 30 | #ERROR            |
#+TBLFM: $3=($1/$2)*100;%.2f%%

So, your example 
#+TBLFM: $3='(concat "COMMENT ON public.layout_forms." $1 " IS " (rc-sq $2) ";")

is actually ambiguous - it may also be interpreted as ") format specifier.

You can solve the problem by putting an extra ; at the end of the
formula:
#+TBLFM: $3='(concat "COMMENT ON public.layout_forms." $1 " IS " (rc-sq $2) ";");

I added an example explaining this caveat to the manual.
https://git.savannah.gnu.org/cgit/emacs/org-mode.git/commit/?id=6799350a8

| 1 | 1; |
#+tblfm: $2='(concat $1 ";");

| 1 | ") |
#+tblfm: $2='(concat $1 ";")

-- 
Ihor Radchenko // yantar92,
Org mode contributor,
Learn more about Org mode at <https://orgmode.org/>.
Support Org development at <https://liberapay.com/org-mode>,
or support my work at <https://liberapay.com/yantar92>