From: Dima Kogan <dima@secretsauce.net>
To: Nicolas Goaziou <mail@nicolasgoaziou.fr>
Cc: "emacs-orgmode@gnu.org" <emacs-orgmode@gnu.org>
Subject: Re: Adding new table rows/cols in a formula update
Date: Wed, 01 Oct 2014 12:38:23 -0700 [thread overview]
Message-ID: <87bnpvh8kb.fsf@secretsauce.net> (raw)
In-Reply-To: <8738b78tt0.fsf@nicolasgoaziou.fr>
[-- Attachment #1: Type: text/plain, Size: 2823 bytes --]
Hi. Thanks for replying.
Nicolas Goaziou <mail@nicolasgoaziou.fr> writes:
> Thanks for your patch. Some comments follow.
>
>> From 3b6581c647cb87f0d3e8cee94ce2fb1fb122d3fd Mon Sep 17 00:00:00 2001
>> From: Dima Kogan <dima@secretsauce.net>
>> Date: Tue, 30 Sep 2014 22:36:21 -0700
>> Subject: [PATCH] Field formulas can now add columns as needed
>>
>> The org-table-formula-make-new-cols customization controls whether and how this
>> is done
>
> Your commit message is missing information and "TINYCHANGE" at its end.
> See http://orgmode.org/worg/org-contribute.html#sec-5
OK. Added. By the way, I signed the copyright-assignment paperwork for
Emacs itself. Would I need to do this again for org-mode?
>> +(defcustom org-table-formula-make-new-cols nil
>
> What about `org-table-formula-create-columns'?
Sure, why not.
>> + "Non-nil means that evaluation of a field formula can add new
>> +columns if an out-of-bounds field is being set."
>
> First line needs to be complete. E.g.,
>
> "Non-nil means a field formula can create a new column."
>
>> + :group 'org-table-calculation
>> + :type '(choice
>> + (const :tag "Setting an out-of-bounds field generates an error (default)" nil)
>> + (const :tag "Setting an out-of-bounds field silently adds columns as needed" t)
>> + (const :tag "Setting an out-of-bounds field adds columns as needed, but issues a warning message" warn)
>> + (const :tag "When setting an out-of-bounds field, the user is
>> prompted" prompt)))
>
> You need to add :version and :package-version keywords.
OK. I'm not sure what those values should be, so please double-check.
>> (defgroup org-table-import-export nil
>> "Options concerning table import and export in Org-mode."
>> :tag "Org Table Import Export"
>> @@ -3125,7 +3135,22 @@ known that the table will be realigned a little later anyway."
>> (while (setq eq (pop eqlname1))
>> (message "Re-applying formula to field: %s" (car eq))
>> (org-goto-line (nth 1 eq))
>> - (org-table-goto-column (nth 2 eq))
>> + (let* ((column-target (nth 2 eq))
>> + (column-count (progn (end-of-line)
>> + (1- (org-table-current-column))))
>> + (create-new-column
>> + (and (> column-target column-count)
>
> Is this check really necessary? Doesn't `org-table-goto-column' already
> figures it out before creating a new column?
This is necessary if we want to be able to warn the user or to prompt
them ONLY if a new column has to be made. I.e. if we're not looking past
the bounds of the table the user should never be pestered. If the
customization variable is only t/nil then this can be dramatically
simplified, as you have observed.
By the way, is (org-display-warning) the preferred way to produce a
warning? It does into a new buffer, not into *Messages*.
Tweaked patch attached.
[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #2: 0001-org-table.el-field-formulas-can-now-create-columns-a.patch --]
[-- Type: text/x-diff, Size: 2479 bytes --]
From 7b3ab8eeffb2047b966c624707766ec29a416583 Mon Sep 17 00:00:00 2001
From: Dima Kogan <dima@secretsauce.net>
Date: Tue, 30 Sep 2014 22:36:21 -0700
Subject: [PATCH] org-table.el: field formulas can now create columns as needed
(org-table-recalculate): use the new org-table-formula-make-new-cols
customization to control whether org creates new columns when a
formula explicitly targets them
TINYCHANGE
---
lisp/org-table.el | 29 ++++++++++++++++++++++++++++-
1 file changed, 28 insertions(+), 1 deletion(-)
diff --git a/lisp/org-table.el b/lisp/org-table.el
index 7607ead..090bb75 100644
--- a/lisp/org-table.el
+++ b/lisp/org-table.el
@@ -354,6 +354,18 @@ portability of tables."
(const :tag "Stick to hline" nil)
(const :tag "Error on attempt to cross" error)))
+(defcustom org-table-formula-create-columns nil
+ "Non-nil means that evaluation of a field formula can add new
+columns if an out-of-bounds field is being set."
+ :group 'org-table-calculation
+ :version "24.5"
+ :package-version '(Org . "8.3")
+ :type '(choice
+ (const :tag "Setting an out-of-bounds field generates an error (default)" nil)
+ (const :tag "Setting an out-of-bounds field silently adds columns as needed" t)
+ (const :tag "Setting an out-of-bounds field adds columns as needed, but issues a warning message" warn)
+ (const :tag "When setting an out-of-bounds field, the user is prompted" prompt)))
+
(defgroup org-table-import-export nil
"Options concerning table import and export in Org-mode."
:tag "Org Table Import Export"
@@ -3125,7 +3137,22 @@ known that the table will be realigned a little later anyway."
(while (setq eq (pop eqlname1))
(message "Re-applying formula to field: %s" (car eq))
(org-goto-line (nth 1 eq))
- (org-table-goto-column (nth 2 eq))
+ (let* ((column-target (nth 2 eq))
+ (column-count (progn (end-of-line)
+ (1- (org-table-current-column))))
+ (create-new-column
+ (and (> column-target column-count)
+ (or (eq org-table-formula-create-columns t)
+ (and
+ (eq org-table-formula-create-columns 'warn)
+ (progn
+ (org-display-warning "Out-of-bounds formula added columns")
+ t))
+ (and
+ (eq org-table-formula-create-columns 'prompt)
+ (yes-or-no-p "Out-of-bounds formula. Add columns?"))))))
+ (org-table-goto-column column-target nil create-new-column))
+
(org-table-eval-formula nil (nth 3 eq) 'noalign 'nocst
'nostore 'noanalysis))
--
2.0.0
next prev parent reply other threads:[~2014-10-01 19:52 UTC|newest]
Thread overview: 19+ messages / expand[flat|nested] mbox.gz Atom feed top
2014-09-29 17:45 Adding new table rows/cols in a formula update Dima Kogan
2014-09-30 19:27 ` Dima Kogan
2014-09-30 19:54 ` Subhan Michael Tindall
2014-10-01 5:44 ` Dima Kogan
2014-10-01 19:38 ` Nicolas Goaziou
2014-10-01 19:38 ` Dima Kogan [this message]
2014-10-01 20:17 ` Nick Dokos
2014-10-03 18:07 ` Dima Kogan
2014-10-10 10:05 ` Nicolas Goaziou
2014-10-10 18:17 ` Dima Kogan
2014-10-11 13:09 ` Bastien
2014-10-11 15:14 ` Nicolas Goaziou
2014-10-11 17:02 ` Dima Kogan
2014-10-12 9:18 ` Nicolas Goaziou
2014-10-12 10:08 ` Bastien
2014-10-12 12:06 ` Nicolas Goaziou
2014-10-12 12:20 ` Bastien
2014-10-13 17:14 ` Achim Gratz
2014-12-08 19:50 ` Achim Gratz
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=87bnpvh8kb.fsf@secretsauce.net \
--to=dima@secretsauce.net \
--cc=emacs-orgmode@gnu.org \
--cc=mail@nicolasgoaziou.fr \
/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).