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
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
429 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
81 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 ...
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....
2
votes
1answer
431 views

Combine fileskip0 and stepskip0 in org mode clock tables

Is it possible to combine :stepskip0 and :fileskip0 in org mode clock tables? I can skip files with :fileskip0: #+BEGIN: clocktable :maxlevel 2 :scope agenda :block thisweek :step day :fileskip0 ...
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 ...
7
votes
1answer
444 views

Aligning org tables with rendered LaTeX formulae

Org tables do a great job in aligning columns with plain text. But the alignment is lost when math formulas (in LaTeX) in cells are replaced with their preview. Is it possible to preview LaTeX in ...
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-...
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
647 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 (...
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,...
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
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 # \...
4
votes
1answer
471 views

Vertical sum and coordinates relative to separators

In org-mode, I can sum the rows in a column as follows: | | Column 1 | | | | |---+----------| | | 1 | | 2 | 2 | | 3 | 3 | | | 4 | |---+----------| | | ...
1
vote
0answers
183 views

How to move by columns in an org table?

The title pretty much says it all. I'm looking for something similar to M-f and M-b to move right or left column-wise in an org-mode table.
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 ...
1
vote
1answer
1k views

Orgmode Spreadsheet: update formula when adding new column

I have a small square orgmode spreadsheet with some data in it and 2 extra columns to the right with some formulas, like average and sum. I want to add some new columns in the middle of my spreadsheet ...
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 | ...
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,...
8
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
817 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/ | |----------------+-----+-----+-----+------+-----+...
5
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
125 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
509 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
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
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 ...
6
votes
1answer
543 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
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 ...
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
118 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
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 | ...
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/...
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 ...
8
votes
2answers
3k 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
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 | | | | ...
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 ...
17
votes
4answers
3k 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?
38
votes
1answer
16k 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
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 ...
7
votes
1answer
1k 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
245 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 ...