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
11
votes
1answer
2k views

Org-table: is it possible to have automatic line wrapping inside org-tables?

Org-table has a very convenient property, it expands the width of a table column if needed to show all your text in a cell. Alternatively, you can set a fixed width for a table column and let your ...
3
votes
1answer
839 views

Is there a python tool for parsing org-mode tables?

I often use python scripts to parse information stored in many of my org tables. To get python to read these tables I have a script that exports specific tables from a specified org document to csv. I ...
4
votes
3answers
2k 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 ...
4
votes
2answers
116 views

Possible to Set a Frozen Row in Org-Mode Table?

I use a standard org-mode table to store a lot of my own personal data. However, the tables have gotten quite large. I need a way to have the top row stay visible. Can I set this with header-line-...
4
votes
2answers
818 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/ | |----------------+-----+-----+-----+------+-----+...
4
votes
4answers
351 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/...
1
vote
2answers
183 views

orgtbl-aggregate: how to handle periods (.) in column header names

I'm new to org mode and have been using Orgtbl Aggregate for tables. I import space-separated files as org tables, add an hline to make the first row into a header, name them with #+NAME (aside: is ...
2
votes
2answers
300 views

Concatenate ascii/org tables with some different headings

I want to concatenate two ascii tables (one below the other) that share some but not all column headings. e.g. Table 1 Head1 HeadA 1 a 2 b Table 2 HeadA HeadFoo c bar And the result ...
2
votes
0answers
26 views

Is there a way to treat an inline picture (a link rendered as an image) as one character in org table?

Is there a way to treat an inline picture (a link rendered as an image) as one character in org table? When I align an org table that has a small image in a field, the alignment gets really messy, ...
2
votes
1answer
86 views

Expand an org-table with clipped fields?

I learned that I can edit the whole clipped field in a new window with org-table-edit-field, but it's kind of annoying to open a new window each time I want to edit each field. How can I edit those ...
4
votes
1answer
37 views

Change the behavior of a function when the point is in a table

How can I change the behavior of a function when the point is in an org-table? Is there a function like "table-p" that returns true when the point is in a table (like region-active-p returns true when ...
9
votes
2answers
1k views

Generating tables with headers from code block

I would like to generate tables that have headers from code blocks. Something like this: #+BEGIN_SRC emacs-lisp :results value table :table-header | First | Second | (identity '((a b) (c d))) #+...
6
votes
1answer
965 views

How to make the org-mode exported table aligned in GMail?

I have a table maintained by org-mode, and I would like to copy/paste it to an email. So this is what I was trying to do: export to the plain text copy/paste to the gmail However, it just cannot ...
4
votes
2answers
3k views

How do I do simple addition in org mode?

I have heard that you can do math in org-mode through tables, but looking it up comes up with things about LaTeX and other confusing subjects. This is what I want to do: | | 1 | 2 | ...
4
votes
2answers
237 views

Sorting an org-table numerically, ignoring commas (org-table-sort-lines)

I have the following org-table: | Row # | Facility | Recycled Off-site | |-------+--------------------------+-------------------+ | 1 | 1234, 12th st, jamestown | 216,...
0
votes
1answer
127 views

orgtbl-to-html within HTML document

I'm learning emacs now and I've run into a problem. I would like to use orgtbl minor-mode within an HTML file and be able to update the contents of the org table as HTML code directly. I saw an ...
2
votes
1answer
559 views

Have short comments at bottom of table in org mode (beamer/latex export)

I'm trying to make a table like so: | | x | y | | a | 12 | 354 | | b | 45 | 65 | Then when I export it to pdf via beamer/latex I'd like to have a short comment below it (like Souce: www.google....
1
vote
1answer
225 views

yasnippet won't replace default values (placeholders) in org-table caption

I'm using yasnippet to create a template for org-mode tables. This works fine, and allows me to create default values (placeholders) for the column headers. The default values are highlighted by ...
2
votes
0answers
129 views

External http link not recognized as link

I have the following document: * Test | Links | |-------| | [[http://emacs.stackexchange.com/questions/ask]] | This Link is not recognized as a Link. If I press TAB while the cursor is on the link ...
0
votes
0answers
256 views

Org plot table : wrong type argument listp hline

I learn org mode following the documentation, I try to plot an array with gnuplot but get the error Wrong type argument: listp, hline. Where does it come from ? Here is the array : #+PLOT: title:"...
3
votes
1answer
430 views

How to have org-babel treat the first line of a table result as a header?

I'm dealing with a trivial shell script that invokes the mysql binary on a remote server, and having org-babel capture its results as a table. With sensitive information scrubbed, the source block ...
1
vote
0answers
82 views

org-shift[up/right/left/down] gives error on Org Clock Table pattern `yyyy-mm-dd`

I am having an issue viewing my time logged for individual days. I want to easily traverse through each day, and view the Org Clock Table for that day. When my pointer is on the clock table's config ...
0
votes
0answers
63 views

How to have both Greek Alphabet and LaTeX command of it in the same table in exported PDF (TEX)?

Just want to create a table of LaTeX command for Greek Alphabet. One column for the Greek Alphabet and one for the command. When I use \beta, it shows as Greek alphabet in the exported PDF file. How ...
5
votes
3answers
510 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 ...
1
vote
1answer
138 views

How can we convert a range of table types (latex,org) to html when org-exporting to html?

Suppose that I have 3 types of tables in an org file, A latex table, an org-table, and a html-table. How can we to export these table as html tables when org-exporting to html? # #+BEGIN_LaTeX # \...
5
votes
1answer
126 views

Use Results from Table A in Table B

I am a beginner at org-tables, trying to use them for computing grades in a class I'm teaching. I have a table showing attendance records for a student, resulting in a mean that I'd like to use in a ...
4
votes
1answer
649 views

Painfully simple org spreadsheet question

I am an English teacher who is profoundly not good at math, but I want to make some simple calculations with an org-mode table. I've tried reading online, but am afraid the explanations are just not ...
0
votes
2answers
70 views

how to move to the end of current cell?

in org mode table. I have a cell with many words, and and to append more words to the end. But how to quick move to the end of current cell?
7
votes
2answers
819 views

How to programmatically update a named org-table in-situ

It's possible to programmatically update an org table inside a babel source code block like the following: #+name: mytable | 0 | 0 | 0 | | 0 | 0 | 0 | #+begin_src emacs-lisp :var table=mytable (...
5
votes
1answer
453 views

Goto last line in org-table

In org-mode, I need a function to move point to the last row of a named table of arbitrary length. Example: From anywhere in the buffer, I would like to go to: #+NAME: table-with-unique-name |---+--...
1
vote
1answer
347 views

org-babel, org-table and package-install: “Package `dired+-' is unavailable

I'm currently using org-mode to organize my init files — specifically, working off a fork of emacs24-starter-kit. Recently, I had come across the idea of using org-tables to organize some of my things ...
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,...
3
votes
2answers
87 views

Can I import a rectangle from one org-table into another org-table?

I have an org document with two different-sized tables table1 and table2. #+TBLNAME: table1 | | | | | | | | |---+---+---+---+---+---+---| | | | x | x | x | x | x | | | | x | x | ...
1
vote
0answers
126 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 ...
2
votes
1answer
108 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
269 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
240 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
1answer
123 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 | ...
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 ...
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 ...
1
vote
1answer
121 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
81 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 ...
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
119 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 ...
0
votes
1answer
473 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
955 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 | | | | ...
10
votes
1answer
476 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/...
7
votes
1answer
599 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 ...
13
votes
1answer
747 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 ...