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.

57 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
7
votes
0answers
606 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 +------------+-----------+-------------...
3
votes
0answers
91 views

Export an org-mode table to pdf/png image

I've started using org-roam more often recently, and I use LaTeX a lot in my workflow. What I want to do is this: Create a table in an org file with some LaTeX math symbols, using the org-mode table ...
3
votes
0answers
46 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: #+...
3
votes
0answers
344 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 ...
2
votes
0answers
38 views

Freeze column for org table

Is there something like org-table-sticky-header, but for columns? Context: I am trying to create a table like this and add columns to it every day: I already figured out that I need toggle-truncate-...
2
votes
0answers
267 views

How to Change the font for org-date face in org-table context?

I like to have a variable font everywhere I can, but some things like tables in org-mode or the org-agenda itself look a little wonky that way, and I get around it by configuring specific fixed width ...
2
votes
0answers
64 views

org-table: hide grid lines

I like how org-mode allows me to quickly create and edit tables. However, I do not like the table's appearance and I would like to modify it. Customizing the face only lets me change foreground and ...
2
votes
0answers
786 views

Import CSV into org-mode table, but preserve quotes around strings

I really like the ability to quickly go between CSV tables like this: a, b, c this, TRUE, 5, that, FALSE, 8 ...and org mode tables, that look like this: | a | b | c | | this | TRUE | 5 | | ...
2
votes
0answers
61 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 #+...
2
votes
0answers
523 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?
2
votes
0answers
1k 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. ...
2
votes
0answers
185 views

Links inside org-mode tables are not typeset in monospaced font

While the default is a proportional font, I told org-mode to use a monospaced font in tables: (add-hook 'org-mode-hook (lambda () (variable-pitch-mode t))) (with-eval-after-load 'org (set-face-...
2
votes
0answers
294 views

Add org-mode clocktable column that is the product of a constant and the Time column

Here's a snippet from an optimistic org-mode file #+CONSTANTS: rate=100000.0 #+BEGIN: clocktable :maxlevel 2 :scope file :narrow 60! :header "#+NAME: billed #+attr_latex: :align l|r|r|r|r :...
2
votes
0answers
29 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
0answers
135 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 ...
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,...
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 ...
1
vote
0answers
35 views

How to output orgmode julia DataFrame as orgtbl?

In the following link, we see that we can use a table package in Python to return in orgtbl format. #+begin_src python :results value raw :output :return tabulate(df, headers=df.columns, tablefmt='...
1
vote
0answers
28 views

Org mode: How to restrain an inline image size in a table?

I'm only interested in restraining the image size directly inside the org file and not for exportation. When the image is outside of a table it's easy to render it reduced with: #+ATTR_ORG: :width 100 ...
1
vote
0answers
70 views

using org table as yasnippet input

I'm using yasnippets to create code blocks in org mode to document and execute DevOps activities. To improve productivity, it would be nice to have a possibility to create org tables with rows of ...
1
vote
0answers
32 views

Dealing with a table with too many row in org-mode

When a table gets too long, how can you deal with it? Is there any way of collapsing parts of it? Or maybe dividing it in multiple tables and still perform operations (like adding a column) on all of ...
1
vote
0answers
857 views

Merge two cells in an org table

I basically stumbled onto this older question how to merge cells in an org-table. This would be very useful to create a header, something like: |Merged header| |----+--------| | / | < | | 1 ...
1
vote
0answers
37 views

Spaces get trimmed when I use org table in (R) code block

Please, help! I use literate programming and I want to use org-mode tables as data for my R code blocks. However, when it comes to cell values that have meaningful leading and trading spaces org-mode ...
1
vote
0answers
72 views

Insert the same item in multiple rows in orgmode

I would like to be able to insert the same string in consecutive rows of some column of an org-table. I am using spacemacs and there is a vim way to insert the same instances in all visually selected ...
1
vote
0answers
93 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 ...
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
0answers
488 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?
1
vote
0answers
1k views

TAB key is not working in my Org-mode table

I'm customizing my emacs using literate programming within org-mode. So far, It is going Ok, except that the org table align is not working properly if I press the <TAB> key... even worst, the ...
1
vote
0answers
84 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 ...
1
vote
0answers
199 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
0answers
132 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 ...
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 ...
0
votes
1answer
33 views

How do I group by and aggregate orgtable more efficiently?

I have the following org table where I actively record columns 1,2,3,4 and the remaining columns are calculated from the first four. Using this I calculate the aggregate from the last three columns ...
0
votes
0answers
35 views

How to format org table field while keeping numeric value for other formulas?

Say I create a table like this: | Number | Share price | Total | |---------+-------------+----------| | 500 | 6.90 | $3450.00 | And that 3rd field is calculated. If I use the formula $...
0
votes
0answers
27 views

How to capture the column sort in Org-mode inside a formula?

Let's say, I have a following table: |-------+---------| | NAME | VALUE | |---------+-------| | DAVID | 3.83 | | JULIA | 0.89 | | ALICE | 0.59 | |-------+---------| | SUM | ...
0
votes
0answers
38 views

nest org-mode tables

I have some data which is most naturally represented like so: | thing 1 | thing 2 | thing 3 | | TABLE 1 | TABLE 2 | TABLE 3 | where TABLE i is an org table. I've been over most of the documentation ...
0
votes
0answers
18 views

How can I localize the calculation of org-table dates?

I have an org table I use to plan some dates every weeks. So I fix the first tuesday date of the month and add seven days the following rows. Unfortunately I want the dates to be in french (Mar.) and ...
0
votes
0answers
24 views

How to export tables in a xltabular environment to TEX/PDF without xltabular being nested in a "table" environment?

My goal is to have a table, which can be customized with tabularX (width == textwidth), can break over multiple pages and is able to have zebra stripes (xcolor). I tried many packages, even the (...
0
votes
0answers
50 views

org-mode table as function

I have the following question regarding org-mode tables: I have the following simplified org-mode table with: A,B as arguments or parameters and C1, C2 results or return values. #TBLNAME: function | ...
0
votes
0answers
43 views

Move a row of a table.el table

I have this org-mode table, which apparently is a table.el table: +-----+------+ | Test|Foobar| +-----+------+ | | | +-----+------+ When I hit Tab in any cell, emacs tells me: Use ‘C-c '’ to ...
0
votes
0answers
28 views

formatting a org-table formula result

I would like to calculate the time in this table: | Start | End | Sum | Second Sum | |-----------------------+-----------------------+-----------+------------| |...
0
votes
0answers
21 views

Org mode tables with Devanagari characters look misaligned

Here is the table: |----+-----------| | No | Name | | 1 | Mumbai | | 2 | मुंबई | | 3 | पुणे | | 4 | उस्मानाबाद | |----+-----------| With devanagari characters, the table cell ...
0
votes
0answers
36 views

Why is a TAB character added when using kill-rectangle and yank-rectangle to insert multiple rows into an org-mode table?

I noticed an annoying behaviour when copying multiple rows (a list) from a web page into an org-mode table, following a process inspired by Is it possible to copy /paste multiple lines of text into ...
0
votes
1answer
45 views

How to control image sizes inside of table

I know that you can write something like: #+attr_html: :width 250 px [[./linl/to/image.jpg]] But what if I have them inside of a table like: | [[./linl/to/image.jpg]] | [[./linl/to/image2.jpg]] | ...
0
votes
0answers
109 views

How can I use calc to convert in orgmode table

I am trying to use calc convert in an org mode table. The gnu manual suggests $c/$1/$cm So in my table I tried (for column formula =$c/$1/$cm also tried =$1/$c/$cm, =$1/$m/$cm etc Which produces #...
0
votes
0answers
39 views

How to insert quotations in Org tables?

In org mode, how does one insert a quotation in a table cell? I know that #+BEGIN_QUOTE ... #+END_QUOTE is the way to go outside a table, but I can't find a way to use it inside a table cell.
0
votes
0answers
375 views

Time-formatted output from org-table date- and time calculation?

I have an org-table for my timesheets. Part of it looks this: | Start | End | End - Start | | <2020-03-05 10:00> | <2020-03-05 Thu 14:30> | 0.1875 | #+...
0
votes
0answers
55 views

How to make Alt-h work in Org mode in Spacemacs?

When inside a table in Org mode, I can press Alt-l to move the column to the right. But alt-h does nothing. The same happens when I try to put the heading one level deeper. Alt-l works but alt-h ...
0
votes
1answer
93 views

How to unpack a tuple from org-sbe evaluating a python code block into multiple columns of a org-table?

I often encounter situations where I can easily think of python code that, given some input values, computes multiple output values at once. As an example, consider the following simple code-block ...
0
votes
0answers
74 views

Org-table misaligns with Chinese data

Org table vertical lines do not align properly with Chinese data. | 標題一 | 標題二 | 標題三 | |----------+--------------+----------| | 中文圖表 | 直線會對不準 | 像這樣子 | | 這 | 是不是 | 問題 | | ...