clocktable :formula not working for columns > $9

clocktable :formula not working for columns > $9

[Brian J Hoskins]

[-- Attachment #1: Type: text/plain, Size: 1174 bytes --]

org-mode development team,

When generating a clocktable and using the :formula parameter, attempts
to manipulate columns > $9 are unsuccessful.

For example, consider the attached (anonymised) screen-grab of the
output from a clocktable in one of my org files.

As a test, I have used the :formula parameter to create sequential
columns.  It works up to and including column 9, but fails thereafter.
No error is generated.  Here is the generated #+TBLFM line:

#+TBLFM: @1$4 = (4)::@1$5 = (5)::@1$6 = (6)::@1$7 = (7)::@1$8 =
(8)::@1$9 = (9)::@1$10 = (10)::@1$11 = (11)

This formula works fine on tables that I create myself.  It only fails
to work in clocktables.

If this failure can be repeated by other org-mode users, perhaps we
should file a bug report.


-- 
+--------------------------------------------+
| Brian J Hoskins BSc MIET                   |
| Electronics Engineer & Computer Programmer |
+------+-------------------------------------+
| WEB: | brianhoskins.uk                     |
| GIT: | github.com/bh4017                   |
| PGP: | keybase.io/bjh                      |
+------+-------------------------------------+

[-- Attachment #2: Selection_360.png --]
[-- Type: image/png, Size: 82362 bytes --]

Re: clocktable :formula not working for columns > $9

[Nicolas Goaziou]

Hello,

Brian J Hoskins <brian@hoskins.eu> writes:

> When generating a clocktable and using the :formula parameter, attempts
> to manipulate columns > $9 are unsuccessful.
>
> For example, consider the attached (anonymised) screen-grab of the
> output from a clocktable in one of my org files.
>
> As a test, I have used the :formula parameter to create sequential
> columns.  It works up to and including column 9, but fails thereafter.
> No error is generated.  Here is the generated #+TBLFM line:
>
> #+TBLFM: @1$4 = (4)::@1$5 = (5)::@1$6 = (6)::@1$7 = (7)::@1$8 =
> (8)::@1$9 = (9)::@1$10 = (10)::@1$11 = (11)
>
> This formula works fine on tables that I create myself.

It only works if the initial table contains enough columns. Try:

    | 1 |
    #+TBLFM: @1$1=(1)::@1$2=(2)::@1$3=(3)::@1$4=(4)::@1$5=(5)::@1$6=(6)::@1$7=(7)::@1$8=(8)::@1$9=(9)::@1$10=(10)::@1$11=(11)

> If this failure can be repeated by other org-mode users, perhaps we
> should file a bug report.

Confirmed and fixed. Thank you.

By default, according to `org-table-formula-create-columns', Org ought
to refuse to apply such a formula, which is now the case.

Consider setting `org-table-formula-create-columns' to a non-nil value.

Regards,

-- 
Nicolas Goaziou