Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

1
vote
1answer
30 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
42 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
46 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 | ...
0
votes
0answers
14 views

How to compute active timestamp from inactive in org-table?

I have a table with timestamps of some events and maximum allowed duration. I would like to have the deadline computed and displayed in agenda (ideally as deadline, but simple active timestamp is ...
4
votes
1answer
108 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
45 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
44 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
49 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
13 views

Formula Results In Errors When Non-English Character In Table Header

Below is the table I created. It appears that if the second column header contains non-English characters, the result of the formula produces "#ERROR". Change 列 2 to English then everything works fine....
2
votes
1answer
59 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 ...
0
votes
1answer
37 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
46 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
42 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 |...
2
votes
1answer
60 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
30 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
42 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 -...
0
votes
0answers
8 views

Generating a Table of Children from Point (Org-Mode)

Suppose we have * Parent <---- point is here ** Child1 :PROPERTIES: :P: 0.1 :END: ** Child2 :PROPERTIES: :P: 0.2 :END: *** Grandchild1 How can one use elisp (or some other trickery) to generate ...
1
vote
0answers
72 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
32 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
133 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
25 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
91 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 | ...
2
votes
0answers
139 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
239 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
133 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
33 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 #+...
0
votes
1answer
58 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
28 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
67 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
47 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|...
2
votes
2answers
247 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) (...
0
votes
0answers
26 views

How to do org-mode cross table formulas? [duplicate]

If I have 2 separate tables in an org-mode doc is there a way to reference fields between them? * Table 1 |----------+------+------------+---------| | 12/20/17 | Thing | coolidge | 158.46 | |------...
3
votes
1answer
56 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 "...
1
vote
1answer
43 views

Is there a simple way to “drop” scores from a mean function in org-mode?

I have an org table: | Student | Score 1 | Score 2 | Score 3 | Score 4 | Score 5 | Mean | Mean (Lowest Two Dropped) | |---------+---------+---------+---------+---------+---------+--------+----------...
0
votes
0answers
64 views

How to orgtbl send radio table to receiver in another file

I have an org-mode file with a number of interrelated tables inside. A few of these tables need to be exported to LaTeX files for final formatting. The orgtbl-mode radio tables work very for tables ...
0
votes
2answers
237 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 ...
4
votes
1answer
147 views

Org-Mode: Using Source Code Blocks in Table Formulas

I would like to use source code blocks in org-mode table formulas using something similar to: #+NAME: square #+BEGIN_SRC python :var x=0 return x**2 #+END_SRC | 1 | 1 | | 2 | 4 | | 3 | 9 | #+TBLFM: $...
0
votes
0answers
29 views

orgtbl-to-latex force some variable in math-mode

in a LaTeX document, orgtbl-to-latex exports \pi or \infty as \(\infty\) and \(\pi\). That is an error because the environment is already in math mode. example \begin{displaymath} \begin{array}{...
6
votes
2answers
2k 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
48 views

evaluation of calc formulas in orgtbl?

in calc mode, 'subst (2 * x, x, 5)' is evaluated to 10, but in an orgtbl table the formula is evaluated incompletely to '2 5'. How to force evaluation into orgtbl-mode? Here is my example: |-----+----...
0
votes
1answer
92 views

Get Org Link Description From Table Column of Links

I have an org table and I want to take an existing column of org links of the form: [[http://blah.com/blah/blah/foo][foo]] And create an adjacent column containing only the description - i.e. foo. ...
0
votes
0answers
104 views

Plotting a chart from org table

org mode is very good in plotting table. But is there any way of creating line plot from the table directly in org mode?
3
votes
2answers
691 views

`org-mode` doesn't align column bars properly

When I make tables in org-mode, if the column value in the next row is longer, after pressing TAB, the new vertical alignment of "|" gets a bit distorted. This used to work fine before, it also works ...
0
votes
1answer
159 views

org-mode table editor behaves strangely

With cursor in row 2, col 3 | a | b | c | | 1 | 2 | 3 _| Pressing <TAB> creates a new row: | a | b | c | | 1 | 2 | 3 | | | | | Type more than one character and press tab. Vertical ...
3
votes
0answers
83 views

Managing large volume tabular data

I have an index of digital media (books, movies, etc.) containing name, author, year, pages, etc. which I maintain in an Org file as a table. I preferred Org mode because I had a lot of stuff in my ...
2
votes
1answer
224 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....
4
votes
2answers
845 views

Org mode: Using todo-items or checkboxes in tables

I have several items that I need to perform the same tasks on. To get an overview, I wanted to use a table, where the columns would show me how many are done, something like this: +------+------------...
3
votes
0answers
271 views

Exporting Org in Landsacpe

I have an org document I'd like to export to PDF - with several wide tables columns in it - so much so that it makes sense to export the whole document in A4 landscape to keep the orientation ...
2
votes
2answers
638 views

Quick calculation in org-mode table

I used to think that you can just type =13*57 into an org-mode table's cell, hit Tab or Ret, and have it enter the result for you. Today, I learned that this isn't true the hard way as I used this a ...
2
votes
1answer
91 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.