Bug: Error in table formula with @> reference [8.3.4 (release_8.3.4-5-gdc68d2)]

Bug: Error in table formula with @> reference [8.3.4 (release_8.3.4-5-gdc68d2)]

[Pablo S. Casas]

Hi Org mode users:

   The problem can be reproduced with the table:

|   399. |
|--------|
| 100.00 |
| 301.00 |
|  -2.00 |
|--------|
#+TBLFM: @1$1=vsum(@2..@>)::

The value in @1$1 is calculated correctly when using C-c C-c on the
#+TBLFM line. However using C-u C-c = on cell @1$1 gives #ERROR.

By means of edebug I've checked that in function
org-table-eval-formula, in the code (line 160):

	;; Insert complex ranges
	(while (and (string-match org-table-range-regexp form)
		    (> (length (match-string 0 form)) 1))

the variable org-table-range-regexp doesn't parse well the range
@2..@>, missunderstanding the ">".

   I hope this helps to fix the issue.

   Pablo S. Casas


Emacs  : GNU Emacs 24.5.1 (x86_64-pc-linux-gnu)
Package: Org-mode version 8.3.4 (release_8.3.4-5-gdc68d2 @ $HOME/.emacs.d/elpa/org-mode/lisp/)

current state:
==============
(setq
 org-tab-first-hook '(org-hide-block-toggle-maybe org-babel-hide-result-toggle-maybe
		      org-babel-header-arg-expand)
 org-speed-command-hook '(org-speed-command-default-hook org-babel-speed-command-hook)
 org-occur-hook '(org-first-headline-recenter)
 org-metaup-hook '(org-babel-load-in-session-maybe)
 org-confirm-shell-link-function 'yes-or-no-p
 org-after-todo-state-change-hook '(org-clock-out-if-current)
 org-src-mode-hook '(org-src-babel-configure-edit-buffer org-src-mode-configure-edit-buffer)
 org-agenda-before-write-hook '(org-agenda-add-entry-text)
 org-babel-pre-tangle-hook '(save-buffer)
 org-mode-hook '(#[nil "\300\301\302\303\304$\207"
		   [org-add-hook change-major-mode-hook org-show-block-all append local] 5]
		 #[nil "\300\301\302\303\304$\207"
		   [org-add-hook change-major-mode-hook org-babel-show-result-all append local] 5]
		 org-babel-result-hide-spec org-babel-hide-all-hashes)
 org-archive-hook '(org-attach-archive-delete-maybe)
 org-ctrl-c-ctrl-c-hook '(org-babel-hash-at-point org-babel-execute-safely-maybe)
 org-cycle-hook '(org-cycle-hide-archived-subtrees org-cycle-hide-drawers org-cycle-show-empty-lines
		  org-optimize-window-after-visibility-change)
 org-confirm-elisp-link-function 'yes-or-no-p
 org-metadown-hook '(org-babel-pop-to-session-maybe)
 org-clock-out-hook '(org-clock-remove-empty-clock-drawer)
 )

Re: Bug: Error in table formula with @> reference [8.3.4 (release_8.3.4-5-gdc68d2)]

[Nicolas Goaziou]

Hello,

Pablo S. Casas <pabloscasas@gmail.com> writes:

>    The problem can be reproduced with the table:
>
> |   399. |
> |--------|
> | 100.00 |
> | 301.00 |
> |  -2.00 |
> |--------|
> #+TBLFM: @1$1=vsum(@2..@>)::
>
> The value in @1$1 is calculated correctly when using C-c C-c on the
> #+TBLFM line. However using C-u C-c = on cell @1$1 gives #ERROR.

I cannot reproduce it on maint (i.e., ELPA release). Could you
double-check that you are using the latest stable release?

Regards,

-- 
Nicolas Goaziou

Re: Bug: Error in table formula with @> reference [8.3.4 (release_8.3.4-5-gdc68d2)]

[Nicolas Goaziou]

Nicolas Goaziou <mail@nicolasgoaziou.fr> writes:

> I cannot reproduce it on maint (i.e., ELPA release). Could you
> double-check that you are using the latest stable release?

Nevermind. I misread the bug report. I can reproduce it. I'll look into
it.

Re: Bug: Error in table formula with @> reference [8.3.4 (release_8.3.4-5-gdc68d2)]

[Nicolas Goaziou]

Hello,

Pablo S. Casas <pabloscasas@gmail.com> writes:

>    The problem can be reproduced with the table:
>
> |   399. |
> |--------|
> | 100.00 |
> | 301.00 |
> |  -2.00 |
> |--------|
> #+TBLFM: @1$1=vsum(@2..@>)::
>
> The value in @1$1 is calculated correctly when using C-c C-c on the
> #+TBLFM line. However using C-u C-c = on cell @1$1 gives #ERROR.

Fixed. Thank you.

Regards,

-- 
Nicolas Goaziou