* Help on spreadsheet/calc references and improvements
@ 2013-10-05 14:49 Karl Voit
2013-10-05 15:16 ` Michael Brand
2013-10-06 11:30 ` Karl Voit
0 siblings, 2 replies; 23+ messages in thread
From: Karl Voit @ 2013-10-05 14:49 UTC (permalink / raw)
To: emacs-orgmode
Hi!
I am no expert with calc. I enjoy using it for rather
simple things. However, I would like to use referencing more often
and I face an issue here.
Additionally, I got the feeling that some formulas could be improved
as well.
I did a very basic example in two ways: vertical layout and
horizontal layout. The reason for this is, that I got the feeling
that referencing a set of values (not a single cell) differs in
capabilities from rows to columns.
- possible improvements
- remote reference to multiple cells
- only one formula for summing up the columns or rows
- simpler referencing in general?
Headings ending with a plus sign are rows/columns that ought to be
entered manually (as a basis). Others should get calculated or
filled using references. I hope the example is self-explanatory.
Names ending with "-WIST" are tables I would like to get using
formulas. Names ending with "-TRY" are draft versions that
demonstrate referencing issues. Further TBLFM below the TRY versions
contain other attempts.
Feel free to make suggestions how to overcome my lack of knowledge
:-)
Thanks!
#+NAME: Data23vert
| Descr+ | Data1+ | Data2+ |
|--------+--------+--------|
| foo | 12 | 10 |
| bar | 22 | 24 |
| baz | 16 | 17 |
|--------+--------+--------|
| sum | 50 | 51 |
#+NAME: Calc23vert-WISH
| Descr | Data2 | Double |
|-------+-------+---------|
| foo | 10 | 20 |
| bar | 24 | 48 |
| baz | 17 | 34 |
|-------+-------+---------|
| sum | 51 | 102 |
#+TBLFM: FIXXME
#+NAME: Calc23vert-TRY
| Descr | Data2 | Double |
|-------+-------+---------|
| foo | 24 | 48 |
| bar | 24 | 48 |
| baz | 24 | 48 |
|-------+-------+---------|
| sum | 72 | 144 |
#+TBLFM: @I$2..@II$2=subscr(remote(Data23vert, @I$>..@II$>), $#)::@I$3..@II$3=$2*2::@5$2=vsum(@I$2..@II$2)::@5$3=vsum(@I$3..@II$3)
#+TBLFM: @I$2..@II$2 = subscr(remote(Data23vert, @I$>..@II$>), $#)
... results in 24 in each field
(btw, I got the subscr() trick here in the ML but I have to admit
that [1] did not lead to a understanding of it.)
#+TBLFM: @I$2..@II$2 = remote(Data23vert, @I$>..@II$>)
... results in list in each field
#+NAME: Data23horiz
| Descr+ | foo | bar | baz | sum |
|--------+-----+-----+-----+-----|
| Data1+ | 12 | 22 | 16 | 50 |
| Data2+ | 10 | 24 | 17 | 51 |
#+NAME: Calc23horiz-WISH
| Descr | foo | bar | baz | sum |
|---------+-----+-----+-----+-----|
| Data2 | 10 | 24 | 17 | 51 |
| Double | 20 | 48 | 34 | 102 |
#+TBLFM: FIXXME
#+NAME: Calc23horiz-TRY
| Descr | foo | bar | baz | sum |
|---------+--------------+--------------+--------------+-----|
| Data2 | [10, 24, 17] | [10, 24, 17] | [10, 24, 17] | |
| Double | | | | |
#+TBLFM: @2$2..@2$4=remote(Data23horiz, @>$2..@>$4)
#+TBLFM: @2$2..@2$4=subscr(remote(Data23horiz, @>$2..@>$4), $#)
... 24, 17, list -> WTF?
#+TBLFM: @2$2..@2$4=remote(Data23horiz, @>$2..@>$4)
... three identical lists instead of values
1. https://www.gnu.org/software/emacs/manual/html_node/calc/Extracting-Elements.html
--
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-05 14:49 Help on spreadsheet/calc references and improvements Karl Voit
@ 2013-10-05 15:16 ` Michael Brand
2013-10-05 16:08 ` Karl Voit
2013-10-06 11:30 ` Karl Voit
1 sibling, 1 reply; 23+ messages in thread
From: Michael Brand @ 2013-10-05 15:16 UTC (permalink / raw)
To: news1142; +Cc: Org Mode
Hi Karl
On Sat, Oct 5, 2013 at 4:49 PM, Karl Voit <devnull@karl-voit.at> wrote:
> Feel free to make suggestions how to overcome my lack of knowledge
You may want to look at the example "$3 = remote(FOO, @@#$2)" in the
Org manual, then it becomes quite simple.
> #+NAME: Data23vert
> | Descr+ | Data1+ | Data2+ |
> |--------+--------+--------|
> | foo | 12 | 10 |
> | bar | 22 | 24 |
> | baz | 16 | 17 |
> |--------+--------+--------|
> | sum | 50 | 51 |
>
> #+NAME: Calc23vert-WISH
> | Descr | Data2 | Double |
> |-------+-------+---------|
> | foo | 10 | 20 |
> | bar | 24 | 48 |
> | baz | 17 | 34 |
> |-------+-------+---------|
> | sum | 51 | 102 |
> #+TBLFM: FIXXME
#+NAME: Data23vert
| Descr+ | Data1+ | Data2+ |
|--------+--------+--------|
| foo | 12 | 10 |
| bar | 22 | 24 |
| baz | 16 | 17 |
|--------+--------+--------|
| sum | 50 | 51 |
| Descr | Data2 | Double |
|-------+-------+--------|
| foo | 10 | 20 |
| bar | 24 | 48 |
| baz | 17 | 34 |
|-------+-------+--------|
| sum | 51 | 102 |
#+TBLFM: $2 = remote(Data23vert, @@#$3) :: $3 = 2 * remote(Data23vert, @@#$3)
> #+NAME: Data23horiz
> | Descr+ | foo | bar | baz | sum |
> |--------+-----+-----+-----+-----|
> | Data1+ | 12 | 22 | 16 | 50 |
> | Data2+ | 10 | 24 | 17 | 51 |
>
> #+NAME: Calc23horiz-WISH
> | Descr | foo | bar | baz | sum |
> |---------+-----+-----+-----+-----|
> | Data2 | 10 | 24 | 17 | 51 |
> | Double | 20 | 48 | 34 | 102 |
> #+TBLFM: FIXXME
#+NAME: Data23horiz
| Descr+ | foo | bar | baz | sum |
|--------+-----+-----+-----+-----|
| Data1+ | 12 | 22 | 16 | 50 |
| Data2+ | 10 | 24 | 17 | 51 |
| Descr | foo | bar | baz | sum |
|--------+-----+-----+-----+-----|
| Data2 | 10 | 24 | 17 | 51 |
| Double | 20 | 48 | 34 | 102 |
#+TBLFM: @2$2..@2$5 = remote(Data23horiz, @3$$#) :: @3$2..@3$5 = 2 *
remote(Data23horiz, @3$$#)
Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-05 15:16 ` Michael Brand
@ 2013-10-05 16:08 ` Karl Voit
2013-10-05 16:44 ` Michael Brand
0 siblings, 1 reply; 23+ messages in thread
From: Karl Voit @ 2013-10-05 16:08 UTC (permalink / raw)
To: emacs-orgmode
* Michael Brand <michael.ch.brand@gmail.com> wrote:
> Hi Karl
Hi!
> You may want to look at the example "$3 = remote(FOO, @@#$2)" in the
> Org manual, then it becomes quite simple.
:-)
I have to admit that I found @@#$2 in the manual. However, I was not
able to understand its meaning at all :-(
With your example below, I begin to understand it a bit. Thanks!
>> #+NAME: Data23vert
>> | Descr+ | Data1+ | Data2+ |
>> |--------+--------+--------|
>> | foo | 12 | 10 |
>> | bar | 22 | 24 |
>> | baz | 16 | 17 |
>> |--------+--------+--------|
>> | sum | 50 | 51 |
>
>| Descr | Data2 | Double |
>|-------+-------+--------|
>| foo | 10 | 20 |
>| bar | 24 | 48 |
>| baz | 17 | 34 |
>|-------+-------+--------|
>| sum | 51 | 102 |
> #+TBLFM: $2 = remote(Data23vert, @@#$3) :: $3 = 2 * remote(Data23vert, @@#$3)
May I add another example I cannot cope with?
| Descr | Current Data2+ | diff | abs.diff |
|-------+----------------+------+----------|
| foo | 9 | -1 | 1 |
| bar | 20 | -4 | 4 |
| baz | 23 | +6 | 6 |
|-------+----------------+------+----------|
| sum | 52 | | 11 |
$2 are manually entered values to compare Data2 from above. I still
have no idea how to adopt your reference example for $3 and $4.
Would you please help me one more time?
>> #+NAME: Data23horiz
>> | Descr+ | foo | bar | baz | sum |
>> |--------+-----+-----+-----+-----|
>> | Data1+ | 12 | 22 | 16 | 50 |
>> | Data2+ | 10 | 24 | 17 | 51 |
>
>| Descr | foo | bar | baz | sum |
>|--------+-----+-----+-----+-----|
>| Data2 | 10 | 24 | 17 | 51 |
>| Double | 20 | 48 | 34 | 102 |
> #+TBLFM: @2$2..@2$5 = remote(Data23horiz, @3$$#) :: @3$2..@3$5 = 2 *
> remote(Data23horiz, @3$$#)
Helped me a lot, thanks! ("$$#" is not mentioned in the Org-manual at all.)
--
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-05 16:08 ` Karl Voit
@ 2013-10-05 16:44 ` Michael Brand
0 siblings, 0 replies; 23+ messages in thread
From: Michael Brand @ 2013-10-05 16:44 UTC (permalink / raw)
To: news1142; +Cc: Org Mode
Hi Karl
On Sat, Oct 5, 2013 at 6:08 PM, Karl Voit <devnull@karl-voit.at> wrote:
> | Descr | Current Data2+ | diff | abs.diff |
> |-------+----------------+------+----------|
> | foo | 9 | -1 | 1 |
> | bar | 20 | -4 | 4 |
> | baz | 23 | +6 | 6 |
> |-------+----------------+------+----------|
> | sum | 52 | | 11 |
>
> $2 are manually entered values to compare Data2 from above. I still
> have no idea how to adopt your reference example for $3 and $4.
> Would you please help me one more time?
Here you are:
#+NAME: Data23vert
| Descr+ | Data1+ | Data2+ |
|--------+--------+--------|
| foo | 12 | 10 |
| bar | 22 | 24 |
| baz | 16 | 17 |
|--------+--------+--------|
| sum | 50 | 51 |
| Descr | Current Data2+ | diff | abs.diff |
|-------+----------------+------+----------|
| foo | 9 | -1 | 1 |
| bar | 20 | -4 | 4 |
| baz | 23 | 6 | 6 |
|-------+----------------+------+----------|
| sum | 52 | | 11 |
#+TBLFM: $3 = $2 - remote(Data23vert, @@#$3) :: $4 = abs($3) :: @5$3 =
string("") :: @5$4 = vsum(@I..@II)
Or use
$4 = abs($2 - remote(Data23vert, @@#$3))
if you prefer.
Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-05 14:49 Help on spreadsheet/calc references and improvements Karl Voit
2013-10-05 15:16 ` Michael Brand
@ 2013-10-06 11:30 ` Karl Voit
2013-10-06 17:03 ` Michael Brand
1 sibling, 1 reply; 23+ messages in thread
From: Karl Voit @ 2013-10-06 11:30 UTC (permalink / raw)
To: emacs-orgmode
* Karl Voit <devnull@Karl-Voit.at> wrote:
>
> I am no expert with calc. I enjoy using it for rather
> simple things. However, I would like to use referencing more often
> and I face an issue here.
>
> I did a very basic example in two ways: vertical layout and
> horizontal layout. The reason for this is, that I got the feeling
> that referencing a set of values (not a single cell) differs in
> capabilities from rows to columns.
I could solve all of my issues with the kind help of Michael.
The things I learned about referencing other tables I documented in [1].
Maybe you'll find it handy as a reference to referencing tables :-)
1. https://raw.github.com/novoid/org-mode-workshop/master/featureshow/org-mode-teaser.org
search for "referencing example with detailed explanation"
--
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-06 11:30 ` Karl Voit
@ 2013-10-06 17:03 ` Michael Brand
2013-10-06 18:31 ` Karl Voit
2013-10-18 19:07 ` Michael Brand
0 siblings, 2 replies; 23+ messages in thread
From: Michael Brand @ 2013-10-06 17:03 UTC (permalink / raw)
To: news1142, Org Mode
[-- Attachment #1: Type: text/plain, Size: 1241 bytes --]
Hi Karl, hi all
@maintainers:
According to the below I tried to improve the Org manual with the
attached patch, please review and apply.
On Sun, Oct 6, 2013 at 1:30 PM, Karl Voit <devnull@karl-voit.at> wrote:
> The things I learned about referencing other tables I documented in [1].
>
> Maybe you'll find it handy as a reference to referencing tables :-)
>
> 1. https://raw.github.com/novoid/org-mode-workshop/master/featureshow/org-mode-teaser.org
> search for "referencing example with detailed explanation"
Yes, with all the explanations of how the formulas work your github
novoid/org-mode-workshop contains a very nice spreadsheet
documentation, for more than just referencing remote tables. Can you
please link the section here with mentioning that it contains
explanations of how the formulas work?:
http://orgmode.org/worg/org-tutorials/index.html
Your new example in github novoid/org-mode-workshop with
@2=remote(Income2012h, @3$$#)
- motivated by my example in the current Org manual
- that interprets text as a Calc algebraic expression, which is
subject to reformatting
reminded me of that just copying fields is better done with a Lisp
formula "'(identity [...])", see attached patch for the Org manual.
Michael
[-- Attachment #2: 0001-Improve-manual-for-table-formulas.patch.txt --]
[-- Type: text/plain, Size: 2626 bytes --]
From a3efc3edd94ccc21544792ddde4a6c54284100ce Mon Sep 17 00:00:00 2001
From: Michael Brand <michael.ch.brand@gmail.com>
Date: Sun, 6 Oct 2013 19:01:15 +0200
Subject: [PATCH] Improve manual for table formulas
* doc/org.texi (Field coordinates in formulas): Rephrase and add an
example with a Lisp formula to copy from remote table.
---
doc/org.texi | 33 ++++++++++++++++++++-------------
1 file changed, 20 insertions(+), 13 deletions(-)
diff --git a/doc/org.texi b/doc/org.texi
index 0271d70..0a90d33 100644
--- a/doc/org.texi
+++ b/doc/org.texi
@@ -2551,21 +2551,28 @@ for Calc}.
@cindex row, of field coordinates
@cindex column, of field coordinates
-For Calc formulas and Lisp formulas @code{@@#} and @code{$#} can be used to
-get the row or column number of the field where the formula result goes.
-The traditional Lisp formula equivalents are @code{org-table-current-dline}
-and @code{org-table-current-column}. Examples:
+One of the very first actions during evaluation of Calc formulas and Lisp
+formulas is to substitute @code{@@#} and @code{$#} in the formula with the
+row or column number of the field where the current result will go to. The
+traditional Lisp formula equivalents are @code{org-table-current-dline} and
+@code{org-table-current-column}. Examples:
-@example
-if(@@# % 2, $#, string("")) @r{column number on odd lines only}
-$3 = remote(FOO, @@@@#$2) @r{copy column 2 from table FOO into}
- @r{column 3 of the current table}
-@end example
+@table @code
+@item if(@@# % 2, $#, string(""))
+Insert column number on odd rows, set field to empty on even rows.
+@item $2 = '(identity remote(FOO, @@@@#$1))
+Copy text or values of each row of column 1 of the table named @code{FOO}
+into column 2 of the current table.
+@item @@3 = 2 * remote(FOO, @@1$$#)
+Insert the doubled value of each column of row 1 of the table named
+@code{FOO} into row 3 of the current table.
+@end table
-@noindent For the second example, table FOO must have at least as many rows
-as the current table. Note that this is inefficient@footnote{The computation time scales as
-O(N^2) because table FOO is parsed for each field to be copied.} for large
-number of rows.
+@noindent For the second/third example, the table named @code{FOO} must have
+at least as many rows/columns as the current table. Note that this is
+inefficient@footnote{The computation time scales as O(N^2) because the table
+named @code{FOO} is parsed for each field to be read.} for large number of
+rows/columns.
@subsubheading Named references
@cindex named references
--
1.7.12.4 (Apple Git-37)
^ permalink raw reply related [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-06 17:03 ` Michael Brand
@ 2013-10-06 18:31 ` Karl Voit
2013-10-06 19:38 ` Michael Brand
2013-10-18 19:07 ` Michael Brand
1 sibling, 1 reply; 23+ messages in thread
From: Karl Voit @ 2013-10-06 18:31 UTC (permalink / raw)
To: emacs-orgmode
* Michael Brand <michael.ch.brand@gmail.com> wrote:
>
> Hi Karl, hi all
Hi Michael!
> Yes, with all the explanations of how the formulas work your github
> novoid/org-mode-workshop contains a very nice spreadsheet
> documentation, for more than just referencing remote tables. Can you
> please link the section here with mentioning that it contains
> explanations of how the formulas work?:
> http://orgmode.org/worg/org-tutorials/index.html
It is already linked with "Org-mode Workshop by Karl Voit, conducted
at Graz University of Technology in November 2012 (3x4 hours). It
includes a newer version of the feature-show from the entry above.".
I mentioned only the "feature-show" since it is a much wider range
than spreadsheet only.
--
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-06 18:31 ` Karl Voit
@ 2013-10-06 19:38 ` Michael Brand
2013-10-06 20:06 ` Karl Voit
0 siblings, 1 reply; 23+ messages in thread
From: Michael Brand @ 2013-10-06 19:38 UTC (permalink / raw)
To: news1142; +Cc: Org Mode
[-- Attachment #1: Type: text/plain, Size: 1215 bytes --]
Hi Karl
On Sun, Oct 6, 2013 at 8:31 PM, Karl Voit <devnull@karl-voit.at> wrote:
> * Michael Brand <michael.ch.brand@gmail.com> wrote:
>> Yes, with all the explanations of how the formulas work your github
>> novoid/org-mode-workshop contains a very nice spreadsheet
>> documentation, for more than just referencing remote tables. Can you
>> please link the section here with mentioning that it contains
>> explanations of how the formulas work?:
>> http://orgmode.org/worg/org-tutorials/index.html
>
> It is already linked with "Org-mode Workshop by Karl Voit, conducted
> at Graz University of Technology in November 2012 (3x4 hours). It
> includes a newer version of the feature-show from the entry above.".
>
> I mentioned only the "feature-show" since it is a much wider range
> than spreadsheet only.
Yes. but someone looking around only in the Worg tutorial section
"Tables, Spreadsheet, Plotting" will not find it and also from the
link above the content I would like to point to is not to be expected
and is still a long way to go: two clicks on the right links and
browse to the right section. What I had in mind is something like the
attached patch for Worg as a suggestion. What do you think?
Michael
[-- Attachment #2: 0001-More-links-in-tutorials-for-tables.patch.txt --]
[-- Type: text/plain, Size: 2922 bytes --]
From ca580793cb4ac7cc46342b3416527ebbb9ea60d8 Mon Sep 17 00:00:00 2001
From: Michael Brand <michael.ch.brand@gmail.com>
Date: Sun, 6 Oct 2013 21:35:50 +0200
Subject: [PATCH] More links in tutorials for tables
---
org-hacks.org | 4 ++++
org-tutorials/index.org | 15 ++++++++++++++-
2 files changed, 18 insertions(+), 1 deletion(-)
diff --git a/org-hacks.org b/org-hacks.org
index cb0c66c..3679757 100644
--- a/org-hacks.org
+++ b/org-hacks.org
@@ -571,6 +571,10 @@ equivalent function after =C-c ^ f=, use this one instead:
*** Adding Licenses to org files
You can add pretty standard licenses, such as creative commons or gfdl to org articles using [[file:code/elisp/org-license.el][org-license.el]].
** Org Table
+ :PROPERTIES:
+ :CUSTOM_ID: Tables
+ :END:
+
*** Align all tables in a file
Andrew Young provided this function in [[http://thread.gmane.org/gmane.emacs.orgmode/58974/focus%3D58976][this thread]]:
diff --git a/org-tutorials/index.org b/org-tutorials/index.org
index 6e5195c..edc4f12 100644
--- a/org-tutorials/index.org
+++ b/org-tutorials/index.org
@@ -108,7 +108,7 @@
- A short [[http://lumiere.ens.fr/~guerry/org-playing-with-lists-screencast.html][screencast]] presenting a few features of plain lists, by
Bastien.
-** Tables, Spreadseet, Plotting
+** Tables, Spreadsheet, Plotting
- [[file:tables.org][A very short introduction to tables in Org-mode]], by Bastien.
@@ -117,6 +117,9 @@
- [[file:org-spreadsheet-lisp-formulas.org][Using Emacs lisp for spreadsheet formulas]] ([[file:org-tableur-tutoriel.org][french version]]), by Bastien.
+- [[https://github.com/novoid/org-mode-workshop/blob/master/featureshow/org-mode-teaser.org#1131-referencing-example-with-detailed-explanation][Various spreadsheet formulas with explanations how they work]]
+ by Karl Voit.
+
- [[file:org-plot.org][Plotting tables in Org-Mode using org-plot]] by Eric Schulte
- [[file:org-dot-diagrams.org][Plotting process diagrams or work flows in Org-Mode using dot]] by Karl Voit
@@ -131,6 +134,16 @@
- [[file:org-lookups.org][Table lookup functions]] by Jarmo Hurri
+- The following are not tutorials but listed here somehow for
+ "completeness" of the information sources to be checked too:
+ - [[http://orgmode.org/manual/The-spreadsheet.html][Org manual, section about spreadsheet]]
+
+ - [[http://orgmode.org/worg/org-faq.html#Tables][Worg FAQ, section about tables]]
+
+ - [[http://orgmode.org/worg/org-hacks.html#Tables][Worg hacks, section about tables]]
+
+ - [[http://orgmode.org/w/org-mode.git?p=org-mode.git;a=blob;f=testing/lisp/test-org-table.el;hb=HEAD][most of the automated Emacs Regression Tests (ERT) for Org tables]]
+
** Dates and Times
- [[http://members.optusnet.com.au/~charles57/GTD/org_dates/][Using Dates and Times in Emacs Org-mode]] by [[http://members.optusnet.com.au/~charles57/GTD/][Charles Cave]].
--
1.7.12.4 (Apple Git-37)
^ permalink raw reply related [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-06 19:38 ` Michael Brand
@ 2013-10-06 20:06 ` Karl Voit
2013-10-06 20:51 ` Michael Brand
0 siblings, 1 reply; 23+ messages in thread
From: Karl Voit @ 2013-10-06 20:06 UTC (permalink / raw)
To: emacs-orgmode
Hi!
* Michael Brand <michael.ch.brand@gmail.com> wrote:
>
> On Sun, Oct 6, 2013 at 8:31 PM, Karl Voit <devnull@karl-voit.at> wrote:
>>
>> I mentioned only the "feature-show" since it is a much wider range
>> than spreadsheet only.
>
> Yes. but someone looking around only in the Worg tutorial section
> "Tables, Spreadsheet, Plotting" will not find it and also from the
> link above the content I would like to point to is not to be expected
> and is still a long way to go: two clicks on the right links and
> browse to the right section. What I had in mind is something like the
> attached patch for Worg as a suggestion. What do you think?
You are absolutely right.
Please do apply the patch!
PS: Good to know that Org-mode headings could be referenced via HTML
anchors on Github :-)
--
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-06 20:06 ` Karl Voit
@ 2013-10-06 20:51 ` Michael Brand
0 siblings, 0 replies; 23+ messages in thread
From: Michael Brand @ 2013-10-06 20:51 UTC (permalink / raw)
To: news1142; +Cc: Org Mode
Hi Karl
On Sun, Oct 6, 2013 at 10:06 PM, Karl Voit <devnull@karl-voit.at> wrote:
> Please do apply the patch!
Done.
Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-06 17:03 ` Michael Brand
2013-10-06 18:31 ` Karl Voit
@ 2013-10-18 19:07 ` Michael Brand
2013-10-23 15:12 ` Michael Brand
1 sibling, 1 reply; 23+ messages in thread
From: Michael Brand @ 2013-10-18 19:07 UTC (permalink / raw)
To: Org Mode; +Cc: news1142
Hi all
On Sun, Oct 6, 2013 at 7:03 PM, Michael Brand
<michael.ch.brand@gmail.com> wrote:
> @maintainers:
> According to the below I tried to improve the Org manual with the
> attached patch, please review and apply.
I would like to remind to review and apply the patch attached on
[2013-10-06 Sun] to this thread
(0001-Improve-manual-for-table-formulas.patch.txt).
Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-18 19:07 ` Michael Brand
@ 2013-10-23 15:12 ` Michael Brand
2013-10-24 6:18 ` Carsten Dominik
0 siblings, 1 reply; 23+ messages in thread
From: Michael Brand @ 2013-10-23 15:12 UTC (permalink / raw)
To: Carsten Dominik, Bastien, Nicolas Goaziou; +Cc: news1142, Org Mode
Hi Carsten, Bastien and Nicolas
On Fri, Oct 18, 2013 at 9:07 PM, Michael Brand
<michael.ch.brand@gmail.com> wrote:
> On Sun, Oct 6, 2013 at 7:03 PM, Michael Brand> <michael.ch.brand@gmail.com> wrote:
>> @maintainers:
>> According to the below I tried to improve the Org manual with the
>> attached patch, please review and apply.
>
> I would like to remind to review and apply the patch attached on
> [2013-10-06 Sun] to this thread
> (0001-Improve-manual-for-table-formulas.patch.txt).
I would like to remind to review and apply the patch attached on
[2013-10-06 Sun] to this thread
(0001-Improve-manual-for-table-formulas.patch.txt).
Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-23 15:12 ` Michael Brand
@ 2013-10-24 6:18 ` Carsten Dominik
2013-10-24 20:47 ` Michael Brand
0 siblings, 1 reply; 23+ messages in thread
From: Carsten Dominik @ 2013-10-24 6:18 UTC (permalink / raw)
To: Michael Brand; +Cc: Bastien, news1142, Org Mode, Nicolas Goaziou
Applied, thanks.
Michael, would you like to have write access to the git repo?
- Carsten
On 23.10.2013, at 17:12, Michael Brand <michael.ch.brand@gmail.com> wrote:
> Hi Carsten, Bastien and Nicolas
>
> On Fri, Oct 18, 2013 at 9:07 PM, Michael Brand
> <michael.ch.brand@gmail.com> wrote:
>> On Sun, Oct 6, 2013 at 7:03 PM, Michael Brand> <michael.ch.brand@gmail.com> wrote:
>>> @maintainers:
>>> According to the below I tried to improve the Org manual with the
>>> attached patch, please review and apply.
>>
>> I would like to remind to review and apply the patch attached on
>> [2013-10-06 Sun] to this thread
>> (0001-Improve-manual-for-table-formulas.patch.txt).
>
> I would like to remind to review and apply the patch attached on
> [2013-10-06 Sun] to this thread
> (0001-Improve-manual-for-table-formulas.patch.txt).
>
> Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-24 6:18 ` Carsten Dominik
@ 2013-10-24 20:47 ` Michael Brand
2013-10-25 10:56 ` Nicolas Goaziou
2013-10-25 13:31 ` Carsten Dominik
0 siblings, 2 replies; 23+ messages in thread
From: Michael Brand @ 2013-10-24 20:47 UTC (permalink / raw)
To: Carsten Dominik; +Cc: Bastien, Org Mode, Nicolas Goaziou
Hi Carsten
On Thu, Oct 24, 2013 at 8:18 AM, Carsten Dominik
<carsten.dominik@gmail.com> wrote:
> Applied, thanks.
I can not see the commit, is it pushed?
> Michael, would you like to have write access to the git repo?
Thank you for the trust. As I would like anyway to have a review of my
patches before commit, I think it would not help when I would do the
commit myself. I hope that it is still ok when I prefer a review,
independent of the simplicity of the patch.
Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-24 20:47 ` Michael Brand
@ 2013-10-25 10:56 ` Nicolas Goaziou
2013-10-25 13:30 ` Carsten Dominik
2013-10-25 13:31 ` Carsten Dominik
1 sibling, 1 reply; 23+ messages in thread
From: Nicolas Goaziou @ 2013-10-25 10:56 UTC (permalink / raw)
To: Michael Brand; +Cc: Bastien, Org Mode, Carsten Dominik
Hello,
Michael Brand <michael.ch.brand@gmail.com> writes:
> Thank you for the trust. As I would like anyway to have a review of my
> patches before commit, I think it would not help when I would do the
> commit myself. I hope that it is still ok when I prefer a review,
> independent of the simplicity of the patch.
You can have an access and get your code (sometimes) reviewed if you
post it on the ML: having write access doesn't mean you're on your own.
BTW, I think there is some room for improvement in that area among Org
developers.
Regards,
--
Nicolas Goaziou
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-25 10:56 ` Nicolas Goaziou
@ 2013-10-25 13:30 ` Carsten Dominik
2013-10-25 17:03 ` Nicolas Goaziou
0 siblings, 1 reply; 23+ messages in thread
From: Carsten Dominik @ 2013-10-25 13:30 UTC (permalink / raw)
To: Nicolas Goaziou; +Cc: Bastien, Michael Brand, Org Mode
On 25.10.2013, at 12:56, Nicolas Goaziou <n.goaziou@gmail.com> wrote:
> Hello,
>
> Michael Brand <michael.ch.brand@gmail.com> writes:
>
>> Thank you for the trust. As I would like anyway to have a review of my
>> patches before commit, I think it would not help when I would do the
>> commit myself. I hope that it is still ok when I prefer a review,
>> independent of the simplicity of the patch.
>
> You can have an access and get your code (sometimes) reviewed if you
> post it on the ML: having write access doesn't mean you're on your own.
>
> BTW, I think there is some room for improvement in that area among Org
> developers.
Hi Nicolas,
what exactly do you mean?
- Carsten
>
>
> Regards,
>
> --
> Nicolas Goaziou
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-24 20:47 ` Michael Brand
2013-10-25 10:56 ` Nicolas Goaziou
@ 2013-10-25 13:31 ` Carsten Dominik
2013-10-30 17:59 ` Michael Brand
1 sibling, 1 reply; 23+ messages in thread
From: Carsten Dominik @ 2013-10-25 13:31 UTC (permalink / raw)
To: Michael Brand; +Cc: Bastien, Org Mode, Nicolas Goaziou
On 24.10.2013, at 22:47, Michael Brand <michael.ch.brand@gmail.com> wrote:
> Hi Carsten
>
> On Thu, Oct 24, 2013 at 8:18 AM, Carsten Dominik
> <carsten.dominik@gmail.com> wrote:
>> Applied, thanks.
>
> I can not see the commit, is it pushed?
>
>> Michael, would you like to have write access to the git repo?
>
> Thank you for the trust. As I would like anyway to have a review of my
> patches before commit, I think it would not help when I would do the
> commit myself. I hope that it is still ok when I prefer a review,
> independent of the simplicity of the patch.
Yes, reviews are always good! But with write access you can still
install a patch yourself after a review, or make small doc fixes
without review etc.
- Carsten
>
> Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-25 13:30 ` Carsten Dominik
@ 2013-10-25 17:03 ` Nicolas Goaziou
0 siblings, 0 replies; 23+ messages in thread
From: Nicolas Goaziou @ 2013-10-25 17:03 UTC (permalink / raw)
To: Carsten Dominik; +Cc: Bastien, Michael Brand, Org Mode
Hello,
Carsten Dominik <carsten.dominik@gmail.com> writes:
> what exactly do you mean?
I mean that we do not always submit our patches on the ML first, so
others can review them. Sometimes we do, but this is not systematic.
I think this is a cultural thing among communities. When it is the norm,
it can lead to better code and more people knowing more parts of the
code.
I don't know if it is applicable to our community, but it could be worth
trying.
Regards,
--
Nicolas Goaziou
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-25 13:31 ` Carsten Dominik
@ 2013-10-30 17:59 ` Michael Brand
2013-11-13 17:27 ` Michael Brand
0 siblings, 1 reply; 23+ messages in thread
From: Michael Brand @ 2013-10-30 17:59 UTC (permalink / raw)
To: Carsten Dominik; +Cc: Bastien, Org Mode, Nicolas Goaziou
Hi Carsten
On Fri, Oct 25, 2013 at 3:31 PM, Carsten Dominik
<carsten.dominik@gmail.com> wrote:
> On 24.10.2013, at 22:47, Michael Brand <michael.ch.brand@gmail.com> wrote:
>> On Thu, Oct 24, 2013 at 8:18 AM, Carsten Dominik
>> <carsten.dominik@gmail.com> wrote:
>>> Applied, thanks.
>>
>> I can not see the commit, is it pushed?
>>
>>> Michael, would you like to have write access to the git repo?
>>
>> Thank you for the trust. As I would like anyway to have a review of my
>> patches before commit, I think it would not help when I would do the
>> commit myself. I hope that it is still ok when I prefer a review,
>> independent of the simplicity of the patch.
>
> Yes, reviews are always good! But with write access you can still
> install a patch yourself after a review, or make small doc fixes
> without review etc.
Hi Carsten
Ok, I see that it would help when I "git push" those of my simple
changes that maybe don't need a review by a maintainer at any price to
the master branch myself. I already have write access to Worg, do you
still need my public key?
My question about the whereabouts of my patch
0001-Improve-manual-for-table-formulas.patch.txt that is already
"applied" has been overlooked and if I understand correct it is in
your repo but not yet in the main repo. Since the main repo changed
meanwhile, I assume it will create push conflicts on your side. If
this is correct then please get rid of the patch in your repo and I
will take care of the rest.
Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-10-30 17:59 ` Michael Brand
@ 2013-11-13 17:27 ` Michael Brand
2013-11-13 17:34 ` Bastien
0 siblings, 1 reply; 23+ messages in thread
From: Michael Brand @ 2013-11-13 17:27 UTC (permalink / raw)
To: Carsten Dominik; +Cc: Jason Dunsmore, Org Mode
Hi Carsten
On Wed, Oct 30, 2013 at 6:59 PM, Michael Brand
<michael.ch.brand@gmail.com> wrote:
> On Fri, Oct 25, 2013 at 3:31 PM, Carsten Dominik
> <carsten.dominik@gmail.com> wrote:
>> On 24.10.2013, at 22:47, Michael Brand <michael.ch.brand@gmail.com> wrote:
>>> On Thu, Oct 24, 2013 at 8:18 AM, Carsten Dominik
>>> <carsten.dominik@gmail.com> wrote:
>>>> Michael, would you like to have write access to the git repo?
>>>
>>> Thank you for the trust. As I would like anyway to have a review of my
>>> patches before commit, I think it would not help when I would do the
>>> commit myself. I hope that it is still ok when I prefer a review,
>>> independent of the simplicity of the patch.
>>
>> Yes, reviews are always good! But with write access you can still
>> install a patch yourself after a review, or make small doc fixes
>> without review etc.
>
> Ok, I see that it would help when I "git push" those of my simple
> changes that maybe don't need a review by a maintainer at any price to
> the master branch myself. I already have write access to Worg, do you
> still need my public key?
The last paragraph has not been answered yet. Can I ask Jason Dunsmore
directly to give me write access to Org?
Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-11-13 17:27 ` Michael Brand
@ 2013-11-13 17:34 ` Bastien
2013-11-13 19:42 ` Michael Brand
0 siblings, 1 reply; 23+ messages in thread
From: Bastien @ 2013-11-13 17:34 UTC (permalink / raw)
To: Michael Brand; +Cc: Jason Dunsmore, Org Mode, Carsten Dominik
Hi Michael,
Michael Brand <michael.ch.brand@gmail.com> writes:
> The last paragraph has not been answered yet. Can I ask Jason Dunsmore
> directly to give me write access to Org?
Please send me your public key and I'll give you write access.
Thanks!
--
Bastien
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-11-13 17:34 ` Bastien
@ 2013-11-13 19:42 ` Michael Brand
2013-11-13 23:21 ` Bastien
0 siblings, 1 reply; 23+ messages in thread
From: Michael Brand @ 2013-11-13 19:42 UTC (permalink / raw)
To: Bastien; +Cc: Org Mode, Carsten Dominik
Hi Bastien
On Wed, Nov 13, 2013 at 6:34 PM, Bastien <bzg@gnu.org> wrote:
> Please send me your public key and I'll give you write access.
It works, thank you. I have pushed my patch myself now. When and how often is
http://orgmode.org/manual/References.html
updated?
Michael
^ permalink raw reply [flat|nested] 23+ messages in thread
* Re: Help on spreadsheet/calc references and improvements
2013-11-13 19:42 ` Michael Brand
@ 2013-11-13 23:21 ` Bastien
0 siblings, 0 replies; 23+ messages in thread
From: Bastien @ 2013-11-13 23:21 UTC (permalink / raw)
To: Michael Brand; +Cc: Org Mode, Carsten Dominik
Hi Michael,
Michael Brand <michael.ch.brand@gmail.com> writes:
> On Wed, Nov 13, 2013 at 6:34 PM, Bastien <bzg@gnu.org> wrote:
>> Please send me your public key and I'll give you write access.
>
> It works, thank you. I have pushed my patch myself now.
Thanks.
> When and how often is
> http://orgmode.org/manual/References.html
> updated?
It's updated when a new minor or major release is done.
--
Bastien
^ permalink raw reply [flat|nested] 23+ messages in thread
end of thread, other threads:[~2013-11-13 23:21 UTC | newest]
Thread overview: 23+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2013-10-05 14:49 Help on spreadsheet/calc references and improvements Karl Voit
2013-10-05 15:16 ` Michael Brand
2013-10-05 16:08 ` Karl Voit
2013-10-05 16:44 ` Michael Brand
2013-10-06 11:30 ` Karl Voit
2013-10-06 17:03 ` Michael Brand
2013-10-06 18:31 ` Karl Voit
2013-10-06 19:38 ` Michael Brand
2013-10-06 20:06 ` Karl Voit
2013-10-06 20:51 ` Michael Brand
2013-10-18 19:07 ` Michael Brand
2013-10-23 15:12 ` Michael Brand
2013-10-24 6:18 ` Carsten Dominik
2013-10-24 20:47 ` Michael Brand
2013-10-25 10:56 ` Nicolas Goaziou
2013-10-25 13:30 ` Carsten Dominik
2013-10-25 17:03 ` Nicolas Goaziou
2013-10-25 13:31 ` Carsten Dominik
2013-10-30 17:59 ` Michael Brand
2013-11-13 17:27 ` Michael Brand
2013-11-13 17:34 ` Bastien
2013-11-13 19:42 ` Michael Brand
2013-11-13 23:21 ` Bastien
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).