Re: [O] Table formula with @I
Charles Millar writes: > I must be missing something. When I recalculate the table (update > table) applying both above TBLFM's - on the line to be updated, in the > TBLFM line, and in the table itself, an error is returned > > "can't assign to hline relative reference" > > Org-mode version 8.3beta (release_8.3beta-304-ga4a1d8 @ > c:/cygwin/home/Charlie01/.elisp/org-mode/lisp/) > GNU Emacs 24.3.1 (i386-mingw-nt6.0.6002) of 2013-03-17 on MARVIN > Windows Vista SP2 > It works on my Org version (8.2.7c from ELPA). After a bit of digging I found that: - the "can't assign to hline relative reference" message was added by commit a2c71a6e359cb93aa652f65c666294fb2a3b5e1b dated Nov 5th, 2013 - motivations for that patch have been discussed here: http://thread.gmane.org/gmane.emacs.orgmode/71562 - so I think I suggested something undocumented/unsupported that can't be used anymore, sorry :( - I'd like to express it as a wish for the future: support for hline references ("@I") in the left side of the formula would be a great feature (and it already seemed to work in some special cases, like @I+1$1..@I+1$1) Kindest regards, Andrea
Re: [O] Table formula with @I
Charles Millar writes: > Andrea Rossetti wrote: >> "Loris Bennett" writes: >>> In the following: >>> >>> | | | | >>> | | | | >>> |---+---+---| >>> | 1 | 1 | 1 | >>> #+TBLFM: @I$3=1 >>> >>> I expected to get a '1' just in the third column. Where am I going >>> wrong? >> (apologies in advance for suggesting just a workaround >> instead of a rational explanation, hope it helps anyway) >> >> It happened to me too some time ago, I used a slightly >> different formula and it worked: >> >> #+TBLFM: @I+1$3..@I+1$3=1 >> >> Does it work for you too? Kindest regards, >> >>Andrea >> > I must be missing something. When I recalculate the table (update > table) applying both above TBLFM's - on the line to be updated, in the > TBLFM line, and in the table itself, an error is returned > > "can't assign to hline relative reference" > > Org-mode version 8.3beta (release_8.3beta-304-ga4a1d8 @ > c:/cygwin/home/Charlie01/.elisp/org-mode/lisp/) > GNU Emacs 24.3.1 (i386-mingw-nt6.0.6002) of 2013-03-17 on MARVIN > Windows Vista SP2 > > Charlie Andrea's kludge works for me. My understanding is that only a C-c C-c in the TBLFM would actually update the table. Looking at the documentation at http://orgmode.org/manual/References.html#References again, I would have expected @I+1$3 to be a correct way of referring to the 3rd column in the row after the first hline, rather than the entire row. It is unclear to me what @I$3 as I used in my example above should correspond to. Cheers, Loris -- This signature is currently under construction.
Re: [O] Table formula with @I
Andrea Rossetti wrote: "Loris Bennett" writes: In the following: | | | | | | | | |---+---+---| | 1 | 1 | 1 | #+TBLFM: @I$3=1 I expected to get a '1' just in the third column. Where am I going wrong? (apologies in advance for suggesting just a workaround instead of a rational explanation, hope it helps anyway) It happened to me too some time ago, I used a slightly different formula and it worked: #+TBLFM: @I+1$3..@I+1$3=1 Does it work for you too? Kindest regards, Andrea I must be missing something. When I recalculate the table (update table) applying both above TBLFM's - on the line to be updated, in the TBLFM line, and in the table itself, an error is returned "can't assign to hline relative reference" Org-mode version 8.3beta (release_8.3beta-304-ga4a1d8 @ c:/cygwin/home/Charlie01/.elisp/org-mode/lisp/) GNU Emacs 24.3.1 (i386-mingw-nt6.0.6002) of 2013-03-17 on MARVIN Windows Vista SP2 Charlie --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
Re: [O] Table formula with @I
"Loris Bennett" writes: > In the following: > > | | | | > | | | | > |---+---+---| > | 1 | 1 | 1 | > #+TBLFM: @I$3=1 > > I expected to get a '1' just in the third column. Where am I going > wrong? (apologies in advance for suggesting just a workaround instead of a rational explanation, hope it helps anyway) It happened to me too some time ago, I used a slightly different formula and it worked: #+TBLFM: @I+1$3..@I+1$3=1 Does it work for you too? Kindest regards, Andrea
[O] Table formula with @I
Dear All, In the following: | | | | | | | | |---+---+---| | 1 | 1 | 1 | #+TBLFM: @I$3=1 I expected to get a '1' just in the third column. Where am I going wrong? Cheers, Loris Org-mode version 8.2.7c (8.2.7c-44-g3fed03-elpaplus @ /home/loris/.emacs.d/elpa/org-plus-contrib-20140818/) -- This signature is currently under construction.