emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Nicolas Goaziou <mail@nicolasgoaziou.fr>
To: Brian J Hoskins <brian@hoskins.eu>
Cc: emacs-orgmode@gnu.org
Subject: Re: clocktable :formula not working for columns > $9
Date: Sun, 07 Jan 2018 10:58:59 +0100	[thread overview]
Message-ID: <878tda6lcs.fsf@nicolasgoaziou.fr> (raw)
In-Reply-To: <83942219-9266-24de-ce7f-0f3539b626ed@hoskins.eu> (Brian J. Hoskins's message of "Sat, 6 Jan 2018 17:55:09 +0000")

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

      reply	other threads:[~2018-01-07  9:59 UTC|newest]

Thread overview: 2+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2018-01-06 17:55 clocktable :formula not working for columns > $9 Brian J Hoskins
2018-01-07  9:58 ` Nicolas Goaziou [this message]

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=878tda6lcs.fsf@nicolasgoaziou.fr \
    --to=mail@nicolasgoaziou.fr \
    --cc=brian@hoskins.eu \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
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).