Hi Please consider the following example #+begin_src elisp | / | <> | <> | <> | <> | <> | <> | <> | | | | | | | | | | | | | DMI G | DMNI H | ExNDM I | ExNDNM J | my-result | his-result | Check | aux1 | aux2 | aux3 | aux4 | aux5 | aux6 | Res-aux | Weight2 | | | Weight: | 1 | 0.2 | 1 | 0.1 | | 0.1 | | | | | | | | | 0.1 | |---+---------+-------+--------+---------+----------+-----------+------------+-------+------+------+------+------+------+------+---------+---------| | | user1 | 0 | 0 | 11 | 0 | 10.1 | 10.1 | OK | 0 | 0 | 0.0 | 0.1 | 10 | 0.0 | 10.1 | | |---+---------+-------+--------+---------+----------+-----------+------------+-------+------+------+------+------+------+------+---------+---------| ,#+TBLFM: $7=if($3>10,($3-10)*@3$17,0)+ min(10,$3)*@3$3+ min(10,$4)*@3$4 + if($5>10,($5-10)*@3$17,0)+min(10,$5)*@3$5 +@3$6*$6;f1::$9=if("$7" == "$8", OK, NO)::$10=if($3>10,($3-10)*@3$17,0);f1::$11=min(10,$3)*@3$3;f1::$12=min(10,$4)*@3$4;f1::$13=if($5>10,($5-10)*@3$17,$5);f1::$14=min(10,$5)*@3$3;f1::$15=@3$6*$6;f1::$16=vsum($10..$14);f1 #+end_src Now I delete the last columns #+begin_src elisp | / | <> | <> | <> | <> | <> | <> | | | | | DMI G | DMNI H | ExNDM I | ExNDNM J | my-result | Weight2 | | | Weight: | 1 | 0.2 | 1 | 0.1 | | 0.1 | |---+---------+-------+--------+---------+----------+-----------+---------| | | user1 | 0 | 0 | 11 | 0 | 10.1 | | |---+---------+-------+--------+---------+----------+-----------+---------| ,#+TBLFM: $7=if($3>10,($3-10)*@3$16,0)+ min(10,$3)*@3$3+ min(10,$4)*@3$4 + if($5>10,($5-10)*@3$16,0)+min(10,$5)*@3$5 +@3$6*$6;f1:: #+end_src But as you can see @3$17 only gets changed to @3$16 but not to @3$8 as it should be. Is this a *BUG*? I am running emacs and org git master from a couple of weeks ago. Regards Uwe Brauer
On Wednesday, 7 Jul 2021 at 09:07, Uwe Brauer wrote: > Hi > > Please consider the following example > > #+begin_src elisp [...] > #+end_src > > Now I delete the last columns > > But as you can see @3$17 only gets changed to @3$16 but not to @3$8 as > it should be. Confirmed. One solution, for the moment, is to move the column over first and then delete the columns. By the way, it would help if you src blocks were org and not elisp as the language! -- : Eric S Fraga via Emacs 28.0.50, Org release_9.4.6-577-gf76d4d : Latest paper written in org: https://arxiv.org/abs/2106.05096
[-- Attachment #1: Type: text/plain, Size: 813 bytes --] >>> "ESF" == Eric S Fraga <e.fraga@ucl.ac.uk> writes: > On Wednesday, 7 Jul 2021 at 09:07, Uwe Brauer wrote: >> Hi >> >> Please consider the following example >> >> #+begin_src elisp > [...] >> #+end_src >> >> Now I delete the last columns >> >> But as you can see @3$17 only gets changed to @3$16 but not to @3$8 as >> it should be. > Confirmed. Ok so it is a bug. I will write a but report then. > One solution, for the moment, is to move the column over first and then > delete the columns. > By the way, it would help if you src blocks were org and not elisp as > the language! Oops, I was not sure whether this was the right conf, so to be on the safe side I used elisp, thanks for pointing this out to me. Off the record: good look tonight..... Although.... [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 5673 bytes --]
[-- Attachment #1: Type: text/plain, Size: 978 bytes --] >>> "ESF" == Eric S Fraga <e.fraga@ucl.ac.uk> writes: > On Wednesday, 7 Jul 2021 at 18:22, Uwe Brauer wrote: >> Off the record: good look tonight..... Although.... > Yesterday's match was fantastic even though the outcome was not what I hoped for. I agree, I think it is fair to say, that Spain was the better team, but then football is about scoring not about playing aesthetically pleasing. When Italy started the penalty shootout, I thought this is a lost case, since, I think, most teams that started the penalties, won. As for tonight: I am torn between England (because it took them so long to reach a semi finals and even being the favorite) and Denmark (because what happened to Christian Eriksen. A last word concerning the Germany England game. England deserved the victory, although if Müller had kept his nerve and made that goal things might have turned out differently. So as I said good luck tonight: might the better team win. [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 5673 bytes --]
Eric S Fraga <e.fraga@ucl.ac.uk> writes: >> But as you can see @3$17 only gets changed to @3$16 but not to @3$8 as >> it should be. > > Confirmed. Fixed. https://git.savannah.gnu.org/cgit/emacs/org-mode.git/commit/?id=ceb99b86006f9a10a772860c72dd473cb15a72aa -- Ihor Radchenko, 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