Re: [O] How to use symbolic names to refer to spreadsheet fields containing irregular values
Hi Christoph On Wed, Aug 3, 2016 at 11:31 PM, Christoph LANGEwrote: > I would like to make the following work (with Org 8.3.5): > > |---+--++---| > | |13:13 | - | 1 | > | ^ |h | s | n | > |---+--++---| > | | 13:13:00 | #ERROR | 1 | > |---+--++---| > #+TBLFM: @3$2=$h;T::@3$3=$s::@3$4=$n > > I can give the field @1$2 the symbolic name $h, I can give the field > @1$4 the symbolic name $n, and I can successfully refer to both of them > in @3. > > However I didn't manage to refer to @1$3 using the symbolic name $s. > The reason must be the value "-". If I use an alphabetic string value, > it works. > > Any ideas? Or is this a bug? > > Thank you very much in advance, "-" is not a valid Calc expression. To copy literally one needs a Lisp formula: |---+--+---+---| | |13:13 | - | 1 | | ^ |h | s | n | |---+--+---+---| | | 13:13:00 | - | 1 | |---+--+---+---| #+TBLFM: @3$2 = $h; T :: @3$3 = '(identity "$s") :: @3$4 = $n Michael
[O] How to use symbolic names to refer to spreadsheet fields containing irregular values
Dear all, I would like to make the following work (with Org 8.3.5): |---+--++---| | |13:13 | - | 1 | | ^ |h | s | n | |---+--++---| | | 13:13:00 | #ERROR | 1 | |---+--++---| #+TBLFM: @3$2=$h;T::@3$3=$s::@3$4=$n I can give the field @1$2 the symbolic name $h, I can give the field @1$4 the symbolic name $n, and I can successfully refer to both of them in @3. However I didn't manage to refer to @1$3 using the symbolic name $s. The reason must be the value "-". If I use an alphabetic string value, it works. Any ideas? Or is this a bug? Thank you very much in advance, Christoph -- Dr. Christoph Lange, Enterprise Information Systems Department Applied Computer Science @ University of Bonn; Fraunhofer IAIS http://langec.wordpress.com/about, Skype duke4701 → Please note: I will be on parental leave from 29 July to 28 October. Colleagues will stand in for me by project.