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
2
votes
0answers
41 views

Why are my org-table formulas behaving like this after upgrading to version 8.3?

I recently upgraded org-mode to version 8.3 from version 7.9. In previous versions of org mode, the function #+TBLFM: @<$<..@>$>=0 would place a 0 in every cell of a table. On my system,...
10
votes
2answers
4k views

org-mode table exports centered - change to left?

I'm exporting a simple org-table through LaTeX to PDF: | a | b | c | | 1 | 2 | 3 | After export with C-c C-e l o the PDF contains a centered table, and I'd rather have it on the left (to be clear, I'...
4
votes
2answers
974 views

Can't assign to hline relative reference

I have the following org-mode table: #+BEGIN: columnview :hlines 1 :id global | /Project/ | Mon | Tue | Wed | Thu | Fri | Sat | Sun | /Total/ | |----------------+-----+-----+-----+------+-----+...
6
votes
3answers
2k views

How do I insert resizebox code in org-mode tables when exporting to latex?

I'm trying to figure out how to insert a resize command inside a table environment in org-mode that exports to latex, Here is my minimal example of raw latex source vs org-mode tables: #+LATEX_CLASS:...
1
vote
0answers
131 views

How to make orgtbl-mode use org-entities in other major modes?

Org mode provides a variable called org-entities that contain replacements for latex symbols like \alpha, \beta etc. Org also provides a minor called orgtbl-mode which allows text that starts with a ...
5
votes
3answers
582 views

Display org-mode src R results horizontally

Is there a way to show the results of a Source Block horizontally, or equivalently to transpose an org-table? For example, I have the following: #+begin_src R :results table c('a','b','c') #+end_src ...
2
votes
1answer
111 views

Why is my elisp function not accepting a second parameter?

@Juancho gave a great answer to a question I asked a few days ago. My question is about how to modify his elisp code. I have an org table #+begin_src emacs-lisp :results none (defun jj/factor (...
2
votes
2answers
286 views

Can columns of an org table be grouped to conveniently work with data?

I have an org table | | | P1 | P2 | P3 | P4 | Q1 | Q2 | E1 | E2 | F | |--------+--------+----+----+----+----+----+----+-----+-----+-----| | | Totals | 20 | 40 | 35 | 20 | 50 |...
2
votes
0answers
54 views

Can an org table automatically syncronize with another org table?

I have two org tables #+TBLNAME: contact_info | Name | ID | E-Mail | |------------+-----+-----------------| | Washington | 001 | george@usa.pres | | Adams | 002 | john@usa.pres ...
4
votes
1answer
262 views

Is it possible to insert random numbers in an org table?

I have an org-mode table |----+----+----+----+----+----+-----+-----+-----| | 40 | 40 | 30 | 20 | 50 | 50 | 100 | 100 | 200 | |----+----+----+----+----+----+-----+-----+-----| | | | | | ...
1
vote
0answers
63 views

Is there a way to refile a table row or a line?

I'm using refile in a table, but it tries to move all the table, not the line I'm in, if refile cannot move a table-row i think a more general way would be to move the line itself, without knowing if ...
7
votes
1answer
615 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 ...
1
vote
1answer
122 views

org-babel not concatenating strings before sending to code block variable

I have just started using org-mode and org-babel as a lab notebook. I am trying to use a code block to fill in two columns of a table. The code block seems to work for the first column because those ...
1
vote
2answers
89 views

How can I find the buffer position of an org-mode cell?

I'm trying to create a formula that modifies overlays on an org-table. I need to figure out the position in the buffer of the cell so I can create an overlay that spans the length of the cell. How ...
4
votes
1answer
1k views

Display property value of each section in table like in clocktable

Context As far as I know it is possible to define properties for a section in a PROPERTIES drawer like this: * Introduction :PROPERTIES: :PlannedPages: 0.5 :ActualPages: 0.5 :END: You can see that ...
2
votes
1answer
1k views

Recalculating entire org-mode table with multiple sections

How can I recalculate this entire table? If I type C-u C-c C-c with point at the start of the 'End Nubbin' line, only the formula that computes the total above the line containing 'other' gets ...
2
votes
1answer
124 views

How to delete a huge org-table

I forgot to type :results none in babel and now I have a huge table in my org file. How can I select all of those lines and delete them? When I try the straight forward approach of moving to the end ...
1
vote
1answer
125 views

How to force Org to interpret Calc result as a column?

Here's an example: | low | high | students | F(students) | |-----+------+----------+-------------| | 0 | 30 | 15 | 15 | | 30 | 60 | 30 | 45 | | 60 | 70 | ...
4
votes
4answers
371 views

org-table, how to compute Coefficient of Determination between two time fields?

I have two time fields. My productivity and sleep. I would like to run a Coefficient-Determination (As described here: http://www.r-tutor.com/elementary-statistics/simple-linear-regression/...
5
votes
3answers
3k views

Exclude table in org-mode export

While I enjoy the table mode of org and love the way I can work with the data in these tables with eg Python or R I am currently stuck with a simple problem: How can I exclude the table from being ...
10
votes
2answers
4k views

Is it possible to copy /paste multiple lines of text into cells of org-mode table?

Here is my question, I have multiple lines of text, line this: line1 line2 line3 ... And I want to create a org-mode table like this: | C1 | |-------| | line1 | | line2 | | line3 | | .... | ...
0
votes
1answer
485 views

Re-arrange columns in agenda clockreport?

My Agenda clock-report is kinda wide and columns are all over the place. My agenda clock report plist is as following: '(org-agenda-clockreport-parameter-plist (quote (:tcolumns 2 :level\ ...
6
votes
1answer
984 views

Remove Task state keywords (TODO/DONE) from clocktable reports?

Org-mode's Clocktable reports show the task state "TODO/OPEN/DONE" at the beggining of the headline: like so: | | TODO Bug 459487 - [GTK] Replace... | 7:38 | | | | ...
7
votes
1answer
625 views

org-mode : in a table, calculate a person's age based on their birthday

Let's say I have the following table: | Name | Age | Date of Birth | Income | |--------+------------------+------------------+--------| | Joe | | <1984-02-20 ...
20
votes
5answers
4k 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?
39
votes
1answer
18k views

Multicolumn cells in org-mode tables

Is it possible to merge two or more cells in an org-mode table like when using \multicolumn{}{}{} or \multirow{}{}{} in LaTeX? Something like this does not work: |------------+-----------+----------+...
4
votes
2answers
3k views

Correct markdown-format tables with orgtbl-mode?

I'm just learning about org-mode, and of course blown away by its sheer level of usability. I of course want to use it everywhere, so I want to create tables with it. Including tables in markdown-mode....
13
votes
1answer
830 views

Is it possible to have the entire org-table use math environment?

I have an org-mode table that needs to have some math text in each cell. Wrapping every cell with $ both looks ugly and takes much more space than it deserves. Is there any way to somehow put the ...
7
votes
1answer
2k views

Sorting an org-mode table with horizontal lines

I have a table in org-mode which has the following format: | Name | email | number | |------------+-----------------+--------| | Doe, John | jod@example.org | 7 | | Doe, Jane | ...
2
votes
2answers
261 views

Org Mode: org-lookup-* functions missing

The functions org-lookup-first, org-lookup-last, and org-lookup-all do not seem to be available to me. These functions are documented at the following link: Lookup Functions. I can't look them up in ...
11
votes
1answer
892 views

Org Mode: Using table formula outside of a table?

I'm wondering whether it's possible to display the result of calculations performed on table data, outside of a table. For example, suppose I have a table of with a list of names. Is it possible to ...
6
votes
1answer
2k views

Create table for existing data using org-mode

Is there a way of creating table for existing data using org-mode ? Let's assume I have the following data row1 row2 row3 And now I want to create a table of dimension 1x3 (col*row) on it. The ...
6
votes
1answer
739 views

time value in org-table formula

Is there any way to have time constant in an Org spreadsheet formula? For example, i would like to have something like this: @>$3=@>$5-'08:00:00'*vcount(@2..@-1) to calculate how much longer I'...
11
votes
5answers
847 views

Preview fields in org table

Sometimes it is convenient to set a manual column width when creating a table in org-mode. This makes it so that columns do not have to grow to the size of their longest entry. When an entry in and ...
10
votes
1answer
529 views

Truncate beginning of right-aligned column in org table

I have a column in an org-mode table that contains long file names. The interesting part of the filename is the last few characters rather than the first. For example, given the files below: /data/...

1 2 3 4 5
6