Questions tagged [org-table]

for questions about Org mode's ASCII table editor. Use this tag for its spreadsheet calculations and plotting features as well.

Filter by
Sorted by
Tagged with
3
votes
1answer
177 views

Is possible to have alternate table rows in another color in org-mode tables?

I would want something like this, for some specific tables with many rows (so columns are easier to read): I know about stripes mode (and sometimes I resort to using it), but that changes format for ...
1
vote
1answer
137 views

Naming the result of a source block

The following question has been asked (in slightly different form) in a comment of another answer: Is it possible to name the results of a source block with #+NAME: foobar (or equivalently but old-...
1
vote
2answers
132 views

Ipython code block producing org table

I saw a python code block example to output an array as an org-table. An example would be, #+BEGIN_SRC python :results value r = 3389.5 # km average radius re = 3396.2 # equatorial radius in km ...
0
votes
1answer
79 views

org-table: add hline based on change in column values

Given the following org-table: | col1 | col2 | col3 | col4 | |------+------+------+------| | 11 | 12 | A | 14 | | 21 | 22 | A | 24 | | 31 | 32 | A | 34 | | 41 | 42 | B ...
0
votes
2answers
108 views

Matching two columns in a table

I deal with a two column table where I have to match data from two sources. The first column contains names of persons for whom, service is provided. The second, persons who are billed. My job is to ...
1
vote
1answer
150 views

Using an org-table formula to sum up weekly time cards

I'm filling my time cards in an org-table like below. Is there a way to fill the column Totals automatically with a formula? For the individual lines in a project task, I'd like to sum the hours ...
6
votes
2answers
421 views

How to copy org-table to postgresql database?

With sqlite one can easily populate a table in a database via a org-table like so: [EDIT](using only one sqlite-scr-block with org-table variable parameter)[/EDIT] #+NAME: A | val1 | val2 | |------+...
0
votes
1answer
234 views

How do I display current cell address of an org-mode table?

I am trying to write some formulas in my tables and having a bit of a hard time figuring out the current cell's address (@row:$col). It would be awesome if I could display the cell location in the ...
2
votes
1answer
156 views

Convert an org table into a tree

I have an org table and I will like to convert in into a tree. So, from: | 1 | 2 | 3 | |---+---+---| | a | b | c | | l | m | n | I will like to go to: * a :PROPERTIES: :2: b :3: ...
1
vote
1answer
198 views

org-mode table row operations

Is it possible to do row operations of the following form in org-mode? | x1 | x2 | x3 | x4 | z1 | z2 | b | |-----+-----+-----+----+----+----+---| | 2 | 1 | -7 | -1 | 1 | 0 | 0 | | -39 | -7 ...
1
vote
0answers
107 views

Org mode - Copy cells from a remote org-table with shifted columns

I want to copy the values of a shifted range of cells from a remote table. Example: #+NAME: TBL1 | 1 | 2 | 3 | 4 | | | | | | #+NAME: TBL2 | | 5 | 6 | 7 | 8 | | | | | | | The ...
9
votes
1answer
2k views

Org tables: Wrap all fields in column to a given size

In org it is possible to set a column width like follows: |---+------------------------------| |---+----------------| | | | | | <14>...
0
votes
1answer
46 views

How to paste text into an org table with a set number of columns?

I usually have a bulk of items separated by either spaces or new lines and I want to have them all full a table with a set number of columns. Basically if I want the table to always have 3 columns, ...
1
vote
1answer
716 views

Calculating with timestamps in org-mode tables

Emacs 26.1 | | Start date | End date | State | Task | Duration (hours) | |---+------------------------+------------------------+-------+----------+------------------| |...
18
votes
3answers
12k views

Wrap cell content in an org mode table

I have a table like this: | Verse No | Verse | | | <10> | | 1 | line1 li=> | | 2 | line2 li=> | I would like to view it as | Verse No | Verse | | ...
1
vote
1answer
56 views

How do I reference a columnview table

I'm trying to get effort estimates out of a columnview table and do some math on it in a separate table. #+TBLNAME: estimate #+BEGIN: columnview :indent t | ITEM | TODO | Effort | ...
1
vote
2answers
103 views

Rotate the yanking ring

I have such a table | C | M | |---------------------+---------------------| | Character | Word | |---------------------+----------...
0
votes
1answer
106 views

Sum columns duration/days and duration/hours

In my org file I have the table: | | Start date | End date | State | Task | Duration/days | Duration (hours) | |---+------------------------+------------------------+--...
1
vote
2answers
603 views

org mode table formatting problem

I'm on Windows 7 using emacs version GNU Emacs 24.5.1 (i686-pc-mingw32) of 2015-04-11 on LEG570. When I create tables with org-mode, I end up having something like this. . I searched and found ...
5
votes
1answer
3k views

Using File Local Variables in org-mode

Is there a way to use file local variables set in an org-mode file in the following contexts: Simply expanding the variable when text is exported (eg: to LaTeX) Passing the value to :var in a babel ...
17
votes
4answers
3k views

Can I format cells in an org-mode table differently depending on a formula?

I have a column in an org-mode table with numbers in each cell. I'd like to change the background color of the cell to red if the number is below 1 or above 2. How can I do that?
6
votes
1answer
543 views

Table cell alignment breaks when using latex inside org table

Let's assume we have a table that looks like this: After running org-preview-latex-fragment command I get this: As you can see the top row is not aligned with the other rows. How can one view ...
3
votes
1answer
263 views

Org table: Calculate units

Are Org tables able to calcultate units? Say I have a table | test | Voltage | DC | Current | Power | |----------+----------+-----+------------+-------------| | DC-motor | 12 V | ...
11
votes
2answers
193 views

Avoid displaying “=>” when a field is clipped in org-table?

How can I avoid displaying "=>" when a field is clipped in org-table? Those arrows dominate some narrow cells, and I can view the full field in a tool-tip window anyway, so I'd like to get rid of them....
1
vote
2answers
303 views

How to move just one value in a table to a different column

Is there a command for moving only the value 11 to the right column in the following column? | Name | | | |------+----+---| | a | 11 | | | b | 10 | | Something like org-table-move-...
3
votes
1answer
773 views

Org capture into org table

Normally org-capture lets one insert a templated subtree somewhere into an existing Org file or tree node. Is it possible to use org-capture to instead add a row to an existing Org-mode table?
0
votes
0answers
38 views

Save .org file from org table edit field buffer

Is there any command to save the org file from the org table edit field buffer? If not, is there any way to check if the current buffer is an org table edit field buffer? More details: When I am ...
2
votes
1answer
355 views

org-table-copy-down for dates

Suppose I have an org-table like this: | 2018-09-09 | | | | | | 2018-09-10 | | | | | | 2018-09-11 | | | | ...
3
votes
1answer
70 views

org table lisp concat semi-colon issue

I am not sure how to describe this problem so I am giving some example Without Semi-colon | John | Snow | John Snow | | John | Doe | John Doe | | Mery | Jane | Mery Jane | #+TBLFM: $3='(concat $1 "...
4
votes
2answers
153 views

Text substitution only in specific column of org table

I came across this problem today: I had a table with many entries and wanted to perform a text substitution (normal text substitution was sufficient as I hardly ever need regex text substitutions) in ...
0
votes
1answer
307 views

How do I ensure org-sbe is consistently passed a string when copying tables

I'm trying to transform the data from one table to another however I can't do it with built in functions so I have to use org-sbe to call some elisp: #+tblname: clues | 02a8 | 0050 | 5012 | 2225 |...
8
votes
1answer
1k views

Reference the last column / row in an org-mode table

The Situation: I read the Org Spreadsheet tutorial but couldn't find an answer. Commonly, I want to have the result of a formula in the last row of a table, i.e., have something like #+TBLFM: @LAST$...
1
vote
1answer
325 views

verbatim vertical bar in org table

I am trying to have a vertical bar inside a verbatim environment as part of an org-mode table. Following https://orgmode.org/manual/Built_002din-table-editor.html#FOOT20 I have tried this: | =find -...
1
vote
0answers
606 views

Import CSV into org-mode table, but preserve quotes around strings

I really like the ability to quickly go between CSV tables like this: a, b, c this, TRUE, 5, that, FALSE, 8 ...and org mode tables, that look like this: | a | b | c | | this | TRUE | 5 | | ...
1
vote
1answer
1k views

Orgmode Spreadsheet: update formula when adding new column

I have a small square orgmode spreadsheet with some data in it and 2 extra columns to the right with some formulas, like average and sum. I want to add some new columns in the middle of my spreadsheet ...
5
votes
2answers
189 views

Can I have a single #+TBLFM for multiple org tables?

I have multiple tables like below in an org file, but all having identical #+TBLFM lines. Is it possible to have just one #+TBLFM and have all these tables use it? #+NAME: IOC | Rate | Units | ...
6
votes
0answers
488 views

latex inside table using table.el in org mode

I am trying to achieve multicolumn cells in org-mode tables like in Multicolumn cells in org-mode tables, but with Latex inside the cells. * Minimal Example +------------+-----------+-------------...
4
votes
1answer
1k views

Preventing Org-Mode PDF Tables from Running Off the Page

Consider the following long org-mode table. #+TBLNAME: Bitcoin #+PLOT: title:"Bitcoin Return in 1,2, and 10 Years" ind:1 deps:(3 5 7) type:2d with:histograms set:"yrange [0:]" set:"style fill solid 1....
3
votes
2answers
673 views

Number-separators in org-mode tables

I often paste org-mode tables numbers that are e.g. space-separated. Then I have to delete spaces before things like =$2/2 work correctly. Is there a way to change "number format", e.g. plug in a ...
2
votes
2answers
366 views

Long tables in emacs org do not export correctly through latex-pdf

I want to export two long tables (each 6X179). I tried to export with latex-->PDF using #+ATTR_LATEX: :float sidewaystable attribute. But what I get is this result, I get just three pages pdf file (...
6
votes
1answer
2k views

Add cell background colors to org-mode table in pdf export

I'd like to be able to select a specific cell in an org-mode table and add a background color to that cell for a pdf export. Such that | This Cell is formatted normally | This cell is greyed a bit| |...
2
votes
1answer
220 views

Deleting duplicates in an org-table column

I wanted to preserve the first row value while deleting all subsequent repeated values in the sequence column ($5) as in the MWE below: | ID | M | D | P | sequence | item | |----+---+---+--...
2
votes
0answers
50 views

Re-apply table formulas on org-mode export

I'm using an org-mode file to do some filesystem monitoring. To that purpose I have a table in which I'm calling code blocks through org-sbe in the formulas. It looks like this: #+NAME: part-size #+...
3
votes
0answers
45 views

Link to column entry from org-mode text

I would like to reference a specific table entry, or have it's value insert inline in an Org document. My motivation is to avoid having to change the text in case I recompute values. Dummy example: #+...
1
vote
0answers
90 views

Org-table color entries that match a predicate

Say we have the following table: | Student | Grade | |---------+-------| | Foo | 7 | | Bar | 5.5 | | Baz | 9 | Is there a way to change the face color of an entry when a ...
2
votes
1answer
175 views

Org-mode Table, No export Latex column

Is there a way to have a column of a table not export, specifically in latex? I want to have an extra column for personal notes but when I export I don't want the table there.
7
votes
3answers
3k views

How to select (and copy) a column of an org table *without* rectangle selection?

It seems to me that the normal way to copy a column of an org table is by rectangle selection (see here). That is, first the column is selected by marking all of it by hand, and then it is copied with ...
2
votes
2answers
275 views

How to feed range from org-table filled with strings to code-block via tblfm?

Following Situation: I would like to calculate some fields from an org-table filled with strings. There are many tables which all could share the same lisp-code. The lisp-code is rather complex and ...
2
votes
1answer
136 views

How do I carry over an entire column from one table to another?

I'm trying to set up a monthly budget in org mode, and carry over the balance for each category from month to month. So I'll have something like |Category|Last |Budget|Actual|Balance| | |Month|...
6
votes
2answers
1k views

Multi-line org mode formula definitions

Org tables are great! But sometimes, for non-trivial cases, the formulas get a little unwieldy. E.g.: #+TBLFM: @III+1$3..@IIII-1$>='(let ((l (-non-nil (mapcar* (lambda (w v) (when (equal w $2) (...