emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* clocktable :formula not working for columns > $9
@ 2018-01-06 17:55 Brian J Hoskins
  2018-01-07  9:58 ` Nicolas Goaziou
  0 siblings, 1 reply; 2+ messages in thread
From: Brian J Hoskins @ 2018-01-06 17:55 UTC (permalink / raw)
  To: emacs-orgmode

[-- 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 --]

^ permalink raw reply	[flat|nested] 2+ messages in thread

* Re: clocktable :formula not working for columns > $9
  2018-01-06 17:55 clocktable :formula not working for columns > $9 Brian J Hoskins
@ 2018-01-07  9:58 ` Nicolas Goaziou
  0 siblings, 0 replies; 2+ messages in thread
From: Nicolas Goaziou @ 2018-01-07  9:58 UTC (permalink / raw)
  To: Brian J Hoskins; +Cc: emacs-orgmode

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

^ permalink raw reply	[flat|nested] 2+ messages in thread

end of thread, other threads:[~2018-01-07  9:59 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2018-01-06 17:55 clocktable :formula not working for columns > $9 Brian J Hoskins
2018-01-07  9:58 ` Nicolas Goaziou

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).