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
4
votes
2answers
177 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
431 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
986 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 ...
3
votes
2answers
551 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
47 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
181 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
41 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
122 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|...
4
votes
2answers
750 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) (...
3
votes
1answer
64 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
63 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
2answers
547 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 ...
6
votes
1answer
477 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: $...
13
votes
3answers
9k 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
120 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
153 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. ...
2
votes
0answers
353 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
1k 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
231 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
223 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 ...
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....
7
votes
2answers
2k 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
1answer
980 views

Exporting Org in Landscape

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
2k 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
157 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.
1
vote
0answers
30 views

Disabling the special meaning of either `+` and/or `|`

I came across a case where strike-through and table interfere with the proper operation of org-links (which, in my case are org-ref citations). Here is a minimal example: +-+ |cite:VemulaMO2016c-Path-...
1
vote
1answer
67 views

Get unique names from table colum

I have one table (TBL1), I want to generate another table with unique items from TBL1. Currently, I can do it with elisp as below but I think it's too complicate. #+NAME: TBL1 | Item | Amount | |-----...
13
votes
1answer
4k views

What is the difference between sh and shell for org-babel?

I'm experimenting with sourcing data from org-mode into my shell scripts and I've run across a weirdness: #+tblname: simple-table | 1 | | 2 | | 3 | | 4 | | 5 | #+name: work-with-simple-list-shell #+...
0
votes
0answers
192 views

Org-table and multiple plots

Is it possible to have several plots related to one Org table? I have noticed that #+plot: ... file:"file1.png" #+plot: ... file:"file2.png" #+plot: ... file:"file3.png" . . . |col1|...|colN| |.... ...
1
vote
1answer
55 views

Elisp how to tell if my cursor is inside an org-table?

I have some code that activates hydras based on modes. I can do the following for org-mode: (when (eq major-mode 'org-mode) (hydra-org-nav/body)) I would like to see if I'm in an org-table and ...
2
votes
1answer
258 views

display lines from org-table on org-agenda

I'm wondering if it is possible to display lines from an org table on my agenda. Suppose I have an org file with the following content: * expense | <2017-08-17 15:11> | 13.00 | barber | :care:...
2
votes
1answer
88 views

Why did cell in org table turn into elisp statement and column TBLFM?

I've been using org-mode everyday at work for 3 years and recommend that everyone to do the same. But today, I unintentionally triggered a column function which replaced the cell value with an elisp ...
1
vote
1answer
165 views

Using org-lookup-last to look up values in a table

I have two tables. One table has a column ($2) of unsigned integers (#+NAME: ATTRIBUTES). One table is a lookup table (#+NAME: ATTR-LOOKUP) which takes each value from Column $2 in ATTRIBUTES, and ...
0
votes
2answers
421 views

Org-mode cross references disrupted by ATTR_LATEX?

I have a couple of tables in the following runnable, complete, self-contained example, and I can successfully "forward-reference" them by name in the text: Table [[tab:line-word-byte-count]] tells us ...
2
votes
2answers
524 views

org-babel problem printing separator rows to org-mode table

I found here in the org manual how to output from an org-babel source-code block to an org-mode table, namely through something like #+header :results output table I have had some trouble getting ...
2
votes
2answers
245 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 ...
0
votes
2answers
358 views

how to get reference to other tables working with field references?

I'd like to create a summary table for tables of months (months are just one possible use of the summary table). The months have some informations and a count column. The summary count of every month ...
1
vote
1answer
40 views

Running elisp conversion function in an Org table returns an error

For a table I would like to convert the first column from decimal numbers to binary. The table looks so far like this: | . | . | . | . | . | | . | . | . | ...
4
votes
2answers
821 views

org mode - add formula to generate delta column

How can I get below result with org table formula? The number of rows maybe too many, so doing it line by line is not good way. For example: @1$2 = @1$1 - @1$1 @2$2 = @2$1 - @1$1 @3$2 = @3$1 - @2$1 ...
2
votes
1answer
503 views

Function to paste text as a orgmode table

I'm wondering if anyone knows of a way to have a function (that I can bind to a key) that pastes the current text in the clipboard as a formatted org table? Also as a bonus (since this is used to ...
2
votes
1answer
494 views

Insert column in org-mode moves the content

I am trying to insert a column in a table in org-mode and I get the content moved. For example, I have this table: | Name | Age | |--------+-----| | Tarzan | 40 | | Jane | 39 | Now I want to ...
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>...
1
vote
1answer
284 views

Exporting a single column of an org-table

I want to export (not sure if that's the right word) a single column of an org-table as text, with the elements separated by commas. Eg if the table is | x | y | |----+----| | 0 | 1 | | 2 | 3 | ...
1
vote
0answers
714 views

The org-mode table alignment issue in right-to-left languages

I really enjoy writing bidirectional text in org-mode using Emacs as it supports the rt-to-left direction out of the box. However, when it comes to org tables alignment things become very unorganized. ...
5
votes
1answer
1k 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| |...
1
vote
0answers
359 views

How to fold a cell of table in org mode?

In an org-mode table, I have a cell with a long line of text. How do I fold that line/cell so that its column won't be too wide on the screen?
4
votes
1answer
804 views

How to return an org mode table with headings and hline from Ruby

I have the same question as this question except that I don't see how to do so other than in elisp. I am using Ruby, but I suppose the question applies to other languages as well. If I return an ...
1
vote
1answer
239 views

Is there any way to use just year and month as timestamp in org-mode?

Specifically, I'd like to sort a column in a table in org-mode. However, the column only has year and month information, like 2016-02 or May 2016. It can't sort for now as it's not recognised as ...
4
votes
1answer
135 views

How to <return> in a org table?

Instead of | | some value | |-- +--------------------| | a | aaaaaaaa | |---+--------------------| | b | bbbbbbb bbbbbbbbb | |---+--------------------| I want | | some ...