* [bug] removing last column with a column formula
@ 2011-08-09 12:50 Nicolas Goaziou
2011-08-09 14:54 ` Michael Brand
2011-08-24 18:29 ` Bastien
0 siblings, 2 replies; 6+ messages in thread
From: Nicolas Goaziou @ 2011-08-09 12:50 UTC (permalink / raw)
To: Org Mode List
Hello,
Let's consider the following table:
#+begin_src org
| 1 | 2 | 3 |
| 1 | 2 | 3 |
#+TBLFM: @2$1..@2$3=@1
#+end_src
If I remove the second column (M-S-Left), the formula is correctly
updated. But when I remove the last column, the formula gets partly
deleted and becomes:
#+TBLFM: @2$1..
Also, if this times, the first column is removed, that line becomes:
#+TBLFM: @2$INVALID..@2$2=@1
This is with latest Org and no user configuration.
Regards,
--
Nicolas Goaziou
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: [bug] removing last column with a column formula
2011-08-09 12:50 [bug] removing last column with a column formula Nicolas Goaziou
@ 2011-08-09 14:54 ` Michael Brand
2011-08-10 8:46 ` Nicolas Goaziou
2011-08-24 18:29 ` Bastien
1 sibling, 1 reply; 6+ messages in thread
From: Michael Brand @ 2011-08-09 14:54 UTC (permalink / raw)
To: Nicolas Goaziou; +Cc: Org Mode List
Hi Nicolas
Columns and rows are better referenced with "<" and ">" in many cases
to avoid such oddities:
#+begin_src org
| 1 | 2 | 3 |
| 1 | 2 | 3 |
#+TBLFM: @2$<..@2$>=@1
#+end_src
http://orgmode.org/manual/References.html#References
Michael
On Tue, Aug 9, 2011 at 14:50, Nicolas Goaziou <n.goaziou@gmail.com> wrote:
> Hello,
>
> Let's consider the following table:
>
> #+begin_src org
> | 1 | 2 | 3 |
> | 1 | 2 | 3 |
> #+TBLFM: @2$1..@2$3=@1
> #+end_src
>
> If I remove the second column (M-S-Left), the formula is correctly
> updated. But when I remove the last column, the formula gets partly
> deleted and becomes:
>
> #+TBLFM: @2$1..
>
> Also, if this times, the first column is removed, that line becomes:
>
> #+TBLFM: @2$INVALID..@2$2=@1
>
> This is with latest Org and no user configuration.
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: [bug] removing last column with a column formula
2011-08-09 14:54 ` Michael Brand
@ 2011-08-10 8:46 ` Nicolas Goaziou
0 siblings, 0 replies; 6+ messages in thread
From: Nicolas Goaziou @ 2011-08-10 8:46 UTC (permalink / raw)
To: Michael Brand; +Cc: Org Mode List
Hello,
Michael Brand <michael.ch.brand@gmail.com> writes:
> Columns and rows are better referenced with "<" and ">" in many cases
> to avoid such oddities:
>
> #+begin_src org
> | 1 | 2 | 3 |
> | 1 | 2 | 3 |
> #+TBLFM: @2$<..@2$>=@1
> #+end_src
Thanks for the pointers.
Though, the object of my message was more to point at a strange
behaviour that, perhaps, should be tackled down, someday.
Regards,
--
Nicolas Goaziou
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: [bug] removing last column with a column formula
2011-08-09 12:50 [bug] removing last column with a column formula Nicolas Goaziou
2011-08-09 14:54 ` Michael Brand
@ 2011-08-24 18:29 ` Bastien
2011-08-25 6:20 ` Carsten Dominik
1 sibling, 1 reply; 6+ messages in thread
From: Bastien @ 2011-08-24 18:29 UTC (permalink / raw)
To: Carsten Dominik, Nicolas Goaziou; +Cc: Org Mode List
Hi Carsten,
Nicolas Goaziou <n.goaziou@gmail.com> writes:
> Let's consider the following table:
>
> #+begin_src org
> | 1 | 2 | 3 |
> | 1 | 2 | 3 |
> #+TBLFM: @2$1..@2$3=@1
> #+end_src
>
> If I remove the second column (M-S-Left), the formula is correctly
> updated. But when I remove the last column, the formula gets partly
> deleted and becomes:
>
> #+TBLFM: @2$1..
>
> Also, if this times, the first column is removed, that line becomes:
>
> #+TBLFM: @2$INVALID..@2$2=@1
>
> This is with latest Org and no user configuration.
Is this something that we can (easily) fix?
Thanks!
--
Bastien
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: [bug] removing last column with a column formula
2011-08-24 18:29 ` Bastien
@ 2011-08-25 6:20 ` Carsten Dominik
2011-08-25 8:09 ` Bastien
0 siblings, 1 reply; 6+ messages in thread
From: Carsten Dominik @ 2011-08-25 6:20 UTC (permalink / raw)
To: Bastien; +Cc: Org Mode List, Michael Brand, Nicolas Goaziou, Carsten Dominik
On 24.8.2011, at 20:29, Bastien wrote:
> Hi Carsten,
>
> Nicolas Goaziou <n.goaziou@gmail.com> writes:
>
>> Let's consider the following table:
>>
>> #+begin_src org
>> | 1 | 2 | 3 |
>> | 1 | 2 | 3 |
>> #+TBLFM: @2$1..@2$3=@1
>> #+end_src
>>
>> If I remove the second column (M-S-Left), the formula is correctly
>> updated. But when I remove the last column, the formula gets partly
>> deleted and becomes:
>>
>> #+TBLFM: @2$1..
>>
>> Also, if this times, the first column is removed, that line becomes:
>>
>> #+TBLFM: @2$INVALID..@2$2=@1
>>
>> This is with latest Org and no user configuration.
>
> Is this something that we can (easily) fix?
Not easily. I have made it throw an error now, but there may be
other situations like this which are not yet captured.
Michael Brand has pointed out correctly that if you want to use
ranges the go to the border of the table, you should use
$< and $>
Cheers
- Carsten
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: [bug] removing last column with a column formula
2011-08-25 6:20 ` Carsten Dominik
@ 2011-08-25 8:09 ` Bastien
0 siblings, 0 replies; 6+ messages in thread
From: Bastien @ 2011-08-25 8:09 UTC (permalink / raw)
To: Carsten Dominik
Cc: Org Mode List, Michael Brand, Nicolas Goaziou, Carsten Dominik
Carsten Dominik <dominik@uva.nl> writes:
>> Is this something that we can (easily) fix?
>
> Not easily. I have made it throw an error now, but there may be
> other situations like this which are not yet captured.
Throwing an error in this case is already an improvement -- thanks
for this!
--
Bastien
^ permalink raw reply [flat|nested] 6+ messages in thread
end of thread, other threads:[~2011-08-25 8:09 UTC | newest]
Thread overview: 6+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2011-08-09 12:50 [bug] removing last column with a column formula Nicolas Goaziou
2011-08-09 14:54 ` Michael Brand
2011-08-10 8:46 ` Nicolas Goaziou
2011-08-24 18:29 ` Bastien
2011-08-25 6:20 ` Carsten Dominik
2011-08-25 8:09 ` Bastien
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).