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.
2
votes
1answer
31 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
42 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-...
0
votes
2answers
43 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
54 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
0answers
18 views
Recalculate buffer tables after field motion commands?
I would like emacs to automatically run org-table-recalculate-buffer-tables every time and only if
A) cursor is in a table
AND
B) after a field motion command (TAB, S-TAB or RET) OR (optionally) ...
0
votes
0answers
24 views
Using org-mode clock-report, how can I add a total row + cell with a formula that is automatically updated upon dblock update?
I am having trouble with using the formulas to create a cell that totals a column. Is it possible to dynamically add a line and a total cell to the bottom of clock report tables? because when I add a ...
0
votes
2answers
28 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 ...
0
votes
0answers
13 views
columnview vs ID
I would like to produce a table which filters by ID using columnview, is it meant to be used as a filter?
using org 9.2.2, emacs 25.2.2, linux
* columnview filter test
:PROPERTIES:
:COLUMNS: %ID ...
1
vote
1answer
47 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 ...
5
votes
2answers
87 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 |
|------+...
1
vote
2answers
68 views
Orgmode tables: Insert row within column
I would like to know, how to add a new line in a column without changing the other columns. Alternatively, how to move up a cell in a column without changing the other columns.
Here is an example (...
0
votes
0answers
17 views
Partial table fold in `org-mode`
I wonder whether it is possible to fold (as in code folding) part of a long table in org-mode.
0
votes
1answer
43 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 ...
1
vote
1answer
43 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 ...
0
votes
0answers
25 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 ...
0
votes
1answer
65 views
Calculating with timestamps in org-mode tables
Emacs 26.1
| | Start date | End date | State | Task | Duration (hours) |
|---+------------------------+------------------------+-------+----------+------------------|
|...
0
votes
1answer
35 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, ...
0
votes
1answer
21 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 | ...
2
votes
1answer
58 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
2answers
33 views
Rotate the yanking ring
I have such a table
| C | M |
|---------------------+---------------------|
| Character | Word |
|---------------------+----------...
3
votes
2answers
296 views
Orgmode table error - shrunk field?
I'm very new to Emacs and Org mode, so I'm basically fumbling around. I'm getting an alarm bell ding whenever I type in an table in an *.org file. A message says "invalid function: org-table-with-...
0
votes
1answer
51 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) |
|---+------------------------+------------------------+--...
0
votes
1answer
31 views
orgmode table time string delta with formula
I wish to calculate time string delta as below:
| date | delta |
|------------+-------|
| 2018/12/28 | 0 |
| 2018/12/31 | -1 |
#+TBLFM: $2=if(2==@#, 0, ($1 - @-1$1); %.0f
The expected ...
1
vote
1answer
92 views
Org-Mode How to position tables correctly when exporting to Latex?
I have a document I have written in org-mode which contains several tables.
The tables all have the following attributes.
#+begin_table
#+LATEX: \caption{Initial risk List}
#+LATEX: \label{tab:risk-...
0
votes
1answer
85 views
How to quickly convert text to org-mode table?
windows 10, emacs 26.1
Supose I have the following text:
OwnerKey OrganizationName GUID
111192 Infocom 41EA23423423423423423C8-62A61A1532C5
345423 TV A3B8F234234234234239FA5-...
1
vote
1answer
65 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 | ...
4
votes
1answer
483 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 ...
1
vote
2answers
81 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-...
1
vote
2answers
49 views
Separately sum positive/negative numbers?
By example:
| | Amount |
|---+--------|
| | 3.50 |
| | 1.00 |
| | -6.00 |
| | 5.00 |
| | -2.50 |
|---+--------|
| | 9.50 |
| ^ | wins |
|---+--------|
| | 8.50 |
| ^ | ...
2
votes
1answer
146 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?
2
votes
1answer
77 views
Make Org Table with #+NAME label collapsible
I have an org table with has a NAME label like:
#+NAME: TBL
| Foo | Bar |
In the past I have always been able to expand and collapse the whole table by cycling using TAB on the #+NAME line.
However ...
1
vote
1answer
74 views
org-table-copy-down for dates
Suppose I have an org-table like this:
| 2018-09-09 | | | | |
| 2018-09-10 | | | | |
| 2018-09-11 | | | | ...
4
votes
2answers
61 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
110 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 |...
5
votes
1answer
239 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$...
0
votes
1answer
42 views
after update from ubuntu 16.04 to 18.04 cannot publish project; getting “eval: Symbol’s value as variable is void: org-enable-table-editor”
It appears that I've also lost the ability to use Emacs Org basic table editing commands. For example, when I start a table with a | and add the column headings then hit TAB, Emacs returns the same ...
1
vote
1answer
99 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
162 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 |
| ...
0
votes
1answer
46 views
Capturing data on .org document to table
I have a simple template in emacs .org mode .
\begin{flushright}
Name :
Phone no:
Billed amount:
Date
\end {flushright}
• Details .........
I export the document to pdf and print it. I ...
1
vote
1answer
207 views
Org table spreadsheet use column name on left hand side
I have the following table and formulas:
| | Runde | 0 | 1 | 2 | Resultat | % |
|---+-------+---+---+---+----------+------------|
| ! | name | | | | result | percentage |
| # | ...
0
votes
0answers
28 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 ...
4
votes
2answers
114 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 | ...
3
votes
0answers
218 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
+------------+-----------+-------------...
0
votes
2answers
391 views
Org-mode: How to fix table width to page width for dynamically generated tables?
I am using dynamically generated table to create a tabulated to do list with various parameters using:
#+COLUMNS: %ITEM %SCHEDULED %DEADLINE
for more info see: Org-Agenda export to dynamic Org-Table
...
2
votes
2answers
206 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
0answers
36 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
#+...
1
vote
1answer
90 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 |
|----+---+---+--...
3
votes
0answers
34 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
73 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
54 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|...
