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…
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…
1
2