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
2answers
359 views

Table formula for dates delta

Here my org table: | | Start date | End date | State | Duration | |---+------------------------+------------------------+-------+----------| | # | <2019-01-02 Wed 10:...
37
votes
1answer
15k 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: |------------+-----------+----------+...
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>...
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 ...
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 | ...
2
votes
1answer
514 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....
11
votes
2answers
2k views

How can I filter table in org mode

For example, I want to filter table that make it shows the row which only contains "USA" string in the column 3 and 4.
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))) #+...
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....
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 ...
10
votes
1answer
439 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/...
6
votes
1answer
916 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 | | | | ...
6
votes
1answer
479 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: $...
5
votes
1answer
2k 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 ...
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 ...
3
votes
1answer
992 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 ...
3
votes
1answer
586 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?
2
votes
1answer
106 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
261 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
126 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 ...
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 #+...
12
votes
2answers
866 views

Align columns in Org mode table with Japanese fonts

How can I mix Japanese and English in the same org-mode table (that uses fixed-width fonts)? Something like: | m m m m m m | | | はどう デシウ | | | ハーフ | ハーフ | won't align. ...
6
votes
1answer
503 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 ...
4
votes
3answers
1k views

Conditionally calculate the sum of a column depending on a fields value in another cell of the same row

In orgmode, I do have a table like the following to track my overall working time a day. It is not important for which tasks or projects or even which client I spent my time on, just if I was in ...
3
votes
1answer
208 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 | ...
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 ...
1
vote
1answer
127 views

Naming the result of a source block

The following question has been asked (in slightly different form) in a comment of another answer: Is it possible to name the results of a source block with #+NAME: foobar (or equivalently but old-...
0
votes
1answer
232 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 ...
5
votes
1answer
686 views

org mode table formatting issue

Using a simple keyboard macro, I copied the Font Awesome Cheat Sheet into an org table. However, I experience some weird inconsistencies when it comes to the formatting - see the picture below: Any ...
1
vote
1answer
166 views

org-mode table layout

hi i'm new to emacs and i'm really amazed about the org-mode. But i have some problems with the tables. i want a nice looking table but i get always a strange format example: But i want it like ...
1
vote
1answer
129 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 # \...
1
vote
1answer
582 views

Calculating with timestamps in org-mode tables

Emacs 26.1 | | Start date | End date | State | Task | Duration (hours) | |---+------------------------+------------------------+-------+----------+------------------| |...
0
votes
2answers
548 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 ...
0
votes
2answers
995 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 ...