Questions tagged [org-table]
30 questions
110
votes
6 answers
Permanently summing a column in an Org-mode table
In an Emacs Org-mode table, when you have a column full of integers I know you can do C-c + followed by C-y to paste the sum of the values in the column. I want to know the formula to place in the last row to always sum the whole column.
I've tried…

Mauvis Ledford
- 40,827
- 17
- 81
- 86
11
votes
1 answer
Calculating Duration in org mode table
I'm trying to figure out how to to use org-mode to calculate the duration between two time points, however, whilst I figured out how to do it for two separate dates, when I add in the time component, it gives an answer, but I'd rather have the…

Nathaniel Saxe
- 1,527
- 2
- 15
- 25
10
votes
1 answer
Giving a table a name in org-mode
I'm taking my first steps in org mode. In the spreadsheet section, they give an example:
$3 = remote(FOO, @@#$2)
Where FOO is another table. However, they don't explain how can I give a name to a table. Does any of you know how to do this?

Yotam
- 10,295
- 30
- 88
- 128
10
votes
3 answers
Converting an org-mode table to LaTeX
IS there a way to 'texify' an ASCII table written with Emacs' orgtabl-mode. Creating tables in this mode is extremely simple.
E.g. suppose I have this table
|------+-----+-----|
| A | B | C |
|------+-----+-----|
| 2.34 | 2.7 | 8.9 |
| 3.67…

smilingbuddha
- 14,334
- 33
- 112
- 189
6
votes
4 answers
Conditionally counting elements in a column in an org-mode spreadsheet
I'm using emacs-calc through org-mode spreadsheet and I would like to count the number of values, in a column, that are greater than a specific value (say 10).
I'm currently using emacs-calc for the computations, but if there is a solution in…

mikael-s
- 310
- 2
- 12
6
votes
2 answers
Table formula for org spreadsheet
I have a table as follow:
| Xn | S | Pn |
| 0 | 0 | 0 |
| 1 | 0 | 1 |
| 0 | 1 | 0 |
| 1 | 1 | 0 |
I would like to search through columns Xn and S and return the value of Pn for which Xn=1 and S=0.
Can anyone advise on how I could go about…

user1185450
- 71
- 1
6
votes
2 answers
A clock table with all items with an effort estimate in Org-mode
In Emacs' Org-mode how do I make a clock table that shows all items that has an Effort estimate not just those that has clocked?
Thanks in advance.
6
votes
1 answer
Orgmode Table Formatting of Cells
I have an Emacs org mode table that looks like this:
|--------------------------------+------------------------------------------------------|
| <20> | <60> |
| How do you…

jmq
- 10,110
- 16
- 58
- 71
5
votes
1 answer
conditional sum(sumif) in org-table
I have a table like this:
#+NAME: ENTRY
|------+--------|
| Item | Amount |
|------+--------|
| A | 100 |
| B | 20 |
| A | 120 |
| C | 40 |
| B | 50 |
| A | 20 |
| C | 16 |
|------+--------|
and then I…

kitsusia
- 65
- 4
4
votes
1 answer
Calculate time range in org-mode table
Given a table that has a column of time ranges e.g.:
| <2015-10-02>--<2015-10-24> |
| <2015-10-05>--<2015-10-20> |
....
how can I create a column showing the results of org-evalute-time-range?
If I attempt something like:
#+TBLFM:…

Metropolis
- 2,018
- 1
- 19
- 36
4
votes
2 answers
Org mode table, show different background on current row, or, alternate even/odd org rows
On wider tables in org mode, it is hard to see the current line.
In emacs org mode table, is there a way to display different background for the current row, or alternate background for even/odd rows?
(I am not concerned with export, although if…

mzimmermann
- 1,002
- 2
- 9
- 14
3
votes
1 answer
Vertical lines in latex using orgtbl in emacs
I am trying to write a document in latex using emacs as an editor and I like being able to use orgtbl-mode to insert and edit tables "ascii art style", but I am annoyed at having to manually change the format of the tabular from {lll} to {|l|l|l|}…

Metareven
- 822
- 2
- 7
- 26
3
votes
1 answer
Pass string argument to a code block from a table in org mode
I'm trying to pass a string as the argument of a code block when using org-mode and org-babel. In particular, I consider the following minimal example:
#+NAME: test
#+BEGIN_SRC python :var x="foobar"
return len(x)
#+END_SRC
| 6 | #ERROR |
#+TBLFM:…

Dror
- 12,174
- 21
- 90
- 160
3
votes
1 answer
Using multiple formulae in one table
I've got a table with multiple floating point rows and I'd like to
round each of them.
+------------+-------------|
| 445.211219 | 1679.315626 |
| 415.789521 | 1566.561511 |
| 435.918622 | 1689.427872 |
+------------+-------------|
| 424.203660 |…

Reactormonk
- 21,472
- 14
- 74
- 123
2
votes
0 answers
Best way to present side-by-side text in Org Mode
I seek a good way to present text side-by-side both in the Org Mode buffer and also in the exported document. Here is an example showing two approaches that I have tried:
#+options: html-postamble:nil
#+options: toc:nil num:nil tags:nil ^:{}
* if…